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]

For sure the logic is incorrect!

You have to define parent member in the PRODUCT hierarchy like ALLPROD with base members TM, DH... under it

then the script will be:

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

*WHEN PRODUCT
*IS * 
*REC(EXPRESSION=%VALUE%/[PRODUCT].[ALLPROD],ACCOUNT=STAT_PROD,CATEGORY=PLAN) 
*ENDWHEN

[Former Member]

Hi Vadim,

Thanks for your reply.

In product dimension we maintain one property Called PL.

PL property =Y those values we maintained in row axis.

Calculation like as follows,

1)Product=TM, category =actual, time=2019.01/sum of products those products have PL property =Y

2)Product=DH, category =actual, time=2019.01/sum of products those products have PL property =Y

Etc

How to define only properties members in rec expression

Kindly suggest how to write that logic.

Regards.

Uma