Limit the Total Number of XML Drill Paths

Another way that you can prevent reports from consuming too much memory is to limit the number of XML drill paths allowed on reports in MicroStrategy Web products. The default drill map for reports uses all attributes included in hierarchies marked as drill hierarchies. Report designers can significantly reduce the size of an attribute's drill path by modifying a report's drill map to include fewer drill options. You can also impose a limit for all reports coming from MicroStrategy Web products by setting the Maximum number of XML drill paths.

For more information about customizing drill maps, see the Advanced Reporting Help.

To set this limit, in the Intelligence Server Configuration Editor, select the Governing Rules: Default: File Generation category, then specify the Maximum number of XML drill paths. You must restart Intelligence Server for the new limit to take effect.

Disabling XML caching for a project may have a negative effect on performance, especially for large reports. For more information, see Types of Result Caches and Controlling Access to Objects: Permissions.