All Indicators and Flags Attributes

Attribute name	Function
Ad Hoc Indicator	Indicates whether an execution is ad hoc.
Cache Creation Indicator	Indicates whether an execution has created a cache.
Cache Hit Indicator	Indicates whether an execution has hit a cache.
Cancelled Indicator	Indicates whether an execution has been cancelled.
Child Job Indicator	Indicates whether a job was a document dataset or a stand-alone report.
Configuration Object Exists Status	Indicates whether a configuration object exists.
Configuration Parameter Value Type	Lists all configuration parameter types.
Connection Source	Lists all connection sources to Intelligence Server.
Contact Type	Lists the executed contact types.
Cube Hit Indicator	Indicates whether an execution hit an intelligent cube or database.
Database Error Indicator	Indicates whether a report request failed because of a database error.
Datamart Indicator	Indicates whether an execution created a data mart.
DB Error Indicator	Indicates whether an execution encountered a database error.
Delivery Status Indicator	Indicates whether a delivery was successful.
Delivery Type	Lists the type of delivery.
Document Job Status (Deprecated)	Lists the statuses of document executions.
Document Job Step Type	Lists all possible steps of document job execution.
Document Type	Indicates the type of a document or dashboard, such as a Report Services document or dashboard.
Drill from Object	Lists the object from which a user drilled when a new report was run because of a drilling action.
Drill Indicator	Indicates whether an execution is a result of a drill.
Drill to Object	Lists the object to which a user drilled when a new report was run because of a drilling action.
Element Load Indicator	Indicates whether an execution is a result of an element load.
Error Indicator	Indicates whether an execution encountered an error.
Execution Type Indicator	Indicates how the content was requested, such as User Execution, Pre-Cached, Application Recovery, and so on.
Export Indicator	Indicates whether a report was exported and, if so, indicates its format.
Hierarchy Drilling	Indicates whether a hierarchy is used as a drill hierarchy.
Inbox Action Type	List the types of manipulations that can be performed on a History List message.
Intelligent Cube Action Type	Lists actions performed on or against intelligent cubes.
Intelligent Cube Type	Lists all intelligent cube types.
Job ErrorCode	Lists all the possible errors that can be returned during job executions.
Job Priority Map	Lists the priorities of job executions.
Job Priority Number	Enumerates the upper limit of the priority ranges for high, medium, and low priority jobs. Default values are 332, 666, and 999.
Object Creation Date	Indicates the date on which an object was created.
Object Creation Week of year	Indicates the week of the year in which an object was created.
Object Exists Status	Indicates whether an object exists.
Object Hidden Status	Indicates whether an object is hidden.
Object Modification Date	Indicates the date on which an object was last modified.
Object Modification Week of year	Indicates the week of the year in which an object was last modified.
Prompt Answer Required	Indicates whether a prompt answer was required for the job execution.
Prompt Indicator	Indicates whether a job execution was prompted.
Report Job SQL Pass Type	Lists the types of SQL passes that the Intelligence Server generates.
Report Job Status (Deprecated)	Lists the statuses of report executions.
Report Job Step Type	Lists all possible steps of report job execution.
Report Type	Indicates the type of a report, such as XDA, relational, and so on.
Report/Document Indicator	Indicates whether the execution was a report or a document.
Schedule Indicator	Indicates whether a job execution was scheduled.
Security Filter Indicator	Indicates whether a security filter was used in the job execution.
SQL Clause Type	Lists the various SQL clause types used by the SQL Engine.
SQL Execution Indicator	Indicates whether SQL was executed in the job execution.

Application Objects Attributes

Attribute name	Function
Consolidation	Lists all consolidations in projects that are set up to be monitored by Enterprise Manager.
Custom Group	Lists all custom groups in projects that are set up to be monitored by Enterprise Manager.
Document	Lists all documents in projects that are set up to be monitored by Enterprise Manager.
Filter	Lists all filters in projects that are set up to be monitored by Enterprise Manager.
Intelligent Cube	Lists all intelligent cubes in projects that are set up to be monitored by Enterprise Manager.
Metric	Lists all metrics in projects that are set up to be monitored by Enterprise Manager.
Prompt	Lists all prompts in projects that are set up to be monitored by Enterprise Manager.
Report	Lists all reports in projects that are set up to be monitored by Enterprise Manager.
Security Filter	Lists all security filters in projects that are set up to be monitored by Enterprise Manager.
Template	Lists all templates in projects that are set up to be monitored by Enterprise Manager.

