Bring Key Figure down to a lower level using another lower-level KF as Additional Input

[vincentverheyen]

Hi, I believe "Additional Inputs" in a Key Figure calculation can be used to get a value down to a lower level.

Let's say we have a KF1 with data at MONTH + PROD level.
And another KF2 maintained at MONTH + PROD + CUST level.

How can we get KF1 down to MONTH + PROD + CUST level, using not a Copy Operator, but merely the Key Figure's expression; (using KF2 as an additional input)?

Could you solve the example please?

[Irmi_Kuntze]

Hey Vincent

Let's assume you have e.g. KF1@September - Product ABC = 100

KF2 has planning Combination for Product ABC in September for Customers C1, C2 and C3.

Now you want to see the same value of 100 that you have on Product Level as well for each of the three Customers, you simply would write:

KF1@MonthProdCust = KF1@MonthProd

and have the KF2 as additional input.

Values of KF2 don't matter, as long as the periods are initialized.

In order to see the values, you would need to change request level calculation to read from calculated values of KF1@MonthProdCust.

Yours

Irmi