Error in consolidation script

[former_member215123]

Dear All,

I have created a consolidation model BPC NW10. When I'm trying to validate the standard script getting an error like [No member found in dimension 'SCOPE' for condition "CALC" = "N" ]. Please find the error screenshot for your reference. Kindly help me to solve this.

Thanks in Advance!

Regards,

Alagappan R

[Former Member · Accepted solution]

Hi Alagappan,

Try to write the logic script as below.

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

RATEENTITY = Global

OTHER=[ENTITY=%ENTITY_SET%]

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY=%CATEGORY_SET%

GROUP=%SCOPE_SET%

TID_RA=%TIME_SET%

OTHER=[ENTITY=%ENTITY_SET%]

*ENDRUN_PROGRAM

Khokan

[former_member215123 · Accepted solution]

Hi Khoka,

I have followed your logic as mentioned but still I'm getting same error. That script automatically generated, I have not created. I'm new to BPC Kindly help me to configure consolidation.

Thanks in Advance!!

Regards,

Alagappan.

[Former Member · Accepted solution]

Hi Alagappan

have you define G_None or S_None in your scope dimension?

Khokan

[former_member215123 · Accepted solution]

Hi Khoka,

Have to maintain G_None and S_None in scope dimension. I will try that can you please tell why we need to maintain?

Thanks in Advance!!

Regards,

Alagappan.

[former_member186338 · Accepted solution]

Hi Alagappan,

Before writing questions about consolidation scripts please search and read documents about general consolidation setup. Or it's a waste of time.

Vadim

[Former Member · Accepted solution]

Hi Alagappan,

All transaction data that are consolidated are copied from the No Group/No Scope Group member into the respective Group where the data are consolidated.

For example if you have hierarchy of Core_Group with Subs_Group1 and Subs_Group2 as its children (maintained in PARENT_GROUP property), when you want to consolidate in Core_Group, it will copy the data from G_None (No Group/No Scope) dimension member instead of rolling up from its children (Subs_Group1 and Subs_Group2).

Khokan

[former_member215123 · Accepted solution]

Hi Khoka,

Thanks for your explanation now it is clear to me. Thanks a lot!!

Regards,

Alagappan

[former_member215123 · Accepted solution]

Hi Vadim,

Thanks for reply I'm new to Consolidation. Could you please share some consolidation initial setup and configuration steps documents.

Thanks in Advance!!

Regards,

Alagappan.

[former_member186338 · Accepted solution]

Sorry, "Search" is not available???

Also read docs for IFRS kit.

Vadim