Key Figure @Aggregate Level

[Former Member]

Hi All,

I have requirement where SKU level history needs to be aggregated @ProductGroup Level.

Suppose We have following master data records @base planning level.

ProductGroup   PromoFlag      SKU

PG1                  N                   SKU1

PG1                  P                   SKU2

Now suppose history data @SKU level is as follows.

SKU1 - 100

SKU2 - 200

I have another KF ( AggrgateLevel Sales History) which is defined @base level of ProductGroup

there data is getting shown @aggregate level as 300.

But when I use filter on PromoFlag Attribute then as per filter this aggrgate values get change which I dont want.

So if I select Promoflag as P in IBP then value of KF AggrgateLevel Sales History gets changed to 100.

We want that this value should be always as sum of all sku's history irrespective of filter set on PromoFlag.

Thanks

Ashish Gupta

[Former Member]

Hi Ashish,

When you create the planning level at ProductGroup level, do not include the PromoFlag filter in the planning level. This will eliminate the possibility of the data getting aggregated/disaggregated based on PromoFlag.

Regards,

Chendur