Skip to Content

Key figure calculation error - Union of attributes of all input planning levels should be...

Hello,

We have a consensus demand quantity at Period, SKU and Country level and a sourcing ratio at Period, SKU, Country and Location level.

We would like to calculate the location demand by multiplying the consensus demand with the sourcing ratio.

Below you can find the corresponding screenshots.

Can you please advise how to avoid the error message 'Union of attributes of all input planning levels should be equal to all attributes of output planning level' in our example.

Here are the key figure definitions:

Thanks and best regards,

Joachim

loc_demand_KF.png (109.3 kB)
error.png (5.8 kB)
cons_demand_KF.png (87.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 06, 2014 at 06:35 PM

    Hi Joachim,

    The error message "Union of all input planning levels should be equal to attributes of output planning level" means the following in your case:

    In the expression you are trying to save:

    Output Planning Level is : MZ1PERSKULOCCOUNTRY

    Input Planning Levels are : MZ1PERCOUNTRYSKU and MZ1PERSKULOCCOUNTRY

    When you do a union of all attributes in input planning levels, there is a mismatch with attributes defined in the output planning level.

    Now look at the attributes for each Planning level:

    e.g: MZ1PERCOUNTRYSKU : This has attributes of all SKU and COUNTRY master data types along with attribute MZ1NETPRICE of compound master data type MZ1COUNTRYSKU

    However the attributes in Planning level MZ1PERSKULOCCOUNTRY does not have the attributes of the compound master data type MZ1COUNTRYSKU.

    By adding the MZ1COUNTRYSKU to the MZ1PERSKULOCCOUNTRY planning level, the calculation will be valid.

    Hope this helps.

    Thanks,

    Raghav


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 06:36 PM

    Hi Joachim,

    wondering if not having the two key figures at the same base planning level is causing this issue...

    Consensus demand does not have location in base planning level but Sourcing Ratio contails location in its base planning level.

    I'm wondering if this mis-match is causing the issue.

    Kamala

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.