Skip to Content
0

Script Logic - Scoping Question

Apr 03, 2017 at 04:56 PM

46

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Apr 03, 2017 at 05:13 PM
0

Absolutely strange logic! *XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% will define the scope!

Please read my blog about default.lgf:

https://blogs.sap.com/2014/06/09/how-to-write-defaultlgf/

Share
10 |10000 characters needed characters left characters exceeded
Barb Koch Apr 04, 2017 at 01:31 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded