How to perform a disaggregate copy without the use of a planning DSO?

[Former Member]

Hello all,

We have an existing planning model where the need has arisen to enter a % on a high level and have it be copied to all detailed values.

After searching the community for a long time, I've found a few post concerning the same question I have, but with no solution other than creating a planning DSO.

One post however mentioned the fact that it's doable through a copy function without mentioning how.

So I would like to ask you experts if you could help me along with an example maybe?

Thanks in advance.

[gregor_dieckmann]

Hi Erfan,

it seems that you are talking about BPC Embedded.

If yes, please observer that 'disaggregation' is the 'inversion' of aggregation. In your example nothing was aggregated, you just have a list of 'departments' and in the table you have one percent value you want to copy to other departments? If yes, you can use the planning function type 'copy', the characteristic 'department' is a field to be changed in the 'from' section you have 'department' = Department 1 in the 'to' section you have a list of 'departments': Department 2 - Department 5. If the scenario is 'dynamic' you can use variables in the 'from' and 'to' section.

This is pretty standard, you should also check the documentation (BW-IP).

Disaggregation 'copy' makes only sense for key figures that cannot be aggregated (as 'prices' or 'percent' values) and these values should never be stored in InfoCubes but only in DataStore-Objects. InfoCubes are 'insert only' and get 'delta values' and thus one should not store 'prices' or 'percent values' in InfoCubes.

Observe that in BPC Standard also 'prices' and 'percent values' are stored in InfoCubes since not other objects are supported there. But BPC Standard only writes data on the lowest level but BPC Embedded writes data on the level defined by the aggregation level.

Regards,

Gregor

[Former Member]

Gregor, I'm indeed speaking about BPC Embedded.

The above is just the example of the input query and the level at which I would like to input the percentage.

Underneath, this percentage should be copied to the most detailed level, not just to other departments.

Is there no way to avoid using a DSO in this case?

Regards,

Erfan