Error while running Consolidation : "Invalid Members [ENTITY]="

[former_member225135]

Hello Experts,

While running consolidation from consolidation monitor, data manager package or UJKT, I am getting this error: Invalid Members [ENTITY]=

The same process was working fine and suddenly I am getting this error. I am using the standard consolidation script logic.

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = Global

*ENDRUN_PROGRAM

Following are the list of dimension:

No changes are done on configuration view point.

CPMBPC: SAPK-80110INCPMBPC

Regards,

Rahul

[former_member186338 · Accepted solution]

Sorry, but script is strange!

First you have to perform currency conversion then - consolidation!

Please show screenshot of the script!

Also show advanced script you use to run the dm package!

[former_member225135 · Accepted solution]

Corrected the script, but the issue remain as it is:

[former_member186338 · Accepted solution]

And what do you select for ENTITY?

[former_member186338 · Accepted solution]

P.S. Show full log!

[former_member225135 · Accepted solution]

I don't do any selection for entity.

[former_member186338 · Accepted solution]

Then remove OTHER = [ENTITY=%ENTITY_SET%]

And %ENTITY_DIM% from advanced script

[former_member225135 · Accepted solution]

Tried, but same result.

Regards,

Rahul

[former_member186338 · Accepted solution]

Then check your ENTITY dimension, process it, look for all required settings for currency translation and consolidation!

[former_member225135 · Accepted solution]

Tried doing all that. No field is blank and dimension is processed.

[former_member186338 · Accepted solution]

Sorry but "No field is blank" means nothing! There are a lot of settings required for currency translation and consolidation...

Fist check script with only:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = Global

*ENDRUN_PROGRAM

is it working?

[former_member225135 · Accepted solution]

What I meant was all setting required for currency conversion and consolidation are already there, there is nothing which is left out.

Will check the script logic and will revert.

[former_member186338 · Accepted solution]

"What I meant was all setting required for currency conversion and consolidation are already there, there is nothing which is left out." - then the script has to work correctly, no magic

[former_member186338 · Accepted solution]

Also do you have necessary access rights?

[former_member225135 · Accepted solution]

Agreed, but not working for me.

Its already 10 pm in India, i am closing my day. I will update you once I will run the process tomorrow morning.

[former_member225135 · Accepted solution]

SAP ALL

[former_member186338 · Accepted solution]

Just looking on your log I can see this error in both (currency conversion and consolidation). Please show screenshot of your entity dimension administration screen!

[Former Member · Accepted solution]

Hi Rahul,

Can you try selecting top node of Entity Dimension instead of leaving it <all>?

Alternatively you can put

*XDIM_MEMBERSET ENTITY AS %ES% = BAS(%ENTITY_SET%)

and replace %ENTITY_SET% with %ES% in your call.

Regards,

Gersh

[former_member225135 · Accepted solution]

I tried to process dimension from front end, but it didn't work.

The strange thing is when i ran "UJA_REFRESH_DIM_CACHE", consolidation is working fine.

[former_member186338 · Accepted solution]

"I tried to process dimension from front end, but it didn't work." that's the issue! Please show details!

[former_member225135 · Accepted solution]

What I meant was the dimension got processed, but when I ran consolidation it failed.

[former_member186338 · Accepted solution]

Have you processed the dimension after UJA_REFRESH_DIM_CACHE?

[former_member225135 · Accepted solution]

Yes. and Post running the program, consolidation ran successfully.

[former_member186338 · Accepted solution]

Looks like the entity dimension was corrupted somehow! UJA_REFRESH_DIM_CACHE corrected it.

[former_member225135 · Accepted solution]

Even I think so.

Thanks for your help