Project analysis

Enterprise Manager reports in this analysis area use the Project attribute to analyze various metrics related to project use and Intelligence Server use. Administrators can use these reports to analyze project usage trends and understand how a project grows over time. The reports can help you determine which metadata objects are used and how often, so you can take appropriate actions.

The Project Analysis folder in Enterprise Manager contains the following analysis areas, each with its own reports:

Object properties analysis
Object usage analysis
Project development trends
Prompt usage analysis

These areas are described below, and one report is presented in detail. This sample report has been selected as a representative report of the analysis area; the details and options suggested for the sample report can often be used on other reports in the same or related analysis areas.

Object properties analysis

These reports list the properties of all objects of a specific type in the projects or Intelligence Servers monitored by Enterprise Manager.

Report name	Function
50.1 Attribute Form Properties	Lists the properties of all attribute forms in all monitored projects. This report is paged by project.
50.2 Attribute Properties	Lists the properties of all attributes in all monitored projects. This report is paged by project.
50.3 Column Properties	Lists the properties of all columns in all monitored projects. This report is paged by project.
50.4 Fact Properties	Lists the properties of all facts in all monitored projects. This report is paged by project.
50.5 Hierarchy Properties	Lists the properties of all hierarchies in all monitored projects. This report is paged by project.
50.6 Logical Table Properties	Lists the properties of all tables in all monitored projects. This report is paged by project.
50.7 Transformation Properties	Lists the properties of all transformations in all monitored projects. This report is paged by project.
51.1 Consolidation Properties	Lists the properties of all consolidations in all monitored projects. This report is paged by project.
51.2 Custom Group Properties	Lists the properties of all custom groups in all monitored projects. This report is paged by project.
51.3 Document Properties	Lists the properties of all documents in all monitored projects. This report is paged by project.
51.4 Filter Properties	Lists the properties of all filters in all monitored projects. This report is paged by project.
51.5 Metric Properties	Lists the properties of all metrics in all monitored projects. This report is paged by project.
51.6 Prompt Properties	Lists the properties of all prompts in all monitored projects. This report is paged by project.
51.7 Report Properties	Lists the properties of all reports in all monitored projects. This report is paged by project.
51.8 Template Properties	Lists the properties of all templates in all monitored projects. This report is paged by project.
51.9 Security Filter Properties	Lists the properties of all security filters in all monitored projects. This report is paged by project.
52.1 DB Connection Properties	Lists the properties of all database connections in all monitored Intelligence Servers.
52.2 Event Properties	Lists the properties of all events in all monitored Intelligence Servers.
52.3 Intelligence Server Definition Properties	Lists the properties of all monitored Intelligence Servers.
52.4 Project Properties	Lists the properties of all projects in all monitored Intelligence Servers.
52.5 Schedule Properties	Lists the properties of all schedules in all monitored Intelligence Servers.
52.6 User Group Properties	Lists the properties of all user groups in all monitored Intelligence Servers.
52.7 User Properties	Lists the properties of all users in all monitored Intelligence Servers.
52.8 DB Instance Properties	Lists the properties of all database instances in all monitored Intelligence Servers.
52.9 Device Properties	Lists the properties of all Distribution Services devices in all monitored Intelligence Servers.
52.10 Transmitter Properties	Lists the properties of all Distribution Services transmitters in all monitored Intelligence Servers.
54. User Security Filter Relations	Lists all users and their associated security filters in all monitored Intelligence Servers. This report is paged by project.

Object usage analysis

This analysis area provides reports to analyze how objects are used in MicroStrategy.

The Object Usage Analysis folder has several reports and two folders, each with its own related area of analysis:

Command Manager Reporting
Configuration Object Usage Analysis
Static Report Content Analysis

The reports in the top-level Object Usage Analysis folder can be useful to help you determine what application objects are not being used, and can be safely deleted.

