martedì 19 marzo 2013

Script logic: use of when SAP BPC



Here an example af a script logic that run on .INP time dimension and use "when condition":
 
*WHEN TIME
*IS <>TOT.INP
    *WHEN ACCOUNT
        *IS PERCENT.ALLOC
            *FOR %YEAR%=2003,2004,2005
                *FOR %MONTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC
                    *REC(FACTOR=GET(ACCOUNT="TOT.OVRHEAD",TIME="TOT.INP")/100,TIME="%YEAR%.%MONTH%")
                *NEXT
        *NEXT
    *ENDWHEN
*ENDWHEN

Nessun commento:

Posta un commento