Disaggregation in two directions

[DanielElwart]

Hi everybody,

at a customer we got the following situation:

We have an Input Read Query on BW 7.4.

Frontend is Analysis for Office 1.4

The Query has in the rows a drill down over a hierachy on cost elements.

In the colums we have an actual colum on the prior full fiscal year.

We also have 13 Input ready columns for plan columns.

One for the full fiscal year, and one for each periods 1 to 12.

We use disaggregation to enter values on the full plan year and fill each period by equal distribution.

We want to use also the disaggregation to enter the values on hierachy nodes and not only on single cost elements with reference to the actual year.

The disaggregation according the periods works fine.

Example: This is what we got

CostElement	Actual	Plan Total Year	Plan Period 1	Plan Period 2
Total Cost	100	120,  value entered	10	10
--- Cost Element 1	20	40	3,3333	3,3333
--- Cost Element 2		40	3,3333	3,3333
--- Cost Element 3	80	40	3,3333	3,3333

This is what we want to have:

CostElement	Actual	Plan Total Year	Plan Period 1	Plan Period 2
Total Cost	100	120, value entered	10	10
--- Cost Element 1	20	24	2	2
--- Cost Element 2
--- Cost Element 3	80	96	8	8

How can we achieve this?

The disaggregation according to the cost elements hierarchy works fine on period level, but not on total year level.

So if we enter i.e. the 10 on Plan Period 1 the values 2 and 8 are correctly derived.

Best regards

Daniel

[cornelia_lezoch · Accepted solution]

Hi Daniel,

I think it will not be possible only with disaggregation.

I would run a disaggregation according to actuals (on year level) and afterwards run a distribution function from year down to periods.

regards

Cornelia

[DanielElwart · Accepted solution]

Hi Cornelia,

thanks very much for the input.

We discussed that with the customer and made the year-column to disaggregate with self reference.

Planvalues will be copied from last plan version und can be adjusted.

The period based columns got switched to equal distribution. But that only because there is some bug in Analysis, it crashes when more than a handfull columnes are set to self reference, BEx Analyzer workds fine with it.

Best regards

Daniel