Skip to Content
0
Former Member
Jan 11, 2012 at 04:03 PM

Allocate to BAS(parent)

36 Views

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!