Version 2021

About report limits

Report limits are filtering criteria that limit the final result set that is returned to the client. A report limit specifies a set of criteria used to restrict the data returned in the report dataset after the report metrics are calculated. Because it is based on the report's metric values, a limit is applied after all metrics on the report are calculated. Set the report limit using the Report Data Options dialog box.

MicroStrategy allows you to set limits on any metric applied to a report. Limit criteria for this purpose include:

  • Value (for example, include only items greater than a specified value for the metric applied)

  • Rank (for example, include only the top ten items on a list)

  • Percent (for example, include only those items whose value is in the top ten percent of the metric applied)

In many ways, a metric qualification is similar to the concept of report limit. There are, however, behavioral differences between the two:

  • Metric qualifications are part of the WHERE clause in SQL statements; report limits belong to the HAVING clause.

  • In metric qualifications, the filter is applied before the engine performs metric calculation; in report limits, the engine performs metric calculation before the filter is applied.

  • Metric qualifications include an output level while report limits do not.

For more information on metric qualifications, see Metric set qualifications.

Break by

If a metric limit uses rank or percent, the break by property is the attribute level at which to restart counting rank or percent values for a metric.

To view report limit settings

  1. Open a report whose limit settings you want to view.

  2. From the Data menu, select Report Data Options. The Report Data Options dialog box opens.

  3. Under Categories, expand Calculations, then select Report Limit. The report limit settings are displayed under the Report Limit settings.

Related Topics