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.