Skip to Content
avatar image
Former Member

Script logic - How to use Time Offsets?

I was wondering if there are examples of script logic using offsets for time dimension.

I am trying to use some of them like PRIOR,NEXT etc without much success.

For example, the following logic fails when when trying to validate the logic with the error Member "NEXT" does not exist

*WHEN ACCOUNT

*IS "Commission"

*REC(TIME=NEXT)

*ENDWHEN

Can someone provide samples if they have some of this logic.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 16, 2009 at 01:51 AM

    Prior and Next are properties of the Time dimension, where you must set the property value to be the corresponding member ID.

    There's a thread on this in the BPC MS forum, in the last few days, with some samples. The syntax should be the same for BPC NW. Take a look at that.

    Also, I believe the syntax is

    *Rec(Time=Time.Next)

    and I'm not 100% sure that the following is supported:

    *Rec(Time=Next)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanks.

      I tried the code using Time.Next - it continues to give an error. I also tried using mixed case.

      I will look at the MS forum.

  • avatar image
    Former Member
    Jul 16, 2009 at 06:15 AM

    Hi,

    I think it is related to case.The BPC NW version is fully case sensitive.

    *Rec(Time=Time.Next)

    Regards

    CSM Reddy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2009 at 03:38 AM

    Hi Sanjay Kumar ,

    Do this question has been soloved? Now ,I am wondering the same questions.

    How to use the time offset?

    If yes,could you give me the idea? thank you very much!

    Yours youming.zhao

    Add comment
    10|10000 characters needed characters exceeded