Configuration Objects Attributes

Attribute name	Function
Address	Lists all addresses to which deliveries have been sent.
Configuration Object Owner	Lists the owners of configuration objects.
Configuration Parameter	Lists all configuration parameters.
Contact	Lists all contacts to whom deliveries have been sent.
DB Connection	Lists all database connections.
DB Instance	Lists all database instances.
Device	Lists all devices to which deliveries have been sent.
Event	Lists all events being tracked.
Folder	Lists all folders within projects.
Intelligence Server Definition	Lists all Intelligence Server definitions.
Metadata	Lists all monitored metadata.
Owner	Lists the owners of all objects.
Project	Lists all projects.
Schedule	Lists all schedules.
Subscription	Lists all executed transmissions.
Transmitter	Lists all transmitters.
User	Lists all users being tracked.
User Group	Lists all user groups.
User Group (Parent)	Lists all user groups that are parents of other user groups.

Date and Time Attributes

Attribute name	Function
Calendar Week	Lists every calendar week, beginning with 2000-01-01, as an integer.
Day	Lists all days, beginning in 1990.
Hour	Lists the hours in a day. For example, 09 AM - 10 AM, 10 AM - 11 AM, and so on.
Minute	Lists all the minutes in an hour. For example, if the hour specified is 10 AM - 11 AM, lists minutes as 10.30 AM - 10.31 AM, 10.32 AM - 10.33 AM, and so on.
Month	Lists all months, beginning with 2000.
Month of Year	Lists all months in a specified year.
Quarter	Lists all quarters.
Quarter of Year	Lists all quarters of the year.
Week of Year	Lists all weeks in all years, beginning in 2000. Weeks in 2000 are represented as a number ranging from 200001 to 200053, weeks in 2001 are represented as a number ranging from 200101 to 200153, and so on.
Weekday	Lists all days of the week.
Year	Lists all years.

Delivery Services Attributes and Metrics

Attribute or metric name	Function
Address	Indicates the address to which a delivery was sent.
Avg number of recipients per subscription	Metric of the average number of recipients in subscriptions.
Avg Subscription Execution Duration (hh:mm:ss)	Metric of the average amount of time subscriptions take to execute.
Avg Subscription Execution Duration (secs)	Metric of the average amount of time, in seconds, subscriptions take to execute.
Contact	Indicates all contacts to whom a delivery was sent.
Contact Type	Indicates the executed contact types.
Day	Indicates the day on which the delivery was sent.
Delivery Status Indicator	Indicates whether the delivery was successful.
Delivery Type	Indicates the type of delivery.
Device	Indicates the type of device to which the delivery was sent.
Document	Indicates the document that was delivered.
Hour	Indicates the hour on which the delivery was sent.
Intelligence Server Machine	Indicates the Intelligence Server machine that executed the job.
Metadata	Indicates the monitored metadata.
Minute	Indicates the minute on which the delivery was sent.
Number of Distinct Document Subscriptions	Metric of the number of report services document subscriptions.
Number of Distinct Recipients	Metric of the number of recipients that received content from a subscription.
Number of Distinct Report Subscriptions	Metric of the number of report subscriptions.
Number of Distinct Subscriptions	Metric of the number of executed subscriptions. This does not reflect the number of subscriptions in the metadata.
Number of E-mail Subscriptions	Metric of the number of subscriptions that delivered content via e-mail.
Number of Errored Subscriptions	Metric of the number of subscriptions that failed.
Number of Executions	Metric of the number of executions of a subscription.
Number of File Subscriptions	Metric of the number of subscriptions that delivered content via file location.
Number of History List Subscriptions	Metric of the number of subscriptions that delivered content via the history list.
Number of Mobile Subscriptions	Metric of the number of subscriptions that delivered content via mobile.
Number of Print Subscriptions	Metric of the number of subscriptions that delivered content via a printer.
Project	Lists the projects.
Report	Lists the reports in projects.
Report Job	Lists an execution of a report.
Report/Document Indicator	Indicates whether the execution was a report or a document.
Schedule	Indicates the schedule that triggered the delivery.
Subscription	Indicates the subscription that triggered the delivery.
Subscription Execution Duration (hh:mm:ss)	Metric of the sum of all execution times of a subscription.
Subscription Execution Duration (secs)	Metric of the sum of all execution times of a subscription (in seconds).

