Skip to Content
0
Former Member
Aug 01, 2016 at 08:32 AM

TMVL dynamic offset value

155 Views

Hi experts,

I'm a beginner in SAP BPC Script Logic and İ'm trying to use the offset value in TMVL parameter from another calculated dimension .

My code is as follows bu not working for last formula :

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

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

*SELECT(%ENDDATE%,ENDDATE,CATEGORY1,"ID= %SCENARIO%")

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

*SELECT(%PROMPT%,ID, ACCOUNT1,"ID='6000'")

*XDIM_MEMBERSET CATEGORY1 = %SCENARIO%

*XDIM_MEMBERSET ENTITY1 = 1000

*XDIM_MEMBERSET ACCOUNT1 = 2000 //*********************number of prompt date (in month ) ACCOUNT1 = 6000

*XDIM_MEMBERSET CLIENT1 = A_MUS,B_MUS //*********************number of months of maturity , ACCOUNT1 = 6000

*XDIM_MEMBERSET CURRENCY1 = NA_PB

*XDIM_MEMBERSET MODUL1 = NA_MOD

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

*WHEN ACCOUNT1

*IS 2000

*REC(EXPRESSION = Math.round(([ACCOUNT1].[2000]+14)/30) ,ACCOUNT1=6000) //instead of round up function i used this function

*ENDWHEN

*COMMIT

................................

*XDIM_MEMBERSET CATEGORY1 = %SCENARIO%

*XDIM_MEMBERSET ENTITY1 = 1000

*XDIM_MEMBERSET ACCOUNT1 = 9000 //******************** Endorsement, ACCOUNT1 = 10000

*XDIM_MEMBERSET CLIENT1 = A_MUS,B_MUS

*XDIM_MEMBERSET CURRENCY1 = EUR,TRY

*XDIM_MEMBERSET MODUL1 = A_MODUL,B_MODUL,C_MODUL

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

*WHEN ACCOUNT1

*IS 9000

*REC(EXPRESSION = %VALUE%*([ACCOUNT1].[13000]), ACCOUNT1 = 10000 )

*ENDWHEN

*COMMIT

*XDIM_MEMBERSET CATEGORY1 = %SCENARIO%

*XDIM_MEMBERSET ENTITY1 = 1000

*XDIM_MEMBERSET ACCOUNT1 = 10000 //************amount of collection, for B_MUS , HESAP1 = 11000

*XDIM_MEMBERSET CLIENT1 = B_MUS

*XDIM_MEMBERSET CURRENCY1 = TRY

*XDIM_MEMBERSET MODUL1 = A_MODUL, B_MODUL, C_MODUL

*XDIM_MEMBERSET TIME1=TMVL(%PROMPT%,2016.01), %PERIODS%, %ENDDATE%

*FOR %TIME1%=TMVL(%PROMPT%,2016.01), %PERIODS%, %ENDDATE%

*WHEN CLIENT1

*IS B_MUS

*REC(FACTOR=1, ACCOUNT1 = 11000)

*ENDWHEN

*NEXT

my target is to shift the time due to the number of months of maturity as follow :

Tahsilat tutarı : amount of collection

A MUSTERI : A_MUS (client A )

B MUSTERI : B_MUS (client B )

OCAK , SUBAT , .... : 2016.01,2016.02,..... ETC

Any help ?

Thank you in Avance

Regards

Ayse

Attachments

Capture2.PNG (7.7 kB)