Skip to Content

Script Logic - Scoping Question

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 03, 2017 at 05:13 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2017 at 01:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded