Skip to Content
Former Member
Jun 15, 2006 at 03:23 AM

BW not able to resolve "Top N" Condition against Custom Hierarchy in 3.0B


I have a simple query that is attempt to display the "Top 15" Product Families in a customer BW Hierarchy.

When I run the query I get a warning message that says BW cannot execute "Top N" queries against hierarchies, but the query runs successfully anyway (this is good). The query actually sorts all the Product Families in Descending order (based on net sales). This is good too. The only problem is the query does not limit the results to the "Top 15" (even though I am sure the Condition is correct because I have done this many times without hierarchies)

Any thoughts on how to overcome this problem and force the results to be limited to "Top N"?