MicroStrategy ONE

Specifying maximum and minimum values: Report limits

A report limit specifies a set of criteria used to restrict the data returned in a result set after the report's metrics are calculated. Because it is based on the report's final metric values, the report limit is applied after all the metrics are calculated. A report limit can make a report more efficient to run, because less information is returned from the data source.

For an introduction to report limits and steps to apply a simple report limit, see Specifying maximum and minimum values: Report limits in Analyzing Data.

For an explanation of the difference between a filter and a report limit, as well as examples of each and how they affect a report, see the Filtering chapter in the Advanced Reporting Help.