dissagregation

[Former Member]

Hi all

I have the following question regarding dissagregation:

I have one key figure Z by plant/material

Material A Total 80

Material A plant 1000 20

Material A plant 2000 50

Material A plant 3000 10

And based on this key figure I dissagregate other key figure Y

Material A Total 160

Material A plant 1000 40

Material A plant 2000 100

Material A plant 3000 20

And now I change key figure Z,

Material A Total 100

Material A plant 1000 0

Material A plant 2000 90

Material A plant 3000 10

AND KEY FIGURE Y CONTINUES LIKE THIS

Material A Total 160

Material A plant 1000 40

Material A plant 2000 100

Material A plant 3000 20

The dissagregation of key figure Y, now is not updated

How can I change automatically the new dissagregation of key figure Y??

Thanks

[Former Member · Accepted solution]

Hi Fernando,

Try refreshing the value of key figure Y (macro to add 0.001 to the existing number) at the aggregate level. The new disaggregation rules will be effective when the value for key figure Y is changed/refreshed at the aggregate level. Check if this works.

Regards,

Kedar

[Former Member · Accepted solution]

Hi Fernando,

What Kedar suggested will work.

People used to add 1 in a step then remove 1, to find the original value.

I perosnnaly prefer to

1. "Save" the result on a auxilary key figure

2. Use the "ROW_CLEAR()" function

3. put the result back from the auciliary key figure

Thanks and Regards

Julien

[Former Member]

Adding +1 and then doing -1 will work. My personal experience is that we need to actually save after every +1 and -1.

This may get kind of frustrating when you have to do it quite often. A better trick is to use a directly executable macro to just Drill Down and Drill back up. This will trigger disaggregation without any saving required.

Regards,

Abhi