Document Job Attributes and Metrics

Attribute or metric name	Function
Day	Indicates the day on which the document job executed.
Document	Indicates which document was executed.
Document Job	Indicates an execution of a document.
DP Average Elapsed Duration per Job (hh:mm:ss)	Metric of the average difference between start time and finish time (including time for prompt responses) of all document job executions.
DP Average Elapsed Duration per Job (secs)	Metric of the average difference, in seconds, between start time and finish time (including time for prompt responses) of all document job executions.
DP Average Execution Duration per Job (secs)	Metric of the average duration, in seconds, of all document job executions.
DP Average Execution Duration per Job (hh:mm:ss)	Metric of the average duration of all document job executions.
DP Average Queue Duration per Job (hh:mm:ss)	Metric of the average duration of all document job executions waiting in the queue.
DP Average Queue Duration per Job (secs)	Metric of the average duration, in seconds, of all document job executions waiting in the queue.
DP Elapsed Duration (hh:mm:ss)	Metric of the difference between start time and finish time (including time for prompt responses) of a document job.
DP Elapsed Duration (secs)	Metric of the average difference, in seconds, between start time and finish time (including time for prompt responses) of a document job.
DP Execution Duration (hh:mm:ss)	Metric of the duration of a document job's execution.
DP Execution Duration (secs)	Metric of the duration, in seconds, of a document job's execution.
DP Number of Jobs (IS_DOC_FACT)	Metric of the number of document jobs that were executed.
DP Number of Jobs with Cache Hit	Metric of the number of document jobs that hit a cache.
DP Number of Jobs with Error	Metric of the number of document jobs that failed.
DP Number of Users who ran Documents	Metric of the number of users who ran document jobs.
DP Percentage of Jobs with Cache Hit	Metric of the percentage of document jobs that hit a cache.
DP Percentage of Jobs with Error	Metric of the percentage of document jobs that failed.
DP Queue Duration (hh:mm:ss)	Metric of the duration of all document job executions waiting in the queue.
DP Queue Duration (secs)	Metric of the duration, in seconds, of all document job executions waiting in the queue.
Hour	Indicates the hour the document job was executed.
Intelligence Server Machine	Indicates the Intelligence Server machine that executed the document job.
Metadata	Indicates the metadata storing the document.
Minute	Indicates the minute the document job was executed.
Project	Indicates the project storing the document.
Report	Indicates the reports in the document.
User	Indicates the user who ran the document job.

Document Job Step Attributes and Metrics

Attribute or metric name	Function
Day	Indicates the day on which the document job executed.
Document	Indicates which document was executed.
Document Job Step Sequence	Indicates the sequence number for steps in a document job.
Document Job Step Type	Indicates the type of step for a document job.
DP Average Elapsed Duration per Job (hh:mm:ss)	Metric of the average difference between start time and finish time (including time for prompt responses) of all document job executions.
DP Average Elapsed Duration per Job (secs)	Metric of the average difference, in seconds, between start time and finish time (including time for prompt responses) of all document job executions.
DP Average Execution Duration per Job (hh:mm:ss)	Metric of the average duration of all document job executions.
DP Average Execution Duration per Job (secs)	Metric of the average duration, in seconds, of all document job executions.
DP Average Queue Duration per Job (hh:mm:ss)	Metric of the average duration of all document job executions waiting in the queue.
DP Average Queue Duration per Job (secs)	Metric of the average duration, in seconds, of all document job executions waiting in the queue.
DP Elapsed Duration (hh:mm:ss)	Metric of the difference between start time and finish time (including time for prompt responses) of a document job.
DP Elapsed Duration (secs)	Metric of the average difference, in seconds, between start time and finish time (including time for prompt responses) of a document job.
DP Execution Duration (hh:mm:ss)	Metric of the duration of a document job's execution.
DP Execution Duration (secs)	Metric of the duration, in seconds, of a document job's execution.
DP Queue Duration (hh:mm:ss)	Metric of the duration of all document job executions waiting in the queue.
DP Queue Duration (secs)	Metric of the duration, in seconds, of all document job executions waiting in the queue.
Hour	Indicates the hour the document job was executed.
Metadata	Indicates the metadata storing the document.
Minute	Indicates the minute the document job was executed.
Project	Indicates the project storing the document.

