Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Write custom rule with NONEMPTYTUPLE

in Profitability and Cost Management 11 comments

Hello everyone,

I am trying to write a custom calculation to optimize the performance based on Oracle's guidance.

But it seems the Oracle standard guidance is not working properly.

This is the guidance that i base on:

When i am trying to create a custom rule :

(([PCM_AllocationIn],[AR_002],[Actual],[Final],[MYR]) + ([PCM_AllocationIn],[AR_003],[Actual],[Final],[MYR])

becomes :

[PCM_Input] := NONEMPTYTUPLE([PCM_Allocation In],[AR_002],[Actual],[Final],[MYR]) ([PCM_Allocation In],[AR_002],[Actual],[Final],[MYR]);

[PCM_Input] := NONEMPTYTUPLE([PCM_Allocation In],[AR_003],[Actual],[Final],[MYR]) (([PCM_Input]) + ([PCM_Allocation In],[AR_003],[Actual],[Final],[MYR]));

It shows the error:

Missing resource: com.essbase.api.base.EssException: Cannot Perform Custom Calc. Essbase Error(1300052): The argument [Script] is missing one or more dimensions

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!