Script logic - How to use Time Offsets?

[Former Member]

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

[Former Member · Accepted solution]

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)

[Former Member · Accepted solution]

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.

[former_member681740]

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

[Former Member]

Hello Youming Zhao,

I did not have a chance to pursue this issue since then.

I will let you know if I find something on this.

Thanks

[vinoo_gan]

Try EVTIM ()

[former_member681740]

Hi Sanjay Kumar ,

I have soloved this question . I have enhanced the *select Script Logic.and now it support to write as:

*select(%time_prev%,ID,TIME,[ID]=%TIME_SET%)

and In our system (BPC SP04), I have modify the standard coding. I hope this can help you !

Yours youming.zhao

[former_member681740]

Hi VinooGAN,

Our question is in Logic Script.Not in BPC client.So EVTIM() can't change the Logic Script variable.

thanks.

Yours youming.zhao

[Former Member]

Thanks, Youming.

[chemicala_srimallikarjuna]

Hi,

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

*Rec(Time=Time.Next)

Regards

CSM Reddy