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.

[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

[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