SCRIPT LOGIC ISSUE

[#1]

Hi Experts,

We are looking into BPC 11.

The Requirement is as follows,

In row Axis would expand based on property.

To meet the above requirement i write a logic as followes,



*XDIM_MEMBERSET ACCOUNT=GL_PROD 
*XDIM_MEMBERSET CATEGORY = ACTUAL 
*SELECT (%TIME% , "[CURRENT_MONTH]",CATEGORY,"[ID]='PLAN' ")
*XDIM_MEMBERSET TIME=%TIME%
*XDIM_MEMBERSET SCENARIO = ACTUAL 
*SELECT(%PRODUCTS%,"[ID]",PRODUCT,"[PL]='Y'") 
*XDIM_MEMBERSET PRODUCT = %PRODUCTS% 


*WHEN PRODUCT
*IS * 
*FOR %ALL_PROD% = %PRODUCTS%
*REC(EXPRESSION=%VALUE%/%ALL_PROD%,ACCOUNT=STAT_PROD,CATEGORY=PLAN) 
*NEXT
*ENDWHEN

When i run the above logic the package was failed.

Kindly suggest me.

Regards,

Uma

[former_member186338]

Sorry, but I do not understand you logic at all! The script provided is incorrect - missing NEXT after FOR, please be accurate!

Second: about FOR/NEXT!

Let's assume the code with NEXT is:

*WHEN ACCOUNT
*IS GL_PROD
*FOR %PROD% = %PRODUCTS%
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=%PROD%) 
*NEXT //missing NEXT!
*ENDWHEN

This code will result in:

*WHEN ACCOUNT
*IS GL_PROD
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=TM) 
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=DH) 
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=LH) 
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=TS) 
*REC(EXPRESSION=%VALUE%,ACCOUNT=STAT_PROD,PRODUCT=LGT) 
*ENDWHEN

Total will be calculated for each product - as a result a lot of useless calculations will be done and the code will be very slow in production environments! This is an example how NOT to write script logic!

[Former Member]

Hi vadim,

Ya that's Correct.Thank You

Regards,

Uma