BPC 10 NW - Error when running the FX_RESTATEMENT Data Manager Package.

[Former Member]

Dear fellow BPC consultants,

I have a Financial Type Planning Model, where I would like to convert currency from Local to Reporting.

To do that, I am running the FX_RESTATEMENT Data Manager Package, and in it I have LOGICFILENAME parameter value set to: FXTRANS.LGF which has the following code in it:

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
//GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_SET%,COSTCENTRE=%COSTCENTRE_SET%,PROFITCENTRE=%PROFITCENTRE_SET%,INTERCO=%INTERCO_SET%,AUDITTRAIL=%AUDITTRAIL_SET%,PRODUCT=%PRODUCT_SET%]
CURRENCY = %RPTCURRENCY_SET%
RATEENTITY = Global
*ENDRUN_PROGRAM

This code does validate successfully.

However, upon running the FX_RESTATEMENT Data Manager Package, it completes with a Failed status and issues the following error message:

“RUN_LOGIC:No suitable category found in application Planning
model: Planning. Package status: ERROR”

Now, I don’t know whether or not in the above message the word: “category” refers to the Category Dimension, however my Category Dimension is included in its standard way in my Planning Model (copied form the EnvironmentShell) and does appear to be in good order.

If anyone has an idea about the nature of that error message and the solution for it, I would be thankful to know about it.

Sincerely,

Ron.

[akos_beres]

Ron,

had the same issue, the DATASRC_TYPE property in the AUDITTRAIL dimension wasn't filled in.

Akos

[Former Member]

Hi Ron,

This error is normally appears when the name of the "Category" type of dimension is different than what you have mentioned either in the "Package" (in prompt command) or in the script logic.

Please check script logic and Prompt in the "FX_Restatement" package.

hope this helps.

Regards,

Rashmi

[Former Member]

Hi Rashmi, and thanks for your response,

I checked, based on your recommendation:

In my Logic Script, I am using: CATEGORY = %CATEGORY_SET%, as can beseen in my original posting above.

And, inside the Data Manager Package, I am using the following Prompt:

"%ENTITY_DIM%,%CATEGORY_DIM%,%TIME_DIM%,%CURRENCY_DIM%"

My understanding is that, I am using the: _SET and _DIM portions of the above statements properly, according to the standard manner, so I believe the issue is not with the use of these two ( _SET and _DIM ).

Otherwise, the name of the "Category" type of dimension in my Environment is plainly: "CATEGORY" (all CAPS again), so I beieve my settings conform with your recommendation, but the issue is still persistent...

Would you have any other idea?

Thanks,

Ron.

[Former Member]

Hi Ron,

Can you try to modify the script by removing the line for "OTHER".

Also try to hardcode some category member in your script logic just to check whether its working fine or not. Have you validated your script logic?

[Former Member]

Hi Ron,

The syntax in package is using "_DIM", means, it prompts you the members for this type of dimesion. (which dimension members that you would like to select while executing the package )

and

in script logic it is by using "_SET", this means, the script would run for all those member(s) (i.e. the SET of members) that you have selected in the prompt.

Regards,

Rashmi

[Former Member]

Hi Rashmi,

In your most recent response above (regarding the: _SET and _DIM), my understanding is that you are explaining what is their meaning, however you did not suggest that I am using them wrongly.

So, assuming that I AM using them properly, do you have another idea about how to resolve the error I am getting as I mentioned in my initial posting above: (“RUN_LOGIC:No suitable category found in application Planning model: Planning. Package status: ERROR”) ?

Thanks,

Ron.