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