Skip to Content

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

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 21, 2017 at 06:31 AM

    Hi Holger,

    Can you confirm technical weeks involved in your planning levels?

    Best Regards,


    Add comment
    10|10000 characters needed characters exceeded