Skip to Content
avatar image
Arthur Adam

Logic Script scoping based on data

May 21, 2018 at 04:10 PM | 59 Views | Last edit May 21, 2018 at 09:52 PM 3 rev.

Hi Gurus,

I have a requirement where I have to scope members based on data.

Details:

BPC Version: 10.1 NW Classic

EPM Version: 28

Environment: Dev

Model: Planning

Dimensions:6

Account, Department, Time, Category, Entity, Data Source

Firstly, I have an input form where I save data into certain departments. The Departments come under a parent with Department having Department1, Department 2 etc.

EX:

DataSource1 Datasource1

Department1 Department2

Account1 10 0

Account2 10 0

The logic should scope the data with the value 10 and based on it, I will be recording the values to another version for Account1 and Account2.

Basically, the calculation would be If a certain department has signed data as 10 in Version1 record 1000*2 Euros in Version2.

I tried to look it up but some of the suggestions were *XDIM_GETMEMBERS but that doesn't seem to be applicable for 10.1 NW

Any other suggestions on how to scope the records?

Further details:

1.

2. I got the Validation Error "MATH" is Uknown.

3. ACCTTYPE: EXP

4. I will run it through a DM package

5. Calculation Logic: Account= Account*2

6. User Doesn't enter anything in DM

7,8,9,10. Script to be developed.

sap-version.jpg (16.7 kB)
SAP Business Planning and Consolidation, version for SAP NetWeaver
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Vadim Kalinin
    May 22, 2018 at 07:32 PM

    The script will be (using conditional ternary operator):

    *XDIM_MEMBERSET Account=Account1,Account2 //listof required accounts
*XDIM_MEMBERSET Category=Version1 //Category with signed data
*WHEN Account
*IS *
*REC(EXPRESSION=%VALUE%==10 ? [Category].[Version2]*2 : [Category].[Version2],Category=Version2) //save result in Version2
*ENDWHEN

    Add comment
    10|10000 characters needed characters exceeded

    • Vadim Kalinin Arthur Adam
      May 22, 2018 at 08:32 PM

      Yes, correct!

      *REC(EXPRESSION=%VALUE%==10 ? [Category].[Version2]*2 : [Category].[Version3],Category=Version3)

      if 10 then multiply version2 by 2, if not 10 then take the value from version3

      And save result to version3

  • avatar image
    Vadim Kalinin
    May 21, 2018 at 07:55 PM

    Sorry, but the requirements are not clear!

    Please provide info in line with https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    May 22, 2018 at 09:07 AM

    Sorry, but logic is still not clear:

    "the calculation would be If a certain department has signed data as 10 in Version1 record 1000*2 Euros in Version2"

    and

    "Calculation Logic: Account= Account*2"

    10*2=20 ???

    Also I do not understand what's the issue?

    *XDIM_MEMBERSET Account=Account1,Account2 //list of required accounts
*XDIM_MEMBERSET Category=Version1 //Category with signed data
*WHEN Account
*IS *
*REC(EXPRESSION=%VALUE%*2,Category=Version2) //save result in Version2
*ENDWHEN

    Add comment
    10|10000 characters needed characters exceeded