Hi,
I have the problem with allocation.
Entity dimension "Department" consists of the following records:
ID | PARENTH1 | ISFICTIVE
Workshop1 | | 0
Department1 | Workshop1 | 0
Department2 | Workshop1 | 0
Department3 | Workshop1 | 1
Workshop2 | | 0
Department4 | Workshop2 | 0
Department5 | Workshop2 | 0
Department6 | Workshop2 | 0
Department7 | Workshop2 | 1
The task is to allocate costs from FICTIVE departments to other departments inside the workshop according production plans.
My script logic looks like:
*XDIM_MEMBERSET ...
*SELECT(%DEPSET%, "[ID]", DEPARTMENT, [ISFICTIVE]="1")
*FOR %D%=%DEPSET%
*RUNALLOCATION
...
*DIM DEPARTMENT WHAT=%D%; WHERE=BAS(%D%.[PARENTH1]); USING=<<<; TOTAL=<<<;
...
*ENDALLOCATION
*NEXT
This script doesn't work, namely this expression BAS(%D%.[PARENTH1]) - where I want to obtain a parent node.
So the question is:
Is it possible to make such allocations (from one child to other children within the same parent) and what is the correct syntax?
Thanks in advance!