Enterprise Manager Data Load Attributes

Attribute name	Function
Data Load Finish Time	Displays the timestamp of the end of the data load process for the projects that are being monitored.
Data Load Project	Lists all projects that are being monitored.
Data Load Start Time	Lists the timestamp of the start of the data load process for the projects that are being monitored.
Item ID	A value of -1 indicates that it is the summary row in the EM_IS_LAST_UPDATE table for all projects in a data load. That summary row has information about how long the data load took. A value of 0 indicates it is a row with project data load details.

Inbox Message Actions Attributes and Metrics

Attribute or metric name	Function
Day	Indicates the day the manipulation was started
Document	Indicates the document included in the message.
Document Job	Indicates the document job that requested the History List message manipulation.
HL Days Since Last Action: Any action	Metric of the number of days since any action was performed.
HL Days Since Last Action: Request	Metric of the number of days since the last request was made for the contents of a message.
HL Last Action Date: Any Action	Metric of the date and time of the last action performed on a message such as read, deleted, marked as read, and so on.
HL Last Action Date: Request	Metric of the date and time of the last request made for the contents of a message.
HL Number of Actions	Metric of the number of actions performed on a message.
HL Number of Actions by User	Metric of the number of actions by user performed on a message.
HL Number of Actions with Errors	Metric of the number of actions on a message that resulted in an error.
HL Number of Document Jobs	Metric of the number of document jobs that result with messages.
HL Number of Messages	Metric of the number of messages.
HL Number of Messages with Errors	Metric of the number of messages that resulted in an error.
HL Number of Messages Requested	Metric of the number of requests for the contents of a message.
HL Number of Report Jobs	Metric of the number of report jobs that result from messages.
Hour	Indicates the hour the manipulation was started on a History List message.
Inbox Action	Indicates the manipulation that was performed on a History List message.
Inbox Action Type	Indicates the type of manipulation that was performed on a History List message.
Inbox Message	Indicates the message in the History List.
Intelligence Server Machine	Indicates the Intelligence Server machine that executed the message.
Metadata	Indicates the metadata storing the message.
Minute	Indicates the minute the manipulation was started.
Project	Indicates the project storing the message.
Report	Indicates the report included in the message.
Report Job	Indicates the job ID of the report included in the message.
User	Indicates the user who manipulated the History List message.

Mobile Client Attributes

Attribute name	Function
Cache Hit Indicator	Indicates whether a cache was hit during the execution and, if so, what type of cache hit.
Day	Indicates the day the action started.
Document	Identifies the document used in the request.
Execution Type Indicator	Indicates the type of report or document that initiated the execution.
Geocode	Indicates the location, in latitude and longitude form, of the user.
Hour	Indicates the hour the action started.
Intelligence Server Machine	Indicates the Intelligence Server processing the request.
Metadata	Indicates the metadata repository storing the report or document.
Minute	Indicates the minute the action started.
Mobile Device Installation ID	Indicates the unique Installation ID of the mobile app.
Mobile Device Type	Indicates the type of mobile device the app is installed on, such as IPAD2, DROID, and so on.
MSTR App Version	Indicates the version of the MicroStrategy app making the request.
Network Type	Indicates the type of network used, such as 3G, WIFI, LTE, and so on.
Operating System	Indicates the operating system of the mobile device making the request.
Operating System Version	Indicates the operating system version of the mobile device making the request.
Project	Indicates the project used to initiate the request.
User	Indicates the user that initiated the request.

OLAP Services Attributes and Metrics

