MicroStrategy ONE

Reports and Dashboards in Enterprise Manager

Enterprise Manager comes equipped with several preconfigured reports and dashboards that provide insight into your MicroStrategy objects, report processing data, and user and session data. You can use the Enterprise Manager reports and dashboards out-of-the-box, or you can modify the reports to return exactly the data you want to analyze for your MicroStrategy environment. To run a report in the Enterprise Manager project, you connect to the project as you would any of your other projects. Some sample reports and dashboards are shown below. For more information on the available out-of-the-box reports and dashboards, see the Reporting in Enterprise Manager section of the Enterprise Manager Help.

Project Analysis (Interactive) Dashboard

This dashboard provides usage information for a project, including object storage, patterns in project growth, and a list of unused application objects for cleanup.

  • The Overview portion provides a general view of project performance and project size.
  • The Growth portion provides details about new application objects added to the project.
  • The Usage portion provides a picture of the most frequently used objects in the project.
  • The Clean Up portion provides a view of unused objects in the project.

KPIs

Select a week from the top left selector. The top row of grids display KPI trends for the selected week compared to the week prior as indicated by an arrow (up/down/no change). Each of these trend indicator grids correspond to a more detailed view of each KPI over time in the four combination charts directly below.

Report Usage Analysis Dashboard

This dashboard provides an overview of report usage and performance in your projects, including average wait times and number of execution errors encountered. The user specifies the period for analysis.

  • The Reporting Details portion provides in-depth information on individual reports within a given project. Select a report from the drop-down list.
  • The Processing Summary portion provides a general picture of report activity for a given project and Intelligence Server.

Delivery Processing Analysis

This analysis area provides several reports that analyze the Distribution Services subscription activity in your system.

Report name

Function

111. Weekly Subscription Activity

Provides a comprehensive weekly summary of subscription activity.

112. Subscription Statistics

Provides subscription activity over a given time interval. This report is prompted on time.

113. User Subscription Statistics

Provides information for users on subscription execution over a given time interval. This report is prompted on time.

114. Top 10 Subscribed Documents

Provides insight into the documents that contribute to the top 10 percent of recipients; execution time; or number of subscriptions over a time interval. This report is prompted on time and on which subscription analysis metric to use.

115. Top 10 Subscribed Reports

Provides insight into the reports that contribute to the top 10 percent of recipients, execution time, or number of subscriptions over a time interval. This report is prompted on time and on which subscription analysis metric to use.

116. Top 10 Subscribed Contacts

Provides insight into the users that contribute to the top 10 percent of recipients, execution time, or number of subscriptions over a period. This report is prompted on time and on which subscription analysis metric to use.

117. Top 10 Longest Executing Subscriptions

Lists the top 10 percent of subscriptions that contribute to the execution times over a period. This report is prompted on time.

User preference analysis

This analysis area provides reports to analyze the effects of user group activity on the system. Administrators can measure the following:

  • What groups do specific users belong to?
  • What reports are most commonly executed by members of a specific user group?

Report name

Function

90. List User Groups to which users belong

Lists all user groups to which the specified users belong. This report is prompted on user.

91. Popular reports in a user's User Group

Lists the top N most-executed reports in a user's user group. This report is prompted on user, time, and number of reports.

Cube Advisor

The reports in this analysis area give an overview of database execution statistics for report requests. They provide a picture of how measures such as report execution times are affected if reports are run against Intelligent Cubes rather than the data warehouse.

You can use the Database Execution Time of Reports report with Cube Advisor to provide data on the performance benefits of potential Intelligent Cubes, such as any decrease in the time required to execute SQL statements and the number of users that would be affected by the recommended Intelligent Cubes. For information on this report's contents and steps for exporting it and importing into Cube Advisor, see the Dynamic Sourcing chapter in the In-memory Analytics Help.

Report name

Function

46. Report Object Listing

Provides analysis of the attributes and metrics in a report. This report is prompted on report.

47. Projected Cube Execution Time of Reports

Projects the execution times of report jobs if they were to hit an Intelligent Cube. This report is prompted on time and on report.

48. Database Execution Time of Reports

Provides database execution statistics for report requests. This report is prompted on time and on project. You can export this report as an Excel file and then import it to the Cube Advisor.