Skip to Content
avatar image
Former Member

BPC Allocation Script

Hello All,

I need to add the base members of selective sub nodes of the Account hierarchy in my allocation script - WHAT statement. I want to know if the following syntax can be used in allocation. I am not getting expected results if I use following syntax in the WHAT clause.

Note: I have not show/.included other dimensions in following script . Initially production script got only one BAS( TOTALEXPENSES) and now requirement is to add BAS(TOTALCOSTS) and one more member MISCOST.

*RUNALLOCATION
*FACTOR=USING*-1
*DIM  ACCOOUNT WHAT=BAS(TotalEXPENSES),BAS(TotalCOSTs),MISCcOST;      WHERE=ALLOCOUT;  USING=ALLOC
*ENDALLOCATION

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 14 at 08:24 AM

    Use the following syntax:

    *XDIM_MEMBERSET ACCOUNT AS %ACC1% = BAS(TotalEXPENSES)

    *XDIM_MEMBERSET ACCOUNT AS %ACC2% = BAS(TotalCOSTs)

    ...

    *DIM ACCOUNT WHAT=%ACC1%,%ACC2%,MISCcOST; WHERE=...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16 at 06:26 AM

    Thanks Vadim. Following syntax also worked.

    WHAT=BAS(TotalEXPENSES,TotalCOSTs,MISCcost)

    Add comment
    10|10000 characters needed characters exceeded