Attribute or metric name	Function
Day	Indicates the day the action was started.
Hour	Indicates the hour the action was started.
Intelligent Cube	Indicates the Intelligent Cube that was used.
Intelligent Cube Action Duration (secs)	Metric of the duration, in seconds, for an action that was performed on the Intellgent Cube.
Intelligent Cube Action Type	Indicates the type of action taken on the Intelligent Cube such as CUBE PUBLISH, CUBE VIEW HIT, and so on.
Intelligent Cube Instance	Indicates the Intelligent Cube instance in memory that was used for the action.
Intelligent Cube Size (KB)	If the Intelligent Cube is published or refreshed, indicates the size, in KB, of the Intelligent Cube.
Intelligent Cube Type	Indicates the type of Intelligent Cube used, such as working set report, Report Services Base report, OLAP Cube report, and so on.
Minute	Indicates the minute on which the action was started.
Number of Dynamically Sourced Report Jobs against Intelligent Cubes	Metric of how many jobs from reports not based on Intelligent Cubes but selected by the engine to go against an Intelligent Cube because the objects on the report matched what is on the Intelligent Cube.
Number of Intelligent Cube Publishes	Metric of how many times an Intelligent Cube was published.
Number of Intelligent Cube Refreshes	Metric of how many times an Intelligent Cube was refreshed.
Number of Intelligent Cube Republishes	Metric of how many times an Intelligent Cube was republished.
Number of Jobs with Intelligent Cube Hit	Metric of how many job executions used an Intelligent Cube.
Number of Users hitting Intelligent Cubes	Metric of how many users executed a report or document that used an Intelligent Cube. That is, the number of users using OLAP Services.
Number of View Report Jobs	Metric of how many actions were the result of a View Report.
Report	Indicates the report that hit the Intelligent Cube.

Performance Monitoring Attributes

Attribute name	Function
Counter Category	Indicates category of the counter, such as memory, MicroStrategy server jobs, or MicroStrategy server users.
Counter Instance	Indicates the instance ID of the counter, for MicroStrategy use.
Day	Indicates the day the action was started.
Hour	Indicates the hour the action was started.
Minute	Indicates the minute the action was started.
Performance Monitor Counter	Indicates the name of the performance counter and its value type.

Prompt Answers Attributes and Metrics

Attribute or metric name	Function
Connection Source	Indicates the connection source to Intelligence Server.
Count of Prompt Answers	Metric of how many prompts were answered.
Day	Indicates the day the prompt was answered.
Document	Indicates the document that used the prompt.
Hour	Indicates the hour the prompt was answered.
Intelligence Server Machine	Indicates the Intelligence Server machine that executed the job.
Metadata	Indicates the metadata repository storing the prompt.
Minute	Indicates the minute the prompt was answered.
Project	Indicates the project storing the prompt.
Prompt	Indicates the prompt that was used.
Prompt Answer	Indicates the answers for the prompt in various instances.
Prompt Answer Required	Indicates whether an answer to the prompt was required.
Prompt Instance Answer	Indicates the answer of an instance of a prompt in a report job.
Prompt Location	Indicates the ID of the location in which a prompt is stored.
Prompt Location Type	Indicates the type of the object in which the prompt is stored, such as filter, template, attribute, and so on.
Prompt Title	Indicates the title of the prompt (the title the user sees when presented during job execution).
Prompt Type	Indicates what type of prompt was used, such as date, double, elements, and so on.
Report	Indicates the report that used the prompt.
Report Job	Indicates the report job that used the prompt.
RP Number of Jobs (IS_PR_ANS_FACT)	Metric of how many jobs involved a prompt.
RP Number of Jobs Containing Prompt Answer Value	Metric of how many report jobs had a specified prompt answer value.
RP Number of Jobs Not Containing Prompt Answer Value	Metric of how many report jobs did not have a specified prompt answer value.
RP Number of Jobs with Unanswered Prompts	Metric of how many report jobs had a prompt that was not answered.

Report Job Attributes and Metrics

