The TOPCOUNT function provides a optional parameter that enables you to include or exclude ties in the result. When ties are included and the last item or items are empty cells, all subsequent empty cells are included in the result. This behavior can negatively affect performance if the result set is very large.

For example, say that the query contains the following expression:

TOPCOUNT({[Products].[ProductIDs].members}, 10, [Measures].[QuantitySold], TRUE)

If the result of this function returns nine members with a value and a tenth empty member, then all other empty members will be included.

As a workaround, remove the option TRUE. In SAS Web Report Studio, you can disable this option by selecting Exclude Ties in the Filter and Rank dialog box.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at: