Skip to Content
author's profile photo Former Member
Former Member

Problem in counting/aggregating key figure in query result


I have some trouble with the aggregation of key figure values in query results. Let me explain using an example:

In a query result I have the characteristics Supplier, Product and the key figures Order quantity, Nr. of different products. This last key figure is a counter that sometimes results 0.

The result could be as following:

Supplier Product Nr.of diff Products

A A1 1

A A2 1

A A5 0

A A3 1

When I look at the results of the query at this detail level, the result row of Nr. of different Products is 3, excactly as I want it to be. My problem occurs when I remove the drill-down on Product. In this case, I see the following:

Supplier Nr.of diff Products

A 4

As you can see the values 1, 1, 0 and 1 in the drill down are all counted and the result is 4. However, I would like it to just sum up the individual numbers and it to result 3.

I have tried (hard) to adjust my settings of the key figure in the query designer, but I can't solve this problem.

Can you please help me out?

Best regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 19, 2005 at 08:02 AM

    Did you implemented the solution descibed in "How to … Count the occurrences of a characteristic" (see under InfoIndex section), or something else?

    Best regards


    Add a comment
    10|10000 characters needed characters exceeded

    • I never had other problems but this and can say the ASAP is pretty good. Let me suggest to check the InfoCube content with LISTCUBE without any aggregation criteria (no flag on DB Aggregation, I mean): that's the best way in my opinion to see 0's rows origin ...

      About the causes of this phenomenon I can't help you but according to me you should investigate further

      Good luck


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.