Planning Area activation error

[Former Member]

Hi Experts,

We usually face planning activation error where the key figure technical name is mentioned so that we know where the issue lies, but this error does not mention any key figure

E - Exception raised from  InternalError: dberror(PreparedStatement.execute): 2048 - column store error: fail to create scenario:  [34011] Inconsistent calculation model;CalculationNode (10_230) -> inputs:Number of inputs has to be between 2 and 2 at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:2054

Detailed log attached.

Please guide.

Regards,

Aditya G

HCPSAP2_11.19.2014.txt.zip

[former_member217157 · Accepted solution]

Hi Aditya,

This is noted in the Release Restriction Note: 204987 as follows

• For calculation expressions, the maximum number of supported input planning levels is 2. Use helper key figures to break down the calculation expressions if there are more than 2 input planning levels. For example, inputs KF1(PL1,stored),KF2(PL2,stored), and KF3(PL3,stored)into a calculation are not supported, but inputs KF1(PL1,stored),KF2(PL1,calculated), and KF3(PL1,stored) are supported.

In other works the number of unique (planned levels and stored property) should be less than or equal to two

If you have a case as following:

KF3@PL1 = KF1@PL1(stored) + KF2@PL1(calc) * KF2 @PL2(calc)

Here the number of input plan level/stored property are 3  ie PL1(stored) , PL1(calc) , PL2(calc)

You should use a Helper Key Figure : HKF1@PL1 = KF1@PL1(stored)

and use in the calc as follows:

KF3@PL1 = HKF1@PL1(calc) + KF2@PL1(calc) * KF2 @PL2(calc)

This way the number of Plan levels/stored Combinations are 2 ie PL1(calc) and PL2(calc)

Hope this helps.

Thanks,

Raghav

[Former Member · Accepted solution]

Hi Raghav,

I am facing the similar issue.

I have configuted a KF calculation-

HKF1@PL1(calc) = Sum(ABS(KF2@PL1(Stored) - KF3@PL1(Stored))

HKF4@PL1(calc) = Sum(KF3@PL1(Sored))

And KF5@PL1(Calc) = HKF1@PL1(calc) / HKF4@PL1(calc.

On activating the Planning area, I am getting following error -

Exception raised from  InternalError: dberror(PreparedStatement.execute): 2048 - column store error: fail to create scenario:  [34011] Inconsistent calculation model;CalculationNode (2_78) -> attributes -> calculatedAttribute (ZWMAPE):Multiple definitions of attribute KF4 found at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:2054

Please suggest the way to solve the error.

[Former Member · Accepted solution]

Hi Achal,

I do not see the following case in your calculations:

"More than 2 input planning levels. For example, inputs KF1(PL1,stored),KF2(PL2,stored), and KF3(PL3,stored)into a calculation are not supported."

Are you sure activation is failing for the mentioned key figures and calculations?

Regards,

Aditya G

[Former Member · Accepted solution]

Hi Aditya,

Thanks for the reply. I am sure that activation is failing due to the above mentioned calculation. As the PA was active before adding this calculation.

Regards

Achal

[Former Member · Accepted solution]

Hi Achal,

Please share your input key figure screens for each of the above key figures.

Regards,

Aditya G

[yeushengteo · Accepted solution]

Hi

Your error is indictating KF4 or HKF4(?) since the calculation definition example you included has no where using KF4.

One possible cause for the KF4 error is that it is marked wrongly as calculated (when it is a stored KF) or stored (when it is a calculated KF). Hence please check through all the calculation definition where KF4 is being used ensuring the input is marked correctly.

Regards.

YS

[Former Member · Accepted solution]

Correct Release Restriction Note: 2049871

[Former Member]

Each calculation expression you define for each key figure has a respective calculation node generated.  10_230 is the node in which your error is complaining. Querying the JSON tables in the *FND schema will help you interpret in which key figure the node is used.

Generally this error message is telling you that one of your expressions it too complex for the system to break down, so it is asking you to chunk up the expression into one or more intermediate calculations. Helper key figure might be useful for you in this case.

For example:

Say you had:

KF0 = (KF1/KF2) + KF3

Try breaking that into:

KF4 = KF1/KF2

Then:

KF0 = KF4 + KF3