Report name	Function
60.1 Report Statistics	Lists all reports that have not been executed since the specified date and provides the number of times they have been executed. This report is prompted on time.
60.2 Template Statistics	Lists all templates that have not been used since the specified date and provides the number of times they have been used. This report is prompted on time.
61.1 Schedule Statistics	Lists all schedules that have not been used in the specified time frame. This report is prompted on time.
61.2 Server Definition Statistics	Lists all server definitions that have not been used in the specified time frame. This report is prompted on time.
62. Top 10 Reports	Analyzes the server load for the 10 most-executed reports. This report is prompted on time.
63. Report Drilling Analysis	Provides information about how many times a report has been executed and how many times users have drilled from that report. This report is prompted on time.
64.1 Schedule-Report-User Relations	Lists the users, projects, and reports associated with each schedule.
64.2 Schedule-Document- User Relations	Lists the users, projects, and documents associated with each schedule.
65. Report Drilling Patterns	For any report, lists the objects that have been drilled from and drilled to from four-tier clients such as MicroStrategy Web. This report is prompted on time.
66. Find Patterns in Attribute-Metric Associations to Build Cubes	For all jobs that execute for longer than the specified time, lists attributes and metrics that are in the same job. You can include the attributes and metrics in an Intelligent Cube to reduce database use. This report is prompted on how many seconds.

Command Manager Reporting

The reports in this analysis area provide Command Manager syntax that you can use to delete unused objects in a project, including attributes, filters, metrics, and users.

Report name	Function
126.1 Delete Unused Attributes	Provides Command Manager syntax to delete attributes that have not been associated with reports in a project. This report is prompted on the attribute's creation date.
126.2 Delete Unused DB Instances	Provides Command Manager syntax to delete database instances that have no report executions associated. This report is prompted on the database instance's creation date.
126.3 Delete Unused Documents	Provides Command Manager syntax to delete documents that have never been executed. This report is prompted on the document's creation date.
126.4 Delete Unused Filters	Provides Command Manager syntax to delete filters that have not been associated with reports in a project. This report is prompted on the filter's creation date.
126.5 Delete Unused Metrics	Provides Command Manager syntax to delete metrics that have not been associated with reports in a project. This report is prompted on the metric's creation date.
126.6 Delete Unused Reports	Provides Command Manager syntax to delete reports that have never been executed. This report is prompted on the report's creation date.
126.7 Delete Unused Schedules	Provides Command Manager syntax to delete schedules that have never been associated with reports, documents, or users. This report is prompted on the schedule's creation date.
126.8 Delete Unused Security Filters	Provides Command Manager syntax to delete security filters that have no associations with users. This report is prompted on the security filter's creation date.
126.9 Delete Unused Templates	Provides Command Manager syntax to delete templates that are not associated with any reports. This report is prompted on the template's creation date.
126.10 Delete Unused User Groups	Provides Command Manager syntax to delete user groups that do not contain any users. This report is prompted on the user group's creation date.
126.11 Delete Unused Users	Provides Command Manager syntax to delete users that have never connected to the system. This report is prompted on the user's creation date.
126.11.1 Disable Unused Users	Provides Command Manager syntax to disable but not delete users that have never connected to the system. These users can be re-enabled. This report is prompted on the user's creation date.

Configuration Object Usage Analysis

The reports in this analysis area can be useful to help you determine what configuration objects are not being used and can be safely deleted.

Report name	Function
67. Unused DB Instances	Lists all database instances that have not executed a job in a certain period. This report is prompted on time.
68. Unused Projects	Displays all projects that have not been accessed in a certain period, along with usage statistics for all other times. This report is prompted on time.
69. Unused Schedules	Displays all schedules that are not used in any reports or documents.
70. Unused Server Definitions	Displays all server definitions that are not loaded on Intelligence Servers, and those that are loaded but are idle, meaning users are not running jobs or connecting.
71. Unused User Groups	Lists all user groups that do not contain any users.

Static Report Content Analysis

The reports in this analysis area inform you about what report objects are rarely used.

