2 Replies Latest reply on Mar 31, 2014 9:49 AM by Francisco Amores

    How to check user POV Period and Year in mapping script?

    karnie

      Hello

       

      I like to use Period and Year information in mapping scripts.

       

      e.g.: If I am loading data to March, I like to use Custom 3 Q1 dimension. So I like to check my active period from user POV in my C3 mapping automatically like in Import Script, something like this:

       

      Select case Month(dblPerKey)

      Case 1 to 3

           Result = Q1

       

      Case 4 to 6

           Result = Q2

      ......

       

      Test results with dblPerKey:

      It seems that if I use Import Script, then dblPerKey contains value, but when using map script, then dblPerKey is empty. At least when I tested this, script returns 1899 from "result=Year(dblPerKey)"  script.

       

      Summary:

      In Import script: Year(dblPerKey) returns year accordingly from user POV selection

      In mapping script: Year(dblPerKey) returns always 1899

       

      Question: Is there a way to check user POV in mapping scripts?

       

      Many thanks for your answers

      br

      Karnie