cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

Holger

Accepted Solutions (1)

Accepted Solutions (1)

lingaiahvanam
Active Contributor
0 Kudos

Hi Holger,

Can you confirm technical weeks involved in your planning levels?

Best Regards,

Lingaiah

Answers (0)