Skip to Content
0
May 21, 2018 at 04:10 PM

Logic Script scoping based on data

230 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.

Attachments

sap-version.jpg (16.7 kB)