Number of Report Result Rows

You can configure MicroStrategy at the project level to limit the number of report rows to be returned from the data warehouse and displayed to the user. This setting is configurable in the Project Configuration Editor. (In Developer, right-click a project, select Project Configuration, expand Governing Rules, expand Default, and select Result sets. The setting is Number of report result rows.)

If you change this setting, reports may still continue to be returned and displayed showing more than the maximum number of report result rows allowed. This is because this setting is designed to apply only to reports created after this setting has been changed. When you change this setting, no existing reports are affected.

You can limit the number of report result rows on existing (and new) reports individually, using the Result Set Row Limit VLDB property. The Result Set Row Limit VLDB property can be specified for any report. For instructions on setting VLDB properties, see the VLDB Properties section in the System Administration Help.