Problem in CALC_ACCOUNT - Invalid Members

[Former Member]

Hi,

BPC 10.0 on HANA

I have a consolidation script which is giving warning message and then after runs successfully after some time. This has become recurring issue.

Script below -

*SELECT (%ENT%,"[ENTITY_HIR_NODE]",GROUP,"[ID]=%GROUP_SET%")

*SELECT (%CURR%,"[GROUP_CURRENCY]",GROUP,"[ID]=%GROUP_SET%")

// Enables xdim_memberset to be passed as variable to run_program

*XDIM_MEMBERSET ENTITY AS %X_ENT% = BAS(%ENT%)

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

GROUP  = %GROUP_SET%

TID_RA = %TIME_SET%

CALC=ABC

*ENDRUN_PROGRAM

(Limited script shown above)

This script gives a warning message when run for the first time - Invalid Entity members = 1045, 1050. After some time when run again, it runs successfully. This is happening with many consolidation groups and frequently now.

I have 2 questions to start with -

1. Entity is scoped as a variable so unless we use that in OTHER = ENTITY = "" in calc_account program, entity is not scoped through XDIM I assume. So, for above calc_account program, will it run for all entities or only for those who fall under that consol group (passed through DM) in ownership manager.

2. I believe this could either be because of the fact that user doesn't have access to these 2 specific entity members or there is no data in those 2 members and that's why it fails - But the point I am unable to understand is that what happens after some time so that package is successful?

Regards,

Ashish

[former_member186338]

Hi Ashish,

If you look on help: Account-based Calculations as Script Logic - SAP Business Planning and Consolidation, version for SA...

You will see that restriction for ENTITY has to be specified as

OTHER = [ENTITY=%ENTITY_SET%]

Not with XDIM_MEMBERSET

Vadim

[former_member186338]

P.S. And in the script you have the list of entities is not passed to CALC_ACCOUNT anyway!

[Former Member]

Vadim,

This is a production system script already running and I know that std calc_account script suggests scoping of entity as OTHER = ENTITY = <xyz>.

My question here is given the scoping and script, will the calc_account script run for all members of entity dimension or the ones within that group (as defined in ownership hierarchy)?

Regards,

Ashish

[former_member186338]

"My question here is given the scoping and script, will the calc_account script run for all members of entity dimension or the ones within that group (as defined in ownership hierarchy)?"

First: In the script you have the statement: *XDIM_MEMBERSET ENTITY AS %X_ENT% = BAS(%ENT%) will not change the scope at all, only assignment of the variable %X_ENT% - unused later.

Second - to scope by ENTITY you have to use something like:

OTHER = [ENTITY=%X_ENT%]

Hope it's clear

Vadim

[former_member186338]

P.S. The script will run for all entities!

[Former Member]

Hi Vadim,

That variable X_ENT is getting used in later parts of scripts.

I know that as a general rule, any dimension not scoped - script will run for all members.

My question here is very simple, in the CALC_ACCOUNT progrom script above, will it run for all entities? (I believe yes as entity is not scoped). I want to double check because we are scoping GROUP dimension and may be it restricts entity based on GROUP dimension (limited to entities under that GROUP dimension member as defined in ownership hierarchy).

So, as an expert advise from you, whether or not this CALC_ACCOUNT program will run for all entities members?

Regards,

Ashish

[Former Member]

Additionally, if you look at the consolidation program - it doesn't scope entity but it runs only for the entities within the consol group, aint it?

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %C_CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

Regards,

Ashish

[former_member186338]

You can test it yourself - just run script and debug the execution in ABAP !

[Former Member]

Wish I was an ABAPer . Btw, consolidation program does run only for limited entities right, the ones within that group?

[former_member186338]

Consolidation is a complex story