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, version, Entity, Data Source
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: Version1= Version2
6. User Doesn't enter anything in DM
7,8,9,10. Script to be developed.
Firstly, I have an input form where I save data into certain departments and Accounts.
Department 10000 and Department 20000 are parents. I have another set of members in the department dimension namely 11000, 21000 etc.. The Department parents are stored in the parent property in dimension members 11000. 21000
EX:

The process for the input form goes like this. The user will input a value 10 into DataSource: Indicator_datasource and
Version: Indicator_version.
The logic will then read the value 10 and find the department "11000" as shown in the figure above. From the Department "11000" it will find the property "parent" and retrieve the value: 10000. Now taking "10000" as the department value, it will find the base members of "10000". Once it finds the base members, it will search for data in Version member: Version1 and put them in Version2.
I have tried this with runallocation..
*XDIM_MEMBERSET DataSource = Indicator_datasource, INPUT
*XDIM_MEMBERSET VERSION = Version1, Indicator_version, Version2 //
*SELECT(%COI%,[Parent],Department,[ID]=11000)
*XDIM_MEMBERSET Department AS %CO% = BAS(%COI%)
*RUNALLOCATION
*FACTOR = 1
*DIM VERSION WHAT=Version1; WHERE=Version2;
*DIM DEPARTMENT What=%CO%; WHERE=%CO%;--not sure if need this
*ENDALLOCATION
The problem comes with the the statement
*SELECT(%COI%,[Parent],Department,[ID]=11000)
Instead of 11000 I should use a variable.
*SELECT(%COI%,[Parent],Department,[ID]=%COO%)
But I am not able to figure out how I can put the department number in the variable %COO%.