Unable to execute Consolidation Functionality

[Former Member]

Hi,

I am using BPC10 NW SP06

When running the consolidation process, say for AsiaPacific through Consolidation Monitor, I am getting the following error message:

"Data for category Actual not found in application Consolidation"

For the same data when I tried to run the delivered DM package /CPMB/LEGAL_CONSOLIDATION", I got the below error message:

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

I have created all the required business rules like Methods, Method-based Multipliers, Eliminations and Adjustments, etc. I have also given ownership data, currency conversion rates as well as transaction data for Actual category.Through Ownership Monitor I have generated data under "Generated" column too. The delivered script logic file is also copied into CONSOLIDATION.LGF file in Consolidation Model

Can anybody help me in resolving this error please

Regards,

Ramu

[Former Member]

Hi Ramu,

Did you find the solution to your error? I am facing the same problem.

Sanjeev

[Former Member]

Also:

1581841 - BPC NW: Error in Allocation package execution after adding a dimension in the Prompt

[Former Member]

Hi Vin,

Even the statements as stated in the SAP Note Number 1581841 are already there.

Can you kindly suggest any other solution to the problem

Regards,

Ramu

[Former Member]

Just check if the Category dimension in the Ownership application and the Consolidation applications are the same.

Also try commenting out the line in the CONSOLIDATION program which passes ENTITY as a parameter

i.e.,// OTHER=[ENTITY=%ENTITY_SET%]

Regards,

Prasanth.

[Former Member]

Hi Prasanth,

There is only one Category type dimension in the environment. Also tried to comment the line passing ENTITY as a paramter. But getting the same error messge again.

Regards,

Ramu

[Former Member]

Hi Ramu,

Please check in ST22 what dump error you are getting. Plese post that error.

Regards,

Srinivasan.

[Former Member]

Hi Srinivasan,

No runtime errors were found in ST22

Regards,

Ramu

[Former Member]

Can you check if the currency conversion to group currency is happening correctly. i.e, In the Consolidation.lgf comment out the second Program and run the consolidation package.

If that runs succesfully, In the Data manager Package that you are running for Consolidation, try removing the Entity parameter from the Select Input line in the Dynamic script and then run the package.

Regards,

Prasanth.

[Former Member]

HI Ramu,

1) What is the Dimension name for Entity ( Is it Entity only?)

2) When you are running Consolidation DM package what variables you are passing while Running DM package?

3) Are you able to run Currency Translations correctly? (as Prasanth mentioned above try to run currency translations seperatly)

4) What is the starting point of this enviroment? Is it enviromentShell.

5) What is your Model Name? Is it LEGAL_CONSOLIDATION, if yes, can you copy the model as Consolidationa and then try.

I am assuming there is some thing configuration or definations are missing.

Thanks,

SRI

[Former Member]

Hi Prashanth,

Currency conversion is running fine. My consolidation script in the DM package is as follows:

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

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SUSER,%USER%)

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SAPP,%APP%)

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,LOGICFILENAME,CONSOLIDATION.LGF)

I have tried running the DM package after commenting the conversion program. Also commented on the ENTITTY parameter in CONSOLIDATION.LGF file. Now I am getting common eror while running the consolidation process from Consolidation Monitor as well as DM package which is as follows:

"RUN_LOGIC: Data for category Actual not found in application Consolidation"

Can you suggest any further

Regards,

Ramu

[Former Member]

Hi Srinivas,

Here are the answers to your queries (in the same order):

1. Name of Entity type Dimension is "ENTITY"

2. The variables in DM package are as follows:

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

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SUSER,%USER%)

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SAPPSET,%APPSET%) 

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SAPP,%APP%) 

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,SELECTION,%SELECTION%) 

TASK(/CPMB/LEGAL_CONSOLIDAT_LOGIC,LOGICFILENAME,CONSOLIDATION.LGF

My consolidation logic file is as follows (standard one only):

*RUN_PROGRAM CONSOLIDATION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_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

3. Yes, I am able to run currency translation correctly

4. My environment is copied from ENVIRONMENTSHELL only

5. The model name is Consolidation which is not changed from the default one

Also the R_ENTITY is GLOBAL (in capital letters)

Regards,

Ramu

[Former Member]

Hi,

Oh! Are you running it in the order you mentioned. Change the Consolidation.LGF to the following. The currency conv to Group should happen first followed by Consolidation.

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_SET%]
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM

Regards,

Prasanth.

[Former Member]

Hi Prashanth,

I don't think order matters here. Still I tried as per your suggestion but again getting the following error whether the ENTITY parameter is commented or not in CONSOLIDATION program.

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

Regards,

Ramu

[Former Member]

Hi Ramu,

I think order of running of the program definitely does matter. You are getting a different error now right.

Can you comment out entity parameter from BOTH programs like below and try in this order

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
//OTHER = [ENTITY=%ENTITY_SET%]
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
//OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM

Regards,

Prasanth.

[Former Member]

Hi Ramu,

Please take a look at this SAP Note:

1403508 - BPC NW: Error: "Data for category <DimensionName> not found in application <ApplicationName>" when executing the Consolidation package

Hope it helps.

Regards,

Vin

[Former Member]

Hi Vin,

Thanks for your reply. For the property "IS_CONSOL", the "Input" member of AUDITTRAIL dimension has already been set to "Y". I have given data using this datasource only. Thus the solution provided by the SAP Note Number 1403508 has already been taken care of.

Any other suggestion please.

Regards,

Ramu