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 Member · Accepted solution]

Simple fix - disable allocation on HANA.

If you need to go to root cause you should start from Support Pack and HANA revision.

Then create a simple allocation and test if it works or not.