BPC Allocation Script

[former_member551527]

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

[former_member186338 · Accepted solution]

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=...

[former_member551527]

Thanks Vadim. Following syntax also worked.

WHAT=BAS(TotalEXPENSES,TotalCOSTs,MISCcost)

[former_member186338]

It depends on BPC version/SP.