Skip to Content
0
Former Member
Jul 25, 2016 at 08:08 AM

TMVL parameter on SAP BPC

431 Views

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

Attachments

Capture.PNG (6.0 kB)
Capture2.PNG (7.6 kB)