Attribute or metric name	Function
Ad Hoc Indicator	Indicates whether an execution is ad hoc.
Cache Creation Indicator	Indicates whether an execution has created a cache.
Cache Hit Indicator	Indicates whether an execution has hit a cache.
Cancelled Indicator	Indicates whether an execution has been canceled.
Child Job Indicator	Indicates whether a job was a document dataset or a standalone report.
Connection Source	Indicates the connection source to Intelligence Server.
Cube Hit Indicator	Indicates whether an execution hit an intelligent cube or database.
Database Error Indicator	Indicates whether a report request failed because of a database error.
Datamart Indicator	Indicates whether an execution created a data mart.
Day	Indicates the day on which the report was executed.
DB Instance	Indicates the database instance on which the report was executed.
Drill Indicator	Indicates whether an execution is a result of a drill.
Element Load Indicator	Indicates whether an execution is a result of an element load.
Error Indicator	Indicates whether an execution encountered an error.
Export Indicator	Indicates whether a report was exported and, if so, indicates its format.
Filter	Indicates the filter used on the report.
Hour	Indicates the hour on which the report was executed.
Intelligence Server Machine	Indicates the Intelligence Server machine that executed the report.
Metadata	Indicates the metadata repository that stores the report.
Minute	Indicates the minute on which the report execution was started.
Number of Jobs with Intelligent Cube Hit	Metric of how many job executions used an Intelligent Cube.
Project	Indicates the metadata repository that stores the report.
Prompt Indicator	Indicates whether the report execution was prompted.
Report	Indicates the ID of the report that was executed.
Report Job	Indicates an execution of a report.
RP Average Elapsed Duration per Job (hh:mm:ss) (IS_REP_FACT)	Metric of the average difference between start time and finish time (including time for prompt responses) of all report job executions.
RP Average Elapsed Duration per Job (secs) (IS_REP_FACT)	Metric of the average difference between start time and finish time (including time for prompt responses) of all report job executions.
RP Average Execution Duration per Job (hh:mm:ss) (IS_REP_FACT)	Metric of the average duration of all report job executions. Includes time in queue and execution for a report job.
RP Average Execution Duration per Job (secs) (IS_REP_FACT)	Metric of the average duration, in seconds, of all report job executions. Includes time in queue and execution for a report job.
RP Average Prompt Answer Time per Job (hh:mm:ss)	Metric of the average time users take to answer the set of prompts in all report jobs.
RP Average Prompt Answer Time per Job (secs)	Metric of the average time, in seconds, users take to answer the set of prompts in all report jobs.
RP Average Queue Duration per Job (hh:mm:ss) (IS_REP_FACT)	Metric of the average time report jobs waited in the Intelligence Server's queue before the report job was executed.
RP Average Queue Duration per Job (secs) (IS_REP_FACT)	Metric of the average time, in seconds, report jobs waited in the Intelligence Server's queue before the report job was executed.
RP Elapsed Duration (hh:mm:ss)	Metric of the difference between start time and finish time of a report job. Includes time for prompt responses, in queue, and execution.
RP Elapsed Duration (secs)	Metric of the difference, in seconds, between start time and finish time of a report job. Includes time for prompt responses, in queue, and execution.
RP Execution Duration (hh:mm:ss)	Metric of the duration of a report job's execution. Includes database execution time.
RP Execution Duration (secs)	Metric of the duration, in seconds, of a report job's execution. Includes database execution time.
RP Number of Ad Hoc Jobs	Metric of how many report jobs resulted from an ad hoc report creation.
RP Number of Cancelled Jobs	Metric of how many job executions were canceled.
RP Number of Drill Jobs	Metric of how many job executions resulted from a drill action.
RP Number of Jobs (IS_REP_FACT)	Metric of how many report jobs were executed.
RP Number of Jobs hitting Database	Metric of how many report jobs were executed against the database.
RP Number of Jobs w/o Cache Creation	Metric of how many report jobs were executed that did not result in creating a server cache.
RP Number of Jobs w/o Cache Hit	Metric of how many report jobs were executed that did not hit a server cache.
RP Number of Jobs w/o Element Loading	Metric of how many report jobs were executed that did not result from loading additional attribute elements.
RP Number of Jobs with Cache Creation	Metric of how many report jobs were executed that resulted in a server cache being created.
RP Number of Jobs with Cache Hit	Metric of how many report jobs were executed that hit a server cache.
RP Number of Jobs with Datamart Creation	Metric of how many report jobs were executed that resulted in a data mart being created.
RP Number of Jobs with DB Error	Metric of how many report jobs failed because of a database error.
RP Number of Jobs with Element Loading	Metric of how many report jobs were executed that resulted from loading additional attribute elements.
RP Number of Jobs with Error	Metric of how many report jobs failed because of an error.
RP Number of Jobs with Intelligent Cube Hit	Metric of how many report job executions used an Intelligent Cube.
RP Number of Jobs with Security Filter	Metric of how many report job executions used a security filter.
RP Number of Jobs with SQL Execution	Metric of how many report jobs executed SQL statements.
RP number of Narrowcast Server jobs	Metric of how many report job executions were run through MicroStrategy Narrowcast Server.
RP Number of Prompted Jobs	Metric of how many report job executions included a prompt.
RP Number of Report Jobs from Document Execution	Metric of how many report jobs executed as a result of a document execution.
RP Number of Result Rows	Metric of how many result rows were returned from a report execution.
RP Number of Scheduled Jobs	Metric of how many report jobs were scheduled.
RP Number of Users who ran reports	Metric of how many distinct users ran report jobs.
RP Prompt Answer Duration (hh:mm:ss)	Metric of the how long users take to answer the set of prompts in report jobs.
RP Prompt Answer Duration (secs)	Metric of the how long, in seconds, users take to answer the set of prompts in report jobs.
RP Queue Duration (hh:mm:ss)	Metric of how long a report job waited in the Intelligence Server's queue before the report job was executed.
RP Queue Duration (secs)	Metric of how long, in seconds, a report job waited in the Intelligence Server's queue before the report job was executed.
Schedule	Indicates the schedule that began the report execution.
Schedule Indicator	Indicates whether the report execution was scheduled.
Security Filter	Indicates the security filter used in the report execution.
Security Filter Indicator	Indicates whether a security filter was used in the report execution.
SQL Execution Indicator	Indicates that SQL was executed during report execution.
Template	Indicates the report template that was used.
User	Indicates the user that ran the report.

