I have the following script which validates successfully, but the package fails with the error:
RUN_LOGIC:The member 2008.INP in Allocation rule is not a base-level member.
2008.INP is the annual input member in the Time dimension. It is a base member because I was able to successfully submit the allocation drivers to this time period.
Has anyone had similar errors when running allocations?
*RUNALLOCATION *FACTOR = USING *DIM COSTCTR WHAT=BAS(CC_TOTAL_PL); WHERE=<<<; USING=<<<; *DIM ACCOUNTCC WHAT=BAS(SGA_SVC_EXP); WHERE=<<<; USING=ALLOC_PCT; *DIM ENTITY WHAT=BAS(TOTAL_ENTITIES); WHERE=<<<; USING=NO_ENTITY; *DIM BU WHAT=NO_BU; WHERE=EBU; USING=<<<; *DIM DATASRC WHAT=R3; WHERE=ALLOC; USING=INPUT; *DIM TIME WHAT=BAS(2008.TOTAL); WHERE=<<<; USING=2008.INP; *DIM FUNCTIONAL WHAT=BAS(TOTAL_FUNCTIONS); WHERE=<<<; USING=NO_FUNCTION; *DIM GEOGRAPHY WHAT=BAS(GLOBAL_TOTAL); WHERE=<<<; USING=NO_LOCATION; *ENDALLOCATION *COMMIT
Regards,
Karen
Hi Karen -
Please clarify...
It appears that you want to allocate an annual value stored as follows:
COSTCTR a cost center which is a member of BAS(CC_TOTAL_PL)
ACCOUNTCC an account which is a member of BAS(SGA_SVC_EXP)
ENTITY an entity which is a member of BAS(TOTAL_ENTITIES)
BU NO_BU
DATASRC R3
TIME 2008.INP ?????from your description??????
FUNCTIONAL A Functional which is a member of BAS(TOTAL_FUNCTIONS)
GEOGRAPHY A GEO which is a member of BAS(GLOBAL_TOTAL)
If this is the correct interpretation, then your designation of the TIME dimension appears to be incorrect:
*DIM TIME WHAT=BAS(2008.TOTAL); WHERE=<<<; USING=2008.INP;
should be:
*DIM TIME WHAT=2008.INP; WHERE=>>>; USING=BAS(2008.TOTAL);
I also tested the ability for the Allocation fucntion to pull data from a TIME dimension such as 2008.INP...everything I tested seemed to work fine.
Regards,
Sheldon
Add a comment