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]

Thanks Gersh!!! I turned off HANA Accelerator in the code and it works.

Thanks Vadim as always, for telling me about the scope for Allocations.

Sincerely,

GloRida

[Former Member]

Hi GloRida,

Please also take a look at OSS Note 1944437. It can be applicable depending on SP you have.

If it fixes the issue can you please share how much improvement you got by moving allocations to HANA?

Thank you,

Gersh