Skip to Content

Show NULL on all (aggregation) planning levels except base planning level?

Sep 12, 2017 at 12:52 PM


avatar image

Dear experts,

I created a Key Figure (say NOAGGREGATION@PERPRODLOC) which plays an important role on its lowest possible aggregation level (DAYPRODLOC), but will always show more or less "wrong" results when aggregated in one of the "standard" ways. (through both higher time buckets or other product/location characteristics).

In order to not confuse planners who might want to look at a higher aggregation level (e.g. month instead of day), my requirement looks something like this:

If request level equals the base planning level (DAYPRODLOC), show the corresponding stored values at this planning level- otherwise show NULL.

While playing around with the request calculation (also including intermediate planning levels similar to a last period aggregation), I was not able to achieve the desired result.

Anybody here with some ideas or who has experienced a requirement like this before?

Best regards


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lingaiah Vanam Sep 21, 2017 at 06:31 AM

Hi Holger,

Can you confirm technical weeks involved in your planning levels?

Best Regards,


10 |10000 characters needed characters left characters exceeded