Strategy ONE

MDX TopCount Support

MDX TopCount Support is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

This VLDB property determines whether TopCount is used in place of Rank and Order to support certain MicroStrategy features such as metric filter qualifications. TopCount can be used with SAP BW and Microsoft Analysis Services MDX cube sources.

You can choose from the following settings:

  • Do not use TopCount in the place of Rank and Order: The functions Rank and Order are always used instead of TopCount. This option supports backwards compatibility.
  • Use TopCount instead of Rank and Order (default): The function TopCount is automatically used in place of Rank and Order when necessary to support certain MicroStrategy features. This includes scenarios such as using metric filter qualifications on MDX cube reports.

Levels at Which You Can Set This

Database instance and report