BI 7.0 Calculated Key Figure- Material Counter

[maximina_barry]

I have a Query requirement and hope that someone can assist me on this. I have a CKF that basically counts the number of Materials. Below is an outline of my query:

Rows Columns

Materials Customers Material Counter

Lets say that I have 1500 Materials and I only drilldown by Materials, my Material Counter will give me the correct # of Materials, which is 1500. However, if I drilldown by Material & Customer, I will have multiple customers per material on many occasions.

I understand that my counter is counting the line items. Is there a way to keep the drilldown by Material and Customer and still only count the Materials (ignoring the customer drilldowns)?

Thanks

[Former Member · Accepted solution]

Hi Maximina,

Use exception Aggregation of "Count" for your CKF based on characterstic "Material".

Thanks

Sachin

[maximina_barry]

Thanks Sachin, I was able to do as you suggested and it worked.