on 08-01-2016 9:32 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I hope this is simpler then the old one. :
Dimension = ACCNT
Members = A1, A2, A3 //A1 : number of maturity (in month)
Dimension =CLIENT
Members = CL_A , CL_B
Dimension = TIME
Members = 2016.01, 2016.02, ........., 2016.12
AND OTHERS : ENTITY = %ENTITY_SET% ,
CATEGORY = %CATEGORY_SET%
*SELECT(%MATURITY%,ID, ACCNT, "ID='A1'")
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET ACCOUNT = A2
*XDIM_MEMBERSET CLIENT = CL_A
*XDIM_MEMBERSET TIME = %TIME_SET%
*FOR %TIME%=TMVL(%MATURITY%,2016.01),.....,2016.09, 2016,10, 2016.11, 2016.12
*WHEN CLIENT
*IS CL_A
*REC(FACTOR=1, ACCNT=A3 )
*ENDWHEN
*NEXT
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.