Report Job SQL Pass Attributes and Metrics

Attribute or metric name	Function
Ad Hoc Indicator	Indicates whether the execution was ad hoc.
Connection Source	Indicates the connection source to Intelligence Server.
Day	Indicates the day in which the job was executed.
Hour	Indicates the hour in which the report job was executed.
Metadata	Indicates the metadata repository storing the report or document.
Minute	Indicates the minute in which the report job was started.
Project	Indicates the project storing the report or document.
Report	Indicates the report that was executed.
Report Job	Indicates an execution of a report.
Report Job SQL Pass	Indicates the SQL statement that was executed during the SQL pass.
Report Job SQL Pass Type	Indicates the type of SQL statement that was executed in this SQL pass. Examples are SQL select, SQL insert, SQL create and such.
RP Execution Duration (hh:mm:ss)	Metric of the duration of a report job's execution. Includes database execution time.
RP Execution Duration (secs)	Metric of the duration, in seconds, of a report job's execution. Includes database execution time.
RP Last Execution Finish Timestamp	Metric of the finish timestamp when the report job was last executed.
RP Last Execution Start Timestamp	Metric of the start timestamp when the report job was last executed.
RP Number of DB Tables Accessed	Metric of how many database tables were accessed in a report job execution.
RP SQL Size	Metric of how large, in bytes, the SQL was for a report job.

Report Job Steps Attributes and Metrics

Attribute or metric name	Function
Ad Hoc Indicator	Indicates whether an execution was ad hoc.
Cache Hit Indicator	Indicates whether an execution has hit a cache.
Connection Source	Indicates the connection source to Intelligence Server.
Cube Hit Indicator	Indicates whether an execution hit an intelligent cube or database.
Day	Indicates the day in which the job was executed.
Hour	Indicates the hour in which the report job was executed.
Minute	Indicates the minute in which the report job was started.
Report	Indicates the report that was executed.
Report Job	Indicates an execution of a report.
Report Job Step Sequence	Indicates the sequence number in the series of execution steps a report job passes through in the Intelligence Server.
Report Job Step Type	Indicates the type of step for a report job. Examples are SQL generation, SQL execution, Analytical Engine, Resolution Server, element request, update Intelligent Cube, and so on.
RP Average CPU Execution Duration per Job (msecs) (IS_REP_STEP_FACT)	Metric of the average duration, in milliseconds, a report job execution takes in the Intelligence Server CPU.
RP Average Elapsed Duration per Job (secs) (IS_REP_STEP_FACT)	Metric of the average difference, in seconds, between start time and finish time of report job executions. Includes time for prompt responses.
RP Average Execution Duration per Job (secs) (IS_REP_STEP_FACT)	Metric of the average difference, in seconds, between start time and finish time of report job executions. Includes time for prompt responses.
RP Average Query Engine Execution Duration per Job (secs) (IS_REP_STEP_FACT)	Metric of the average time, in seconds, the Query Engine takes to process a report job.
RP Average Queue Duration per Job (secs) (IS_REP_STEP_FACT)	Metric of the average time report jobs waited in the Intelligence Server's queue before the report job was executed.
RP CPU Duration (msec)	Metric of how long, in milliseconds, a report job execution takes in the Intelligence Server CPU.
RP Elapsed Duration (hh:mm:ss)	Metric of the difference between start time and finish time of report job executions. Includes time for prompt responses.
RP Elapsed Duration (secs)	Metric of the difference, in seconds, between start time and finish time of report job executions. Includes time for prompt responses.
RP Execution Duration (hh:mm:ss)	Metric of the difference between start time and finish time of report job executions. Includes database execution time.
RP Execution Duration (secs)	Metric of the difference, in seconds, between start time and finish time of report job executions. Includes database execution time.
RP Last Execution Finish Timestamp	Metric of the finish timestamp when the report job was last executed.
RP Last Execution Start Timestamp	Metric of the start timestamp when the report job was last executed.
RP Number of Jobs (IS_REP_STEP_FACT)	Metric of how many report jobs were executed.
RP Query Engine Duration (hh:mm:ss) (IS_REP_STEP_FACT)	Metric of how long the Query Engine took to execute SQL for a report job.
RP Query Engine Duration (secs) (IS_REP_STEP_FACT)	Metric of the time, in seconds, the Query Engine takes to execute SQL for a report job.
RP Queue Duration (hh:mm:ss)	Metric of how long a report job waited in the Intelligence Server's queue before the report job was executed.
RP Queue Duration (secs)	Metric of how long, in seconds, a report job waited in the Intelligence Server's queue before the report job was executed.
RP SQL Engine Duration (hh:mm:ss) (IS_REP_STEP_FACT)	Metric of how long the SQL Engine took to generate SQL for a report job.

