on 04-03-2017 5:56 PM
Hi,
I have a question about scoping in script logic for BPC10.1 NW. I am trying to debug logic that was written by someone else and does not seem to be working as expected.
In one of our models, we have default logic that includes both an XDIM FILTER statement and XDIM Memberset statement referencing the same dimension (Category):
*XDIM_FILTER CATEGORY = [CATEGORY].PROPERTIES("TRANS_DEFAULT")="Y"
*XDIM_FILTER DATASRC = [DATASRC].PROPERTIES("IS_CONVERTED")="Y"
*XDIM_MEMBERSET ACCOUNT=BAS(NETINCOME)
*XDIM_MEMBERSET CURRENCY=LC,USD,USDBER
*XDIM_MEMBERSET FLOW=F_CLO
*XDIM_MEMBERSET INTCO=ICNA
*XDIM_MEMBERSET LOB=<ALL>
*XDIM_MEMBERSET GROUPS=GNA
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
My question is - in a case like this, which statement controls the scoping for the Category dimension?
Also, since this is default logic, there is no prompt coming from the DM package, so would the variable %CATEGORY_SET% have any value or would it be assumed to include all category dimension members?
Here is our BPC system info:
SAP_BW 740 0014 SAPKW74014 SAP Business Warehouse
CPMBPC 810 0009 SAPK-81009INCPMBPC SAP Business Planning and Consolidation
Thanks,
Barb
Hi Vadim,
So does the *XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% statement define the scope because it comes after the *XDIM Filter statement and supercedes it?
And since this is not a DM package, how is the value of the variable %CATEGORY_SET% determined?
Thanks,
Barb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Absolutely strange logic! *XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% will define the scope!
Please read my blog about default.lgf:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
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.