on ‎2018 Oct 30 11:55 AM
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
Request clarification before answering.
Sorry, but you have to read my blog about default.lgf scoping: https://blogs.sap.com/2014/06/09/how-to-write-defaultlgf/
In general, don't use *XDIM_MEMBERSET at all!
Use:
*WHEN AUDIT_TRAIL
*IS INIT01
*WHEN ACCOUNT
*IS PRICE
...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 11 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.