Reporting in Enterprise Manager

Enterprise Manager contains many reports designed to provide useful information about your MicroStrategy objects, report processing data, and user and session data. For example, is the length of time jobs wait in queue causing significant delays in report processing? If so, increasing the number of available database connection threads could help decrease the queue time. This is one example of how Enterprise Manager reports can help you.

Enterprise Manager also contains several dashboards, a type of interactive document that uses one or more reports to explore related areas of data. For an intuitive introduction to how which Enterprise Manager can help you analyze report information, use the dashboards before you begin executing any reports. For more details on the contents of the dashboards included with Enterprise Manager, see Dashboard-style Documents.

To run a report in the Enterprise Manager project, you connect to the project as you would any of your other projects. You must have been assigned the appropriate privileges in the Enterprise Manager project by a system administrator.

You can use the Enterprise Manager reports out of the box, or you can modify the reports to return exactly the data you want to analyze for your MicroStrategy environment. For information about customizing the Enterprise Manager reports, see Customizing Enterprise Manager reports to suit your needs.

Enterprise Manager report names are preceded by a number. The integer-numbered reports (such as 81. Activity by User) indicate that the report returns data on a high-level analysis area. The decimal-numbered reports (such as 81.1 Ad-hoc Job Activity by User or 81.2 DB Result Rows by User) indicate that these reports provide more detail within the higher-level analysis area.

Indexes are included for out-of-the-box reports on the Enterprise Manager fact tables. Check the indexes for the Enterprise Manager reports that you run most frequently or that take the longest to complete. If necessary, you should build additional indexes if you find some reports using tables that do not have an index.

The analysis areas of the Enterprise Manager project are described below. Several of the analysis area descriptions include details on one or two representative reports from that area, and suggest report customization ideas that can be used with many of the reports within that analysis area.

• Dashboards-style Documents are an excellent source of summarized data and provide interactive analysis at deeper levels of detail. For descriptions of each Enterprise Manager dashboard, see Dashboard-style Documents.
• Operations analysis reports provide information on system resource usage, concurrency, and report and subscription processing time. For descriptions of these reports, see Operations analysis.
• Performance analysis reports support analysis related to usage patterns, Intelligence Server governing settings, and Intelligent Cube Analysis. For descriptions of these reports, see Performance analysis.
• Project analysis reports provide information about MicroStrategy project growth and the uses of configuration and project objects. For descriptions of these reports, see Project analysis.
• Real-time analysis reports provide information related to response times and schedule results. This information can be useful for troubleshooting and for optimizing your database configuration. For descriptions of these reports, see Real-time analysis.
• User analysis reports analyze user activity and preferences. For descriptions of these reports, see User analysis.

For a detailed list of all Enterprise Manager facts, attributes, and metrics, see the System Administration Guide.

Because Intelligence Server can be configured to log different types of statistics, some of the reports in the Enterprise Manager project are affected if some logging options are not selected. For details about the statistics logging options, see the System Administration Guide.