Skip to Content
0
Oct 30, 2018 at 11:55 AM

SAP BPC 10.1 on NW - Scoping "XDIM_MEMBERSET" of the default logic with user-defined dimensions

224 Views Last edit Oct 30, 2018 at 11:56 AM 2 rev

Hello BPC experts

I need to modify the "XDIM_MEMBERSET" part of the default logic to run on a specific perimeter of a user data entry.

For exemple, this is the original script in the default logic :

*XDIM_MEMBERSET AUDIT_TRAIL = INIT01
*XDIM_MEMBERSET PRODUCT = <ALL>
*XDIM_MEMBERSET CUSTOMER = <ALL>
*XDIM_MEMBERSET CURRENCY = <ALL>
*XDIM_MEMBERSET PROFIT_CENTER = <ALL>
*XDIM_MEMBERSET ACCOUNT = PRICE
*XDIM_MEMBERSET COMPANY = <ALL>
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*WHEN ACCOUNT
*IS PRICE
     *REC(EXPRESSION=(%VALUE%*2), AUDIT_TRAIL="CALC01") 
*ENDWHEN
*COMMIT

In the exemple below, the type of dimensions is the following :

AUDIT_TRAIL : Audit

PRODUCT : User defined

CUSTOMER : User defined

CURRENCY : Currency

PROFIT_CENTER : User defined

ACCOUNT : Account

COMPANY : Entity

TIME : Time

CATEGORY : Category

I would therefore scope the default logic on the perimeter's user data entry.

*XDIM_MEMBERSET AUDIT_TRAIL = INIT01
*XDIM_MEMBERSET PRODUCT = %PRODUCT_SET%
*XDIM_MEMBERSET CUSTOMER = %CUSTOMER_SET%
*XDIM_MEMBERSET CURRENCY = %CURRENCY_SET%
*XDIM_MEMBERSET PROFIT_CENTER = %PROFIT_CENTER_SET%
*XDIM_MEMBERSET ACCOUNT = PRICE
*XDIM_MEMBERSET COMPANY = %COMPANY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*WHEN ACCOUNT
*IS PRICE
     *REC(EXPRESSION=(%VALUE%*2), AUDIT_TRAIL="CALC01") 
*ENDWHEN
*COMMIT

I tried the syntax above, but with no surprise, it didn't worked..

Does anyone know how to write it ?

Thanks by advance for your help and support.

Regards,

Karim