User analysis

Reports in this analysis area contain the User attribute as their primary attribute for analysis, along with various metrics that answer an administrator's questions about user activity and preferences.

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

• User activity analysis

• User preference analysis

These areas are described below, and two reports are presented in detail. These sample reports have been selected as representative reports of the analysis area; the details and options suggested for the sample reports can often be used on other reports within the same or related analysis areas.

User activity analysis

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

• Who are the most prolific users in terms of number of jobs, connection duration, and so on?

• How are users using features such as ad hoc reporting, drilling, and so on?

• Which users are using the system correctly and which need more training, as identified by the number of canceled jobs and jobs with errors?

Report name	Function
80. Top (n) users	Determines the top (n) users, using a metric you choose from a list. This report is prompted on time, a list of metrics, and the number of users.
81. Activity by User	Provides summary information of user reporting activity by user and project. This report is prompted on time.
81.1 Ad-hoc activity by User	Provides information about how many ad hoc jobs are being run and the composition of ad hoc jobs. This report is prompted on time.
81.1.1 Drilling Activity by User	Provides information about how many jobs each user has run and how many of those jobs resulted from drilling. This report is prompted on time.
81.2 DB Result Rows by User	Provides the number of jobs, the number of database result rows, and the average elapsed report execution duration per user and project. This report is prompted on time.
82. Unused/Inactive Users	Lists all users who have not logged in since the specified date and provides information about their connections. This report is prompted on time.
83. User Inactivity by Project	Provides a list of users who have not connected to a project over a certain time interval. It also provides the last connection and disconnection timestamp.
84. User Analysis based on Wait Time (End-to-End)	Lists users who requested content via MicroStrategy Mobile along with information such as their total wait time, Intelligence Server time, device rendering time, network time, and how many manipulations they made.

Sample report: Activity by User

This report provides data on total elapsed report duration. It also provides counts of canceled jobs, non-canceled jobs, jobs that end with an error, and timed-out jobs by user and by project. This report prompts for a time for the analysis.

Usage scenario

You can use this report to gain insight into how reports are used per project by all users. You can determine which users are wasting resources by repeatedly canceling jobs and determine who run the most reports in a project. You can also see where reporting errors originate.

Report details

• Drill paths:

  • To narrow the scope of your analysis to individual sessions, drill across from User to Session and keep the parent attribute.

  • To identify the reports and documents that were executed by a user during a session, drill across from Session to Report/Document.

• Other options:

  • To restrict your analysis to the most prolific users using your chosen criteria, add the report Top (n) Users as a filter to this Enterprise Manager report.

  • To determine which projects a user is using, add a filter on user.

  • To restrict your analysis to a machine or connection source, add any attribute from the Session folder to this Enterprise Manager report.

Sample report: Top (n) Users

This report displays the top N users according to the user activities you select. The report prompts you for user activities and the number of users you want returned.

Usage scenario

You can use this report to learn the top users in a number of analysis areas related to user activity:

• Which users log in to Intelligence Server most often (select the Number of Sessions metric)

• Which users are connected the longest (select the Connection Duration metric)

• Which users run the most report jobs (select the RP Number of Jobs metric)

Report details

• Add your own metrics to this report for user activity analysis that focuses on your environment's requirements.

• Use this report as a filter in custom reports that you create. For example, the Activity by User report returns the total elapsed time for report execution by user and project, and the number of canceled and non-canceled jobs. To narrow the results to the top 10 users responsible for the highest number of canceled jobs, you can add this Top (n) Users report as a filter to the Activity by User report. This allows you to analyze overall user activity and determine whether these users are canceling jobs legitimately.

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.