Skip to Content
Jan 27, 2016 at 10:27 AM

Key Figure Copy across Planning Levels with different Time Profile


Dear experts,

I am looking for a solution for the following issue:

I have one Key Figure "TESTMONTH" at Base Planning Level MONTHPRODCUST, the month is the lowest time period.

I have another Key Figure "TESTWEEK" at Base Planning Level WEEKPRODCUST, the week ist the lowest time period (but month is included as well).

The only difference between the two planning levels is that the weekly level is cut out of planning level MONTHPRODCUST.

Now I want to copy the key figure values stored at monthly level in TESTMONTH to the monthly level at TESTWEEK. Afterwards, the monthly key figure value at TESTWEEK should disaggregate to the weeks of each month proportionally.

This is exactly what would happen when I create a planning view in Excel and copy the key figure values manually, but I am looking for an automated solution (e.g. by formulas; copy operator). I could not make the copy operator work in this particular setting.

Any hints/recommendations to solve the issue? Thanks a lot in advance!