TMVL parameter on SAP BPC

[Former Member]

Hello experts,

I'm a junior in BPC, ı was trying to offset the months in Script Logic, in other words the image of the work that ı want to do is :

OCAK : January , SUBAT :february , ....

ı wrote a formula but it didn't worked exactly:

//************ for  A_MUS (client A)

.

.

.

.

*XDIM_MEMBERSET DONEM1 = %STARTDATE%,%ENDDATE%,%PERIODS%

*FOR %DONEM1% = 2016.01, 2016.02,2016.03, 2016.04,2016.05, 2016.06,2016.07, 2016.08, 2016.09 ,2016.10, 2016.11, 2016.12

*WHEN HESAP1                                                                    //account

*IS 10000

*REC(FACTOR=1, DONEM1=TMVL(1,%STARTDATE%))         // time

*ENDWHEN

*NEXT

*//************for  B_MUS (client B)

.

.

.

.

.

*XDIM_MEMBERSET MUSTERI1 = B_MUS                                        

*XDIM_MEMBERSET CURRENCY1 = TRY

*XDIM_MEMBERSET MODUL1 = A_MODUL, B_MODUL, C_MODUL

*XDIM_MEMBERSET DONEM1= TMVL(1,%STARTDATE%)                                    /// Time

*FOR %DONEM1% = 2016.01, 2016.02,2016.03, 2016.04,2016.05, 2016.06,2016.07, 2016.08, 2016.09 ,2016.10, 2016.11, 2016.12

*WHEN HESAP1

*IS 10000

*REC(FACTOR=1, DONEM1=TMVL(1,%STARTDATE%))

*ENDWHEN

*NEXT

the view of this formula is :

Any help ?

Thank you in Avance

Regards

[former_member186498 · Accepted solution]

Hi Ayse,

are you sure you are using MS version of bpc? In MS version TMVL does not exists, if you are using NW version please close this thread and reopen it in NW version.

Is not clear what do you want to obtain, if you want to add the value to the next month just use the NEXT function, see please Time-Shift Instructions

Regards

     Roberto

[Former Member · Accepted solution]

Thanks Roberto !

I didn't notice that i posted my question under the title of MS version of bpc, it was the first title, now i'll post the question under the title of NW version. 

Regards

Ayse

[former_member186498 · Accepted solution]

ok Ayse, then please close this thread.

Thanks

     Roberto

[Former Member]

Yea....TMVL is not supported in MS version if using NW...Please post your query on NW version here

Regards,

JP

[Former Member]

Hello Ayse.....

First please explain verbally what is it you want to achieve through this script?? Scenario!

Second - where have you defined the parameters %STARTDATE%,%ENDDATE%...etc???

What is DONEM1? Time dimension?

Regards,

JP

[Former Member]

Hi JP ,

DONEM1 : time dimension

MUSTERİ1 : client (user defined )

ı've defined the parameters %STARTDATE%, %ENDDATE%, PERIODS% and the scenerio :

*SELECT(%SENARYO%,ID,CATEGORY1,ID='Budget')                                      

*SELECT(%STARTDATE%,STARTDATE,CATEGORY1,"ID= %SENARYO%")                     

*SELECT(%ENDDATE%,ENDDATE,CATEGORY1,"ID= %SENARYO%")                     *SELECT(%PERIODS%,ID,DONEM1,"ID>%STARTDATE% AND ID<%ENDDATE% AND LEVEL='MONTH'")   

it's a demo of sales query (if ı'm not mistaken) and trying to time-shift though this script.

however, i'll post my question under the title of SAP NW (that i'm exactly mistaken) and rewrite the question as english variables DONEM1, ... etc.

Thanks a lot

Regards Ayse Aydemir