Consolidation package error: RUN_LOGIC: Dimension set

[Former Member]

Hi Experts

I am trying to run the Consolidation package, my consolidation script logic is:

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

ENTITY=%ENTITY_SET%

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

But I get the following error:

/CPMB/MODIFY completed in 0 seconds

/CPMB/LEGAL_CONSOLIDAT_LOGIC completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

----

---

(Member Selection)

CATEGORY: ACTUAL

RPTCURRENCY: USD

TIME: 2006.OCT

[Messages]

----

---

RUN_LOGIC:Dimension set:"ENTITYDATAVALUE" not assigned in Data Manager

Failed

Application: LegalApp Package status: ERROR

The package only seems to require me to select Category, RptCurrency and Time - nothing regards Entity! Therefore the error does not make sense to me.

When I change the consolidation script to:

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

// ENTITY=%ENTITY_SET%

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

I get the following error:

/CPMB/MODIFY completed in 0 seconds

/CPMB/LEGAL_CONSOLIDAT_LOGIC completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

----

---

(Member Selection)

CATEGORY: ACTUAL

RPTCURRENCY: USD

TIME: 2006.OCT

[Messages]

----

---

RUN_LOGIC:Dimension set:"GROUPSDATAVALUE" not assigned in Data Manager

Failed

Application: LegalApp Package status: ERROR

This is strange, as the PROGRAM CURR_CONVERSION runs fine as is in FXTrans script and Currency Conversion package, so I do not know why the error.

We are running SAP BPC 7.5NW SP6.

Can anyone help me resolve this frustrating issue?

Thanks in advance

[Former Member · Accepted solution]

Hi Parminder,

Try using GROUPS dimension (G-type dimension not R-type) in the selection since only currencies with CURRENCY_TYPE=G are valid for storing ownership data. And also change the script so that currency conversion also uses the group for translation.

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

Please refer to this SAP note for more info: 1519146 - Consolidation Elimination business rule does not find any data

Hope this helps,

Marvin

[Former Member · Accepted solution]

Thanks for responding Marvin.

I tried your suggestion and changed the consolidation script to:

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

But I get the error:

/CPMB/MODIFY completed in 0 seconds

/CPMB/LEGAL_CONSOLIDAT_LOGIC completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

----

---

(Member Selection)

CATEGORY: ACTUAL

RPTCURRENCY: USD

TIME: 2006.OCT

[Messages]

----

---

RUN_LOGIC:Dimension set:"GROUPSDATAVALUE" not assigned in Data Manager

Failed

Application: LegalApp Package status: ERROR

So the change no longer gives a RUN_LOGIC:Dimension set:"ENTITYDATAVALUE" not assigned in Data Manager, I now get

RUN_LOGIC:Dimension set:"GROUPSDATAVALUE" not assigned in Data Manager.

How and what do I change from R-type to G-type dimension in the selection?

Thanks

[Former Member · Accepted solution]

Hi,

In your script, you have 3 dynamic variables used - %CATEGORY_SET%, %GROUPS_SET%, and %TIME_SET%. This means that the script is expecting these values from the DM package. However, while running the DM package, you are prompted from category, rptcurrency and time, but not for groups. So, you need to modify the dynamic script of the DM package and replace rptcurrency with groups, so that the DM will prompt for groups instead of rptcurrency.

The previous error, which you were getting was due to a similar problem. You had %ENTITY_SET% in the script, but it was not prompted for in the DM package. Later when you removed that statement from your script logic, it stopped giving you that error.

Hope you got the point.

[Former Member · Accepted solution]

Hi Parminder,

As advised above you should modify the package dynamic script from

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

to the following...

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%GROUP_DIM%,%TIME_DIM%")

Hope this helps,

Marvin

[Former Member]

Thank you...your suggestions helped me resolve the issue.

Points awarded.