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]

The alternative solution can be used for huge data volumes with RUNALLOCATION!

Also special PRODUCT member to be created: PROD1 to store value: 1

*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=PROD1 //Special member

*WHEN_REF_DATA = MASTER_DATA //to work for empty record
*WHEN PRODUCT
*IS *
*REC(EXPRESSION=1) //fill PROD1 with 1
*ENDWHEN

*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM PRODUCT WHAT=PROD1; WHERE=%PRODUCTS%; USING=%PRODUCTS%; TOTAL=%PRODUCTS%
*DIM CATEGORY WHAT=ACTUAL; WHERE=PLAN; USING=ACTUAL; TOTAL=ACTUAL
*DIM ACCOUNT WHAT=GL_PROD; WHERE=STAT_PROD; USING=GL_PROD; TOTAL=GL_PROD
*ENDALLOCATION