cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Disaggregation into different KF Base Planning level and with currency

emilioRG
Explorer
0 Likes
1,309

Hi,

Does anyone know how to handle this scenario ?

I've a KF1@WKPRODLOCCUSTCURR, here already has values. Now I need to copy equals values from KF1@WKPRODLOCCUSTCURR to KF2@DAYPRODLOCCUSTCURR. CURR = Currency

What operator should I use? also How should the key figures be set?

Reply is appreciated

Accepted Solutions (1)

Accepted Solutions (1)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Likes

All attributes that are key to the planning level of the source key figure- as long as they are part of the target key figure as well.

Plus for those keys from the source which are missing in the target, the second next detailed from that MD type which is common with the target.

In your case source planning level is WK (technical week) - Product - Location - Customer - Currecy as key, so you pick:

  1. Product, Location and Customer
  2. Currency
  3. technical week (assuming that your KF2@DAYPRODLOCCUSTCURR has technical weeks in the planning level as well. If not, you need to assign it)

And note: if your target planning level would NOT have the currency included, you would need to select on ONE currency for which you copy in the operator, as otherwise you would get too many entries.

Yours

Irmi

emilioRG
Explorer
0 Likes

Hi,

What do you mean with "assuming that your KF2@DAYPRODLOCCUSTCURR has technical weeks in the planning level as well"?, so the Key figure 2 has like planning level "DAY-PROD-LOC-CUST-CURR".

Also I'was trying to generate the dissagregation operator to level:

ATTRIBUTE1 =PRID

ATTRIBUTE2 = LOCID

ATTRIBUTE3 = CUSTID

ATTRIBUTE4 =CURRID

PERIODID = PERIODID5

SOURCE_KFID1= KF1

TARGET_KFID1= KF2

the job ends correctly, but the records in the KF2 are not created

Please, could you help me with it?, thanks.

Answers (2)

Answers (2)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Likes

Is it a cooy of SAPIBP1?

Dies your planning level with days as key have in addition as non-key the technical weeks?

Peridid5 is technucal weeks, if you habe year and quarter and mon and weeks and technical weeks in the planning area, do you have that?

Is your target kf stored and does the plaanning combination exist?

Ifvthat all does not help, you need to provide the ecooy log

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Likes

Easiest way is to use the DISAGG operator and copy on the level of the source key figure

Disaggregation will be done by the settings of the target key figure

See model config guide for details and search for the DISAGG operator

help.sap-com/IBP --> Model Config Guide

emilioRG
Explorer
0 Likes

Thank you,

what attributes should I choose and set up on the Disagg operator?. For example, Should I put the CURRID Attributes?.