Report Job Tables/Columns Accessed Attributes and Metrics

Attribute or metric name	Function
Ad Hoc Indicator	Indicates whether an execution was ad hoc.
Column	Indicates the column that was accessed.
Connection Source	Indicates the connection source to Intelligence Server.
Day	Indicates the day on which the table column was accessed.
DB Table	Indicates the table in the database storing the column that was accessed.
Hour	Indicates the hour on which the table column was accessed.
Minute	Indicates the minute on which the table column was accessed.
Report	Indicates the report that accessed the table column.
Report Job	Indicates which execution of a report accessed the table column.
RP Number of Jobs (IS_REP_COL_FACT)	Metric of how many report jobs accessed the database column or table. The Warehouse Tables Accessed report uses this metric.
SQL Clause Type	Indicates which type of SQL clause was used to access the table column.

Schema Objects Attributes

Attribute name	Function
Attribute	Lists all attributes in projects that are set up to be monitored by Enterprise Manager.
Attribute Form	Lists all attribute forms in projects that are set up to be monitored by Enterprise Manager.
Column	Lists all columns in projects that are set up to be monitored by Enterprise Manager.
DB Table	Lists all physical tables in the data warehouse that are set up to be monitored by Enterprise Manager.
Fact	Lists all facts in projects that are set up to be monitored by Enterprise Manager.
Hierarchy	Lists all hierarchies in projects that are set up to be monitored by Enterprise Manager
Table	Lists all logical tables in projects that are set up to be monitored by Enterprise Manager.
Transformation	Lists all transformations in projects that are set up to be monitored by Enterprise Manager.

Server Machines Attributes

Attribute name	Function
Client Machine	Lists all machines that have had users connect to the Intelligence Server.
Intelligence Server Cluster	Lists the cluster of Intelligence Servers.
Intelligence Server Machine	Lists all machines that have logged statistics as an Intelligence Server.
Web Server Machine	Lists all machines used as web servers.

Session Attributes and Metrics

Attribute or metric name	Function
Avg. Connection Duration (hh:mm:ss)	Metric of the average time connections to an Intelligence Server last.
Avg. Connection Duration (secs)	Metric of the average time, in seconds, connections to an Intelligence Server last.
Connection Duration (hh:mm:ss)	Metric of the time a connection to an Intelligence Server lasts.
Connection Duration (secs)	Metric of the time, in seconds, a connection to an Intelligence Server lasts.
Connection Source	Lists all connection sources to Intelligence Server.
Number of Sessions (Report Level)	Metric of how many sessions were connected to an Intelligence Server. Usually reported with a date and time attribute.
Number of Users Logged In (Report Level)	Metric of how many distinct users were connected to an Intelligence Server. Usually reported with a date and time attribute.
Session	Indicates a user connection to an Intelligence Server.