Skip to Content
0
Jan 13, 2012 at 04:06 PM

Help with hiding key figures at aggregate level

73 Views

Experts,

I need help with one of my DP macros please. I have searched this forum for both DET_LEVEL and AGG_LEVEL but none seem to be relevant for what I am trying to accomplish.

I have key figures that I would like to hide when a user is at an aggregate level, such as product or location when in interactive demand planning book. The reason is that these key figures do not make sense at an aggregated level, for example a %. In 4.0, we just grayed out the values (but they were still there when a user exported), so I would like to actually hide these rows in 7.0.

The issue I am having is after loading multiple products, I use the header to drill down to 1 product, the row does not display as it should. The macro works when I select and load multiple products (I am at 1 location), the key figure is not displayed, but when I use the arrow in the product header to go to 1 individual product, the row is still not displayed.

Here is my macro:

IF DET_LEVEL( 'product' ) = 0 OR DET_LEVEL( 'location' ) = 0

Key figure attributes = ROW_VISIBLE( 0 )

END IF

I have tried multiple things...

1. I had an 'else' to set it back to visible, and it seemed to work as long as I don't mess with the key figures selected in the planning book. But when a user changes the key figures via key figure selections and does not choose the key figure in this macro, the macro was showing it regardless of what the user selected when at lowest level.

2. I have tried both DET_LEVEL and AGG_LEVEL

3. I have tried 'Details only', 'All planning objects' and 'Certain levels -> Agg. level' with no differences

4. I have the macro as a default macro and as a level change macro

Thanks,

Kristin