BPC Allocations

[Former Member]

I am running BPC 10.1 on HANA. I just enabled HANA yesterday by setting the HANA indicators in the Global and Environment level and that when the following allocation script stopped working. Earlier ie. 2 days ago it was working fine.

I ran the following allocation script. Is BAS not supported in BPC HANA? My Where=0 according to the LGX. I simply do not get why.....

Please help me out.

*SELECT(%YR%,"[YEAR]",CATEGORY,"[ID] = FORECAST")

*XDIM_MEMBERSET ACCOUNT = COGS_SAVINGS

*XDIM_MEMBERSET CATEGORY = ACTUAL, FORECAST

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET DATATYPE = DT_CURRENCY

*XDIM_MEMBERSET MEMBER_VENDOR AS %MBR_VAR% = BAS(SAME_MEMBERS)

*FOR  %CNT% = .07,.08,.09,.10,.11,.12

*FOR %MBR% = %MBR_VAR%

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=COGS_SAVINGS; WHERE=<<<; USING=BAS(FS0158); TOTAL=<<<

*DIM MEMBER_VENDOR WHAT=MV_NONE; WHERE=%MBR%; USING=<<<; TOTAL=BAS(SAME_MEMBERS)

*DIM TIME WHAT=%YR%%CNT%; WHERE=<<<; USING=%YR%.01,%YR%.02,%YR%.03,%YR%.04,%YR%.05,%YR%.06; TOTAL=<<<

*DIM CATEGORY WHAT=FORECAST; WHERE=<<<; USING=ACTUAL; TOTAL=<<<

*DIM AUDITTRAIL WHAT=BAS(AUDITTOTAL); WHERE=ALLOCATIONS; USING=BAS(AUDITTOTAL); TOTAL=<<<

*DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<

*ENDALLOCATION

*NEXT

*NEXT

*COMMIT

LGX.txt.zip

[former_member186338]

Can you try to narrow down the issue? Try to create the simplest script ...

By the way, looking on you script I can see something strange - the scope with XDIM_MEMBERSET will work only for the first FOR/NEXT loop iteration because *ENDALLOCATION - resets scope!

Vadim

[former_member186338]

P.S. Actually I am talking about this scope setting:

*XDIM_MEMBERSET DATATYPE = DT_CURRENCY

The rest are useless - overwritten by *DIM inside *RUNALLOCATION.

Vadim