Report name	Function
60.3 Attributes Least Used in Executed Reports	Lists the attributes that are used in the fewest jobs and the most recent time each attribute was used. This report is prompted on time, the number of attributes excluded, and a set of report processing metrics.
60.4 Metrics Least Used in Executed Reports	Lists the metrics that are used in the fewest jobs and the most recent time each metric was used. This report is prompted on time, the number of metrics excluded, and a set of report processing metrics.
60.5 Filters Least Used in Executed Reports	Lists the filters that are used in the fewest jobs and the most recent time each filter was used. This report is prompted on time, the number of filters excluded, and a set of report processing metrics.
62.1 Top n Attributes By Usage In Executed Reports	Lists the most-used attributes. This report is prompted on time, the number of attributes, and a set of report processing metrics.
62.2 Top n Metrics By Usage In Executed Reports	Lists the most-used metrics. This report is prompted on time, the number of metrics, and a set of report processing metrics.
62.3 Top n Filters By Usage In Executed Reports	Lists the most-used filters. This report is prompted on time, the number of filters, and a set of report processing metrics.

Sample report: Report Drilling Patterns

This report lists the objects in each report that have been drilled from and drilled to in four-tier clients such as MicroStrategy Web. The report is paged by project and by report. It prompts you for the dates to be analyzed.

Analysis of drilling and statistics is available only from a four-tier client such as MicroStrategy Web.

Usage scenario

The Report Drilling Patterns report shows you what users want to see, by displaying the most commonly drilled-to objects. This information allows you to determine which attributes to include in a report's list of report objects. Because SQL is not generated for OLAP Services drilling, you can use this report to optimize your OLAP Services implementation.

Sample report display

Report details

Additional options: Use this report in conjunction with other statistics-type reports that display similar usage information about individual objects such as templates, schedules, and so on.

Project development trends

The reports in this folder provide information about the objects and object usage trends in the project.

Report name	Function
70. Summary of Application Objects by Project	Provides a count of all types of application objects (reports, filters, metrics, and so on) in all monitored projects, by owner. This report is paged by project and other object information.
71. Summary of Configuration Objects	Provides a count of all types of configuration objects (schedules, database connections, and so on) in all monitored Intelligence Servers, by owner. This report is paged by object status.
72. Summary of Schema Objects by Project	Provides a count of all types of schema objects (facts, attributes, and so on) in all monitored projects, by owner. This report is paged by project. and other object information.
73. Weekly Project Usage Trend	A grid-graph view showing the weekly trends per project of users, sessions, and requests. This report is prompted on time.
74. Weekly New Application Objects Trend Over a Selected Period	A grid-graph of new application objects created over a specified period. This report is prompted on time.

Prompt usage analysis

The reports in this folder provide information about prompt use and prompt answer trends in a project.

Report name	Function
1. All Prompt Answers for a Given Time Period	Lists all answers to all prompts for a report over the specified period. This report is prompted on time and report. This report is also an as-is view of the IS_PR_ANS_FACT table for the specified period.
1.1 Most Frequently Selected Prompt Answers Per Report, Prompt Combination	Lists all prompt answers all prompts in a report, sorted by frequency. This information can help you choose default prompt answers for each report. This report is prompted on time and report, and paged by project, report, and prompt.
1.2 Which Prompt Answer Values Are Used/Not Used For A Specific Prompt Title?	Lists the number and percentage of jobs that contain each prompt answer. This report is prompted on time, report, and prompt.
1.3 Which Prompts Remain Unanswered?	Lists all optional prompts that are not answered. These prompts might be able to be safely removed from the reports. This report is prompted on time and report.
1.4.1 Distribution of Prompts Within Executed Report Jobs by Prompt Type, Location Type	Provides information about the prompts and prompt locations in executed reports. This report is prompted on time and report.
1.5 Prompt Answers That Result in Reporting Errors	Provides a list of prompt answers that cause errors in report execution, and the corresponding errors. This report is prompted on time and report.