MicroStrategy ONE
Fact Tables
- CT_EXEC_FACT
- CT_MANIP_FACT
- IS_CONFIG_PARAM_FACT
- IS_CUBE_ACTION_FACT
- IS_DOC_FACT
- IS_DOC_STEP_FACT
- IS_INBOX_ACT_FACT
- IS_MESSAGE_FACT
- IS_PERF_MON_FACT
- IS_PR_ANS_FACT
- IS_PROJECT_FACT_1
- IS_REP_COL_FACT
- IS_REP_FACT
- IS_REP_SEC_FACT
- IS_REP_SQL_FACT
- IS_REP_STEP_FACT
- IS_SESSION_FACT
- IS_SESSION_MONITOR
CT_EXEC_FACT
Contains information about MicroStrategy Mobile devices and report/document executions and manipulations. Created as a view based on columns in the source tables listed below.
Source Tables
- CT_DEVICE_STATS: Statistics table containing information about the mobile client and the mobile device
- CT_EXEC_STATS: Statistics table containing information about mobile report and document execution
- IS_SERVER: Lookup table that provides descriptive information about the server definitions being tracked
- IS_REP: Lookup table that provides descriptive information about the reports being tracked
- IS_DOC: Lookup table that provides descriptive information about the documents being tracked
- IS_PROJ: Lookup table that provides descriptive information about the projects being tracked
- EM_MD: Lookup table for metadata
- EM_USER: Lookup table for users
List of Table Columns
| Column Name | Column Description |
|
CT_DEVICE_INST_ID |
Unique installation ID of the mobile app. |
|
CT_STATE_COUNTER |
An integer value that increments when the device information, such as DEVICETYPE, OS, OSVER, or APPVER (in CT_DEVICE_STATS), changes. |
|
CT_STATE_CHANGE_TS |
Date and time when STATECOUNTER is incremented. |
|
CT_DEVICE_TYPE |
Type of device the app is installed on, such as iPad 2, Droid, or iPhone 6. |
|
CT_OS |
Operating system the app is installed on, such as iOS or Android. |
|
CT_OS_VER |
Version of the operating system, such as 5.2.1. |
|
CT_APP_VER |
Version of the MicroStrategy app. |
|
EM_USER_ID |
ID of the user executing the document. |
|
IS_SESSION_ID |
GUID of the session that executed the request. This should be the same as the SESSIONID for this request in IS_REP_FACT. |
|
CT_SESSION_ID |
GUID of the MicroStrategy Mobile client session ID. A new client session ID is generated every time a user logs in to the mobile app. |
|
IS_MESSAGE_ID |
ID corresponding to the JOBID (in IS_REP_FACT) of the message generated by the execution. |
|
CT_ACTION_ID |
Similar to JOBID but generated by the client and cannot be NULL. JOBID may be NULL if the user is offline during execution. |
|
IS_SERVER_ID |
GUID of the Intelligence Server processing the request. |
|
EM_APP_SRV_MACHINE |
Name and port number of the Intelligence Server machine where the mobile document execution is taking place. |
|
IS_REP_ID |
GUID of the report used in the request. |
|
IS_DOC_ID |
GUID of the document used in the request. |
|
IS_PROJ_ID |
GUID of the project. |
|
IS_REPOSITORY_ID |
GUID of the metadata repository. |
|
EM_MOB_SRV_MACHINE |
Name and port number of the Mobile Server machine where the mobile document execution is taking place. |
|
CT_REQ_TS |
Time when the user submits a request to the mobile app. |
|
CT_REC_TS |
Time when the mobile app begins receiving data from MicroStrategy Mobile Server. |
|
CT_REQ_REC_TM_MS |
Difference in milliseconds between CT_REQ_TS and CT_REC_TS. |
|
CT_RENDER_ST_TS |
Time when the mobile app begins rendering. |
|
CT_RENDER_FN_TS |
Time when the mobile app finishes rendering. |
|
CT_RENDER_TM_MS |
Difference in milliseconds between CT_RENDER_ST_TS and CT_RENDER_FN_TS |
|
CT_EXEC_TYPE_IND_ID |
Type of report or document execution: 1: User execution 2: Pre-cached execution 3: System recovery execution 4: Subscription cache pre-loading execution 5: Transaction subsequent action execution 6: Report queue execution 7: Report queue recall execution 8: Back button execution |
|
CT_CACHE_HIT_IND_ID |
Whether a cache was hit during the execution, and if so, what type of cache hit occurred: 0: No cache hit 1: Intelligence Server cache hit 2: Device cache hit 6: Application memory cache hit |
|
CT_PROMPT_IND_ID |
Whether the report or document is prompted: 0: Not prompted 1: Prompted |
|
CT_DATATYPE_ID |
Whether the job is for a report or a document: 3: Report 55: Document |
|
CT_NETWORK_TYPE |
The type of network used: 3G WiFi LTE 4G |
|
CT_BANDWIDTH_KBPS |
Estimated network bandwidth, in kbps. |
|
CT_VIEW_FN_TS |
Time at which the user either clicks on another report or document, or backgrounds the mobile app. |
|
CT_VIEW_TM_MS |
Difference in milliseconds between CT_RENDER_FN_TS and CT_VIEW_FN_TS. |
|
CT_NU_OF_MANIP |
An integer value that increases with every manipulation the user makes after the report or document is rendered, excluding those that require fetching more data from Intelligence Server or that result in another report or document execution. |
|
CT_AVG_MANIP_RENDER_TM_MS |
Average rendering time for each manipulation. |
|
CT_LATITUDE |
Latitude of the user. |
|
CT_LONGITUDE |
Longitude of the user. |
|
DAY_ID |
Day the action was started. |
|
CT_TIMESTAMP |
Time the manipulation was started. |
|
HOUR_ID |
Hour the action was started. |
|
MINUTE_ID |
Minute the action was started. |
|
EM_RECORD_TS |
Date and time when this information was written to the statistics database. |
|
CT_REQ_RECEIVED_FLAG |
Whether the manipulation request was received. |
|
CT_REQ_RENDERED_FLAG |
Whether the manipulation was completed. |
|
CT_REQ_HAS_DEVICE_FLAG |
Whether the manipulation request was made by a mobile app. |
|
CT_JOB_ID |
The ID of the job requesting the manipulation. A combination of the IS_SESSION_ID, CT_SESSION_ID, and CT_ACTION_ID. |
|
IS_DOC_NAME |
Name of the document used in the request, or if it is a deleted document. |
|
IS_PROJ_NAME |
Name of the project used for the request or if it is a deleted project. |
|
EM_USER_NAME |
Name of the user who made the request or if it is a deleted user. |
|
EM_LDAPLINK |
Name of the user in the LDAP system or if it is a deleted user. |
|
EM_NTLINK |
Name of the user in Windows or if it is a deleted user. |
CT_MANIP_FACT
Contains information about MicroStrategy Mobile devices and report/document manipulations. Created as a view based on columns in the source tables listed below.
Source Tables
- CT_MANIP_STATS: Statistics table containing information about the report or document manipulations
- EM_MD: Lookup table for metadata
- IS_PROJ: Lookup table that provides descriptive information about the projects being tracked
- IS_DOC: Lookup table that provides descriptive information about the documents being tracked
- IS_REP: Lookup table that provides descriptive information about the reports being tracked
- EM_USER: Lookup table for users
List of Table Columns
| Column Name | Column Description |
|
CT_JOB_ID |
The ID of the job requesting the manipulation. A combination of the IS_SESSION_ID, CT_SESSION_ID, and CT_ACTION_ID. |
|
CT_DEVICE_INST_ID |
Unique installation ID of the mobile app. |
|
CT_STATE_COUNTER |
An integer value that increments when the device information, such as DEVICETYPE, OS, OSVER, or APPVER (in CT_MANIP_STATS), changes. |
|
EM_USER_ID |
ID of the user making the request. |
|
IS_SESSION_ID |
GUID of the session that executed the request. |
|
CT_SESSION_ID |
GUID of the MicroStrategy Mobile client session ID. A new client session ID is generated every time a user logs in to the mobile app. |
|
CT_ACTION_ID |
Similar to JOBID but generated by the client and cannot be NULL. JOBID may be NULL if the user is offline during execution. |
|
EM_APP_SRV_MACHINE |
Name and port number of the Intelligence Server machine where the manipulation is taking place. |
|
IS_REP_ID |
GUID of the report used in the request. |
|
IS_DOC_ID |
Integer ID of the document that was executed. |
|
IS_PROJ_ID |
Integer ID of the project. |
|
IS_MANIP_SEQ_ID |
The order in which the manipulations were made in a session. For each manipulation, the mobile client returns a row, and the value in this column increments for each row. |
|
IS_MANIP_TYPE_ID |
Type of manipulation: 0: Unknown 1: Selector 2: Panel Selector 3: Action Selector 4: Change Layout 5: Change View 6: Sort 7: Page By |
|
IS_MANIP_NAME |
Name of the item that was manipulated. For example, if a selector was clicked, this is the name of the selector. |
|
IS_MANIP_VALUE |
Value of the item that was manipulated. For example, if a panel selector was clicked, this is the name of the selected panel. |
|
IS_MANIP_VALUE_SEQ |
If the value for IS_MANIP_VALUE is too long to fit in one row, this manipulation is spread over multiple rows, and this value is incremented. |
|
DETAIL1 |
A flexible column to capture different states of manipulation. |
|
DETAILS2 |
A flexible column to capture different states of manipulation. |
|
CT_MANIP_ST_TS |
Time when the user submitted the manipulation. |
|
CT_MANIP_FN_TS |
Time when the mobile app finished processing the manipulation and forwarded it for rendering. |
|
CT_MANIP_TM_MS |
Difference between CT_MANIP_ST_TS and CT_MANIP_FN_TS, in milliseconds. |
|
DAY_ID |
Day the manipulation was started. |
|
HOUR_ID |
Hour the manipulation was started. |
|
MINUTE_ID |
Minute the manipulation was started. |
|
EM_RECORD_TS |
Date and time when this information was written to the statistics database. |
|
REP_ID |
ID of the report used in the request. |
IS_CONFIG_PARAM_FACT
Contains information about Intelligence Server and project configuration settings.
Related Lookup Tables
- IS_CONFIG_PARAM: Lookup table for configuration settings
- IS_PROJ: Lookup table for projects
- IS_SERVER: Lookup table for Intelligence Server definitions
List of Table Columns
| Column Name | Column Description |
|
IS_CONFIG_TS |
Timestamp when the configuration setting was recorded. |
|
IS_MD_ID |
Integer ID of the metadata being monitored. |
|
IS_PROJ_ID |
ID of the project recording the configuration setting. If the configuration setting is an Intelligence Server setting, this value is 0. |
|
IS_SERVER_ID |
Integer ID of the Intelligence Server definition. |
|
IS_CONFIG_PARAM_ID |
Integer ID the configuration setting. |
|
IS_CONFIG_PARAM_VALUE |
Value of the configuration setting. |
IS_CUBE_ACTION_FACT
Contains information about Intelligent Cube manipulations. Created as a view based on columns in the source tables listed below.
Source Tables
- EM_MD: Lookup table for metadata
- IS_CUBE_REP_STATS: Statistics table containing information about Intelligent Cube manipulations
- IS_CUBE_ACTION_TYPE: Lookup table listing the manipulations that can occur
- IS_PROJ: Lookup table for projects
- IS_REP: Lookup table for report objects
List of Table Columns
| Column Name | Column Description |
|
DAY_ID |
Day the action was started. |
|
HOUR_ID |
Hour the action was started. |
|
MINUTE_ID |
Minute the action was started. |
|
EM_RECORD_TS |
Date and time when this information was written to the statistics database. |
|
IS_SESSION_ID |
GUID of the session that started the action against the Intelligent Cube. |
|
IS_REP_JOB_ID |
Job ID for the action on the Intelligent Cube |
|
IS_PROJ_ID |
Integer ID of the project where the Intelligent Cube is stored. |
|
IS_CUBE_REP_ID |
Integer ID of the Intelligent Cube report that was published, if any |
|
IS_CUBE_INST_ID |
GUID of the Intelligent Cube instance in memory |
|
IS_CUBE_ACT_ID |
Type of action against the Intelligent Cube: 0: Reserved for MicroStrategy use 1: Cube Publish 2: Cube View Hit 3: Cube Dynamic Source Hit 4: Cube Append 5: Cube Update 6: Cube Delete 7: Cube Destroy |
|
IS_REP_ID |
Integer ID of the report that hit the Intelligent Cube, if any. |
|
IS_CUBE_SIZE_KB |
If the Intelligent Cube is published or refreshed, size of the Intelligent Cube in KB. |
|
IS_CUBE_ROWS |
If the Intelligent Cube is published or refreshed, number of rows in the Intelligent Cube. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_DOC_FACT
Contains information on the execution of a document job.
Primary key:
- DAY_ID2
- IS_SESSION_ID
- IS_DOC_JOB_SES_ID
- IS_DOC_JOB_ID
- IS_DOC_CACHE_IDX
Source Tables
- IS_DOCUMENT_STATS: Statistics table containing information about document executions
- EM_IS_LAST_UPD_2: Configuration table that drives the loading process (for example, data loading window)
Related Lookup Tables
- EM_USER: Lookup table for users
- IS_DOC: Lookup table for documents
- IS_SESSION: Lookup table for session objects
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp of when the information was recorded by Intelligence Server into the IS_DOCUMENT_STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
IS_SERVER_ID |
Integer ID of the server where the session was created. |
|
IS_SESSION_ID |
GUID of the current session object. |
|
IS_DOC_JOB_SES_ID |
GUID of the session that created the cache if a cache was hit in this execution; otherwise, current session (default behavior). |
|
IS_DOC_JOB_ID |
Integer ID of the document job execution. |
|
IS_DOC_CACHE_IDX |
Always 0; not yet available, documents not currently cached. Integer ID of the cache hit index; similar to Job ID but only for cache hits. -1 if no cache hit. |
|
IS_CACHE_HIT_ID |
Always 0; not yet available, documents not currently cached. Indicates whether the job hit a cache. |
|
IS_CACHE_CREATE_ID |
Always 0, not yet available. Indicates whether a cache was created. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_CUBE_EXEC_ST_TS |
Date and time when cube execution was started by Intelligence Server. |
|
IS_CUBE_EXEC_FN_TS |
Date and time when cube execution was finished by Intelligence Server. |
|
EM_USER_ID |
Integer ID of the user who created the session. |
|
IS_DOC_ID |
Integer ID of the document that was executed. |
|
IS_DOC_REQ_TS |
Timestamp of the execution request; request of the current session. |
|
IS_DOC_EXEC_REQ_TS |
Timestamp of the execution request; request time of the original execution request if a cache was hit, otherwise current session's request time. |
|
IS_DOC_EXEC_ST_TS |
Timestamp of the execution start. |
|
IS_DOC_EXEC_FN_TS |
Timestamp of the execution finish. |
| IS_EXPORT_INDIC |
Integer ID indicating if this was an export job or not. |
|
IS_DOC_QU_TM_MS |
Queue duration in milliseconds. |
|
IS_DOC_CPU_TM_MS |
CPU duration in milliseconds. |
|
IS_DOC_EXEC_TM_MS |
Execution duration in milliseconds. |
|
IS_DOC_NBR_REPORTS |
Number of reports contained in the document job execution. |
|
IS_DOC_NBR_PU_STPS |
Number of steps processed in the document job execution. |
|
IS_DOC_NBR_PROMPTS |
Number of prompts in the document job execution. |
|
IS_JOB_ERROR_ID |
Integer ID of the job's error message, if any. |
|
IS_CANCELLED_ID |
Indicates whether the job was cancelled. |
|
DAY_ID2 |
Integer ID of the day. Format YYYYMMDD. |
|
HOUR_ID |
Integer ID of the hour. Format HH (24 hours). |
|
MINUTE_ID2 |
Integer ID of the minute. Format HHMM (24 hours) |
|
DAY_ID |
This column is deprecated. |
|
MINUTE_ID |
This column is deprecated. |
IS_DOC_STEP_FACT
Contains information on each processing step of a document execution. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_DOC_STEP_STATS: Statistics table containing information about processing steps of document execution
- IS_PROJ: Lookup table for projects
- IS_DOCUMENT_STATS: Statistics table containing information about document executions
- IS_SESSION: Lookup table for session objects
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp of when the information was recorded by Intelligence Server into the _STATS tables. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_DOC_JOB_SES_ID |
GUID of the session that created the cache if a cache was hit in this execution; otherwise, current session (default behavior). |
|
IS_DOC_JOB_ID |
Integer ID of the document job execution. |
|
IS_DOC_STEP_SEQ_ID |
Integer ID of the document job execution step. |
|
IS_DOC_STEP_TYP_ID |
Integer ID of the document job execution step type. |
|
IS_DOC_EXEC_ST_TS |
Timestamp of the execution start. |
|
IS_DOC_EXEC_FN_TS |
Timestamp of the execution finish. |
|
IS_DOC_QU_TM_MS |
Queue duration in milliseconds. |
|
IS_DOC_CPU_TM_MS |
CPU duration in milliseconds. |
|
IS_DOC_EXEC_TM_MS |
Execution duration in milliseconds. |
|
DAY_ID |
Day the job was executed. |
|
HOUR_ID |
Hour the job was executed. |
|
MINUTE_ID |
Minute the job was executed. |
IS_INBOX_ACT_FACT
Contains information about History List manipulations. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_INBOX_ACT_STATS: Statistics table containing information about History List manipulations
- IS_INBOX_ACTION: Lookup table listing the manipulations that can occur
List of Table Columns
| Column Name | Column Description |
|
DAY_ID |
Day the manipulation was started. |
|
HOUR_ID |
Hour the manipulation was started. |
|
MINUTE_ID |
Minute the manipulation was started. |
|
IS_SESSION_ID |
GUID of the session that started the History List manipulation. |
|
IS_SERVER_ID |
GUID of the server definition of the Intelligence Server being manipulated. |
|
EM_APP_SRV_MACHINE |
Name and port number of the Intelligence Server machine where the manipulation is taking place. |
|
IS_PROJ_ID |
GUID of the project where the History List message is mapped. |
|
IS_INBOX_ACTION_ID |
Type of manipulation: 0: Reserved for MicroStrategy use. 1: Add: Add message to History List 2: Remove: Remove message from History List 3: Rename: Rename message 4: Execute: Execute contents of message 5: Change Status: Change message status from Ready to Read 6: Requested: Retrieve message contents 7: Batch Remove: Intelligence Server bulk operation, such as cache expiration |
|
EM_USER_ID |
ID of the user doing the manipulation. |
|
IS_HL_MESSAGE_ID |
GUID of the History List message being acted on. |
|
IS_HL_MESSAGE_TITLE |
Name of the report or document referenced in the History List message. |
|
IS_HL_MESSAGE_DISP |
User-defined name of the History List message. Blank unless the user has renamed the History List message. |
|
IS_CREATION_TS |
Date and time when the History List message was created. |
|
IS_ACT_START_TS |
Date and time when the manipulation started. |
|
IS_REP_JOB_ID |
Report job ID for the History List Message Content Request. Blank if no job was executed or if a document was executed. |
|
IS_DOC_JOB_ID |
Document job ID for the History List Message Content Request. Blank if no job was executed or if a report was executed. |
|
IS_SUBSCRIPTION_ID |
ID of the subscription that invoked the manipulation |
|
IS_ACTION_COMMENT |
If the manipulation is a batch deletion of History List messages, this field contains the condition or SQL statement used to delete the messages. If there is an error, this field holds the error message. |
|
EM_RECORD_TS |
Date and time when this information was written to the statistics database. |
IS_MESSAGE_FACT
Records all messages sent through Distribution Services.
Source Table
- IS_MESSAGE_STATS: Statistics table containing information about sent messages
Related Lookup Tables
- IS_SCHED: Lookup table for schedules
- IS_PROJ: Lookup table for projects
- IS_SERVER: Lookup table for Intelligence Server definitions
- IS_DEVICE: Lookup table for devices
- EM_MD: Lookup table for metadata
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp of when information was recorded by Intelligence Server into the IS_MESSAGE_STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
IS_MESSAGE_INDEX |
Reserved for MicroStrategy use. |
|
IS_SESSION_ID |
GUID of the session object. |
|
DAY_ID |
Integer ID of the day. Format: YYYYMMDD. |
|
HOUR_ID |
Integer ID of the hour. Format HH (24 hours). |
|
MINUTE_ID |
Integer ID of the minute. |
|
IS_HL_MESSAGE_ID |
Message ID of the job created. |
|
IS_SCHEDULE_JOB_ID |
Job ID from Intelligence Server for the subscription job. |
|
IS_DATATYPE_ID |
Type of data generated for the subscription. 3: Report 55: Document |
|
IS_RCPT_CONTACT_ID |
GUID of the user who is receiving the data. |
|
IS_DELIVERY_TYPE_ID |
Type of delivery: 1: Email 2: File 4: Printer 8: Custom 16: History List 20: Client 40: Cache 100: (MicroStrategy use only) 128: Mobile 255: (MicroStrategy use only) |
|
IS_SUBS_INST_ID |
GUID of the subscription. |
|
IS_SUBS_INST_NAME |
Name of the subscription. |
|
IS_SCHEDULE_ID |
GUID of the schedule that triggered the subscription, or -1 if not applicable. |
|
IS_DATA_ID |
GUID of the report or document requested. |
|
IS_CONTACT_TYPE_ID |
Type of contact delivered to: 1: Contact 2: Contact group 4: MicroStrategy user 5: Count 8: MicroStrategy user group 10: LDAP user 31: (MicroStrategy use only) |
|
IS_RCPT_GROUP_ID |
GUID of the group receiving the subscription, or NULL if no group. |
|
IS_RCPT_CONTACT_NAME |
Name of the contact recipient. |
|
IS_DFLT_ADDR |
Indicates whether the address where the content was delivered is the default. |
|
IS_ADDRESS_ID |
GUID of the address delivered to. |
|
IS_DEVICE_ID |
ID of the Distribution Services device used in the delivery. |
|
IS_NOTIF_MSG |
Indicates whether a delivery notification message is sent. |
|
IS_NOTIF_ADDR |
GUID of the notification address. |
|
IS_SERVER_ID |
Numeric ID of the server definition. |
|
IS_PROJ_ID |
Numeric ID of the source project. |
|
IS_EXEC_ST_TM_TS |
Start time for subscription execution. |
|
IS_EXEC_FM_TM_TS |
Finish time for subscription execution. |
|
IS_DELIVERY_STATUS |
Indicates whether the delivery was successful. |
|
IS_PHYSICAL_ADD |
Physical address for delivery. |
|
IS_BATCH_ID |
Reserved for MicroStrategy use. |
|
EM_APP_SRV_MACHINE |
Name of the Intelligence Server. |
IS_PERF_MON_FACT
Contains information about job performance .
Source Table
- IS_PERF_MON_STATS: Statistics table containing information about job performance
Related Lookup Table
- IS_PROJ: Lookup table for projects
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp of when the information was recorded by Intelligence Server into the _STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
EM_APP_SRV_MACHINE |
The name of the Intelligence Server machine logging the statistics. |
|
IS_COUNTER_CAT |
The category of the counter, such as Memory, MicroStrategy Server Jobs, or MicroStrategy Server Users. |
|
IS_COUNTER_INSTANCE |
MicroStrategy use. |
|
IS_COUNTER_NAME |
The name of the performance counter. |
|
IS_EVENT_TIME |
Timestamp of when the event occurred in Intelligence Server. |
|
IS_COUNTER_VALUE |
The value of the performance counter. |
|
IS_CTR_VAL_TYP |
The type of performance counter. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
DAY_ID |
Integer ID of the day. Format YYYMMDD. |
|
HOUR_ID |
Integer ID of the hour. Format HH (24 hours). |
|
MINUTE_ID |
Integer ID of the minute. |
IS_PR_ANS_FACT
Contains information about prompt answers. Created as a view based on columns in the source tables listed below.
Source Tables
- EM_MD: Lookup table for metadata
- EM_PR_ANS_TYPE: Lookup table for prompt answer type
- IS_PR_ANS_STATS: Statistics table containing information about session activity
- IS_PROJ: Lookup table for projects
- IS_PROMPT: Lookup table for prompts
- IS_SERVER: Lookup table for Intelligence Server definitions
- LU_OBJ_TYPE: Lookup table for COM object type
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
IS_REP_JOB_ID |
Job ID assigned by the server. |
|
IS_SESSION_ID |
GUID for the user session. |
|
PR_ORDER_ID |
Order in which prompts were answered. |
|
PR_ANS_SEQ |
Sequence ID. For MicroStrategy use. |
|
PR_LOC_ID |
ID of the object that the prompt resides in. |
|
PR_LOC_TYPE |
COM object type of the object that the prompt resides in. |
|
PR_LOC_DESC |
Object name of the object that the prompt resides in. |
|
PR_ANS_GUID |
Reserved for MicroStrategy use. |
|
PR_ANSWERS |
Prompt answers. |
|
PR_ANS_TYPE |
Prompt answer type. |
|
IS_SERVER_ID |
Integer ID of the server where the session was created. |
|
PR_ID |
Integer ID of the prompt. |
|
PR_GUID |
GUID of the prompt. |
|
PR_TITLE |
Prompt title. |
|
PR_NAME |
Prompt name. |
|
IS_REQUIRED |
Y if a prompt answer is required, N if a prompt answer is not required. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_PROJ_NAME |
Project name. |
|
EM_APP_SRV_MACHINE |
The Intelligence Server machine name and IP address. |
|
DAY_ID |
Day the prompt was answered. |
|
HOUR_ID |
Hour the prompt was answered. |
|
MINUTE_ID |
Minute the prompt was answered. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_PROJECT_FACT_1
Represents the number of logins to a project in a day by user session and project.
Source Tables
- IS_PROJ_SESSION_STATS: Statistics table containing information on session activity by project
- IS_SESSION_STATS: Statistics table containing information about session activity on Intelligence Server
- IS_SERVER: Lookup table for Intelligence Server definitions
- EM_USER: Lookup table for users
- IS_PROJ: Lookup table for projects
List of Table Columns
| Column Name | Column Description |
|
IS_SESSION_ID |
GUID of the session object. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_SERVER_ID |
Integer ID of the server where the session was created. |
|
EM_APP_SRV_MACHINE |
The name of the Intelligence Server machine logging the statistics. |
|
EM_USER_ID |
Integer ID of the user who created the session. |
|
IS_CONNECT_TS |
Timestamp of the beginning of the session (login). |
|
IS_DISCONNECT_TS |
Timestamp of the end of the session (logout). NULL if the session is still open at the time of Enterprise Manager data load. |
|
IS_TMP_DISCON_TS |
Represents temporary end of a session, if that session is still open. Used to calculate the session time. |
|
IS_SESSION_TM_SEC |
Duration within the hour, in seconds, of the session. |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
DAY_ID |
Integer ID of the day. Format YYYMMDD. |
|
HOUR_ID |
Hour the user logged in. |
|
MINUTE_ID |
Minute the user logged in. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_REP_COL_FACT
Used to analyze which data warehouse tables and columns are accessed by MicroStrategy report jobs, by which SQL clause they are accessed (SELECT, FROM, and so on), and how frequently they are accessed. This fact table is at the level of a Report Job rather than at the level of each SQL pass executed to satisfy a report job request. The information available in this table can be useful for database tuning. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_REP_COL_STATS: Statistics table containing information about column-table combinations used in the SQL during report executions
- IS_SESSION: Lookup table for session objects
- IS_REP_FACT: Fact table for report job executions
- IS_DB_TAB: Lookup table for database tables
- IS_COL: Lookup table for columns
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when information was recorded by Intelligence Server into the _STATS tables. |
|
IS_JOB_ID |
Integer ID of the report job execution. |
|
IS_SESSION_ID |
GUID of the current session object. |
|
IS_COL_GUID |
GUID of the column object. |
|
IS_TABLE_ID |
Integer ID of the physical database table that was used. |
|
IS_COL_NAME |
Name of the column in the database table that was used. |
|
SQL_CLAUSE_TYPE_ID |
Integer ID of the type of SQL clause (SELECT, FROM, WHERE, and so on). |
|
COUNTER |
The number of times a specific column/table/clause type combination occurs within a report execution. |
|
DAY_ID |
Day the job was executed. |
|
HOUR_ID |
Hour the job was executed. |
|
MINUTE_ID |
Minute the job was executed. |
IS_REP_FACT
Contains information about report job executions.
Primary key:
- DAY_ID2
- IS_SESSION_ID
- IS_REP_JOB_SES_ID
- IS_REP_JOB_ID
- IS_DOC_JOB_ID
- IS_REP_CACHE_IDX
Source Tables
- IS_CACHE_HIT_STATS: Statistics table containing information about job executions that hit a cache
- IS_DOC_FACT: Fact table containing information about document job executions
- IS_DOCUMENT_STATS: Statistics table containing information about document job executions
- IS_REP_SEC_STATS: Statistics table containing information about job executions with security filters
- IS_REPORT_STATS: Statistics table containing information about report job executions
- IS_SCHEDULE_STATS: Statistics table containing information about job executions run by a schedule
- EM_IS_LAST_UPD_2: Configuration table that drives the loading process (for example, data loading window)
Related Lookup Tables
- IS_SESSION: Lookup table for session objects
- IS_REP: Lookup table for report objects
- IS_TEMP: Lookup table for template objects
- IS_FILT: Lookup table for filter objects
- IS_SCHED: Lookup table for schedule objects
- IS_DOC: Lookup table for document objects
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
IS_SERVER_ID |
Integer ID of the server where the session was created. |
|
IS_SESSION_ID |
GUID of the current session object. |
|
IS_REP_JOB_SES_ID |
GUID of the session that created the cache if a cache was hit in this execution; otherwise, current session (default behavior). |
|
IS_REP_JOB_ID |
Integer ID of the report job execution. |
|
IS_REP_CACHE_IDX |
Integer ID of the cache hit index; similar to Job ID but only for cache hits. -1 if no cache hit. |
|
IS_CACHE_HIT_ID |
Indicates whether the job hit a cache. |
|
IS_CACHE_CREATE_ID |
Indicates whether a cache was created. |
|
EM_USER_ID |
Integer ID of the user who created the session. |
|
EM_DB_USER_ID |
DB User used to log in to the warehouse. |
|
IS_DB_INST_ID |
Integer ID of the db instance object. |
|
IS_PROJ_ID |
Integer ID of the project logged in to. |
|
IS_REP_ID |
Integer ID of the report object. |
|
IS_EMB_FILT_IND_ID |
Indicates whether the report filter is embedded. |
|
IS_EMB_TEMP_IND_ID |
Indicates whether the report template is embedded. |
|
IS_FILT_ID |
Integer ID of the filter object. |
|
IS_TEMP_ID |
Integer ID of the template object. |
|
IS_DOC_JOB_ID |
Integer ID of the parent document execution if current report is a child of a document. Integer ID of the parent document execution of the original report if a cache was hit. Otherwise, -1. |
|
IS_DOC_ID |
Integer ID of the parent document object if current report is a child of a document. Otherwise, -1. |
|
IS_REP_REQ_TS |
Timestamp of the execution request; request of the current session. |
|
IS_REP_EXEC_REQ_TS |
Timestamp of the execution request; request time of the original execution request if a cache was hit, otherwise current session's request time. |
|
IS_REP_EXEC_ST_TS |
Timestamp of the execution start. |
|
IS_REP_EXEC_FN_TS |
Timestamp of the execution finish. |
|
IS_REP_QU_TM_MS |
Queue duration in milliseconds. |
|
IS_REP_CPU_TM_MS |
CPU duration in milliseconds. |
|
IS_REP_EXEC_TM_MS |
Execution duration in milliseconds. |
|
IS_REP_ELAPS_TM_MS |
Difference between start time and finish time; includes time for prompt responses. |
|
IS_REP_NBR_SQL_PAS |
Number of SQL passes. |
|
IS_REP_RESULT_SIZE |
Number of rows in the result set. |
|
IS_REP_SQL_LENGTH |
Not yet available. Number of characters. |
|
IS_REP_NBR_TABLES |
Not yet available. Number of tables. |
|
IS_REP_NBR_PU_STPS |
Number of steps processed in the execution. |
|
IS_REP_NBR_PROMPTS |
Number of prompts in the report execution. |
|
IS_JOB_ERROR_ID |
Integer ID of the job's error message, if any. |
|
IS_ERROR_IND_ID |
Indicates whether the job got an error. |
|
IS_DB_ERROR_IND_ID |
Indicates whether the database returned an error. |
|
IS_CANCELLED_ID |
Indicates whether the job was canceled. |
|
IS_AD_HOC_ID |
Indicates whether the job was created ad hoc. |
|
IS_DATAMART_ID |
Indicates whether the job created a data mart. |
|
IS_ELEM_LOAD_ID |
Indicates whether the job was the result of an element load. |
|
IS_DRILL_ID |
Indicates whether the job was the result of a drill. |
|
IS_SEC_FILT_IND_ID |
Indicates whether the job had a security filter associated with it. |
|
IS_SEC_FILT_ID |
Integer ID of the security filter applied. |
|
IS_SCHED_ID |
Integer ID of the schedule that executed the job. |
|
IS_SCHED_IND_ID |
Indicates whether the job was executed by a schedule. |
|
IS_REP_PRIO_NBR |
Priority of the report execution. |
|
IS_REP_COST_NBR |
Cost of the report execution. |
|
DAY_ID2 |
Integer ID of the day. Format YYYYMMDD. |
|
HOUR_ID |
Integer ID of the hour. Format HH (24 hours). |
|
MINUTE_ID2 |
Integer ID of the minute. Format HHMM (24 hours). |
|
DRILLFROM |
Integer ID of an attribute, metric, or other object that is drilled from. |
|
DRILLFROM_OT_ID |
Integer ID for the object type of the object that is drilled from. |
|
DRILLTO |
Integer ID of an attribute, template, or other object that is drilled to. |
|
DRILLTO_OT_ID |
Integer ID for the object type of the object that is drilled to. |
|
DRILLTYPE |
Integer flag indicating the type of drill performed (for example, drill to template, drill to attribute, and so on). |
|
ERRORMESSAGE |
Error message returned by Intelligence Server. |
|
IS_CACHE_SESSION_ID |
Alphanumeric ID of the session that created the cache on Intelligence Server. |
|
IS_CACHE_JOB_ID |
Integer ID of the job that created the cache on Intelligence Server. |
|
IS_REP_PMT_ANS_TS |
Data and time when the prompt was answered. |
|
IS_SQL_EXEC_IND_ID |
Integer ID indicating if this job hit generated SQL and hit a database or not. |
|
IS_EXPORT_IND_ID |
Integer ID indicating if this was an export job or not. |
|
IS_CUBE_INST_ID |
GUID of the Intelligent Cube object (if job hits it). |
|
IS_CUBE_SIZE |
Size of the Intelligent Cube the job hits (if applicable). |
|
IS_REP_PR_ANS_TM_MS |
Time in milliseconds of how long the user took to answer the prompt. |
|
IS_EXEC_FLAG |
Internal flag that indicates the type of job execution. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
|
IS_MESSAGE_ID |
Internal alphanumeric ID attached to every job. |
|
DAY_ID |
This column is deprecated. |
|
MINUTE_ID |
This column is deprecated. |
IS_REP_SEC_FACT
Contains information about security filters applied to report jobs. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_REP_FACT: Contains information about report job executions
- IS_REP_SEC_STATS: Statistics table containing information about job executions with security filters
- IS_SEC_FILT: Provides descriptive information about the security filters being tracked
- IS_SF_ATT: Relationship table between security filters and attributes
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
EM_LOAD_TS |
Timestamp of when the Enterprise Manager data load process began. |
|
IS_PROJ_ID |
Integer ID of the project logged in to. |
|
IS_REP_JOB_SES_ID |
GUID of the session that created the cache if a cache was hit in this execution; otherwise, current session (default behavior). |
|
IS_REP_JOB_ID |
Integer ID of the report job execution. |
|
IS_REP_SEC_FILT_ID |
Integer ID of the security filter. |
|
IS_ATT_ID |
Integer ID of the attribute. |
|
DAY_ID |
Day the job was requested for execution. |
|
HOUR_ID |
Hour the job was requested for execution. |
|
MINUTE_ID |
Minute the job was requested for execution. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_REP_SQL_FACT
Contains the SQL that is executed on the warehouse by report job executions. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_REP_FACT: Contains information about report job executions
- IS_PROJ: Lookup table for projects
- IS_REP_SQL_STATS: Statistics table containing information about SQL statements
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_PROJ_NAME |
Project name. |
|
IS_REP_JOB_SES_ID |
GUID of the current session object. |
|
IS_REP_JOB_ID |
Integer ID of the report job execution. |
|
IS_PASS_SEQ_NBR |
Integer ID of the sequence of the pass. |
|
IS_REP_SQL_SEQ |
If a SQL statement is very long, it is broken into multiple rows. This column represents the Sequence of a SQL Statement. For example, if a SQL is very long and broken into two parts, this table would contain two rows for that SQL with the value of this column being '1' and '2'. |
|
IS_REP_EXEC_ST_TS |
Timestamp of the execution start. |
|
IS_REP_EXEC_FN_TS |
Timestamp of the execution finish. |
|
IS_REP_EXEC_TM_MS |
Execution duration in milliseconds. |
|
IS_REP_SQL_STATEM |
SQL statement. |
|
IS_REP_SQL_LENGTH |
Length of SQL statement. |
|
IS_REP_NBR_TABLES |
Number of tables accessed by SQL statement. |
|
IS_PASS_TYPE_ID |
Integer ID of the type of SQL pass. |
|
IS_REP_DB_ERR_MSG |
Error returned from the database; NULL if no error. |
|
DAY_ID |
Day the job was requested for execution. |
|
HOUR_ID |
Hour the job was requested for execution. |
|
MINUTE_ID |
Minute the job was requested for execution. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_REP_STEP_FACT
Contains information about the processing steps through which the report execution passes. Created as a view based on columns in the source tables listed below.
Source Tables
- IS_REP_STEP_STATS: Statistics table containing information about report job processing steps
- IS_REPORT_STATS: Statistics table containing information about report job executions
- IS_SESSION: Lookup table for session objects
- IS_PROJ: Lookup table for projects
List of Table Columns
| Column Name | Column Description |
|
EM_RECORD_TS |
Timestamp when the information was recorded by Intelligence Server into the _STATS table. |
|
IS_PROJ_ID |
Integer ID of the project logged into. |
|
IS_PROJ_NAME |
Project name. |
|
IS_REP_JOB_SES_ID |
GUID of the current session object. |
|
IS_REP_JOB_ID |
Integer ID of the report job execution. |
|
IS_REP_STEP_SEQ_ID |
Integer ID of the sequence of the step. |
|
IS_REP_STEP_TYP_ID |
Integer ID of the type of step. |
|
IS_REP_EXEC_ST_TS |
Timestamp of the execution start. |
|
IS_REP_EXEC_FN_TS |
Timestamp of the execution finish. |
|
IS_REP_QU_TM_MS |
Queue duration in milliseconds. |
|
IS_REP_CPU_TM_MS |
CPU duration in milliseconds. |
|
IS_REP_EXEC_TM_MS |
Execution duration in milliseconds. |
|
DAY_ID |
Day the job was requested for execution. |
|
HOUR_ID |
Hour the job was requested for execution. |
|
MINUTE_ID |
Minute the job was requested for execution. |
|
IS_REPOSITORY_ID |
Integer ID of the metadata repository. |
IS_SESSION_FACT
Enables session concurrency analysis. Keeps data on each session for each hour of connectivity.
Related Lookup Tables
- IS_SESSION: Lookup table for session objects
- DT_DAY: Lookup table for dates
- TM_HOUR: Lookup table for hours
List of Table Columns
| Column Name | Column Description |
|
IS_SESSION_ID |
GUID of the session object. |
|
IS_SERVER_ID |
Integer ID of the server where the session was created. |
|
EM_USER_ID |
Integer ID of the user who created the session. |
|
IS_CONNECT_TS |
Timestamp of the beginning of the session (login). |
|
IS_DISCONNECT_TS |
Timestamp of the end of the session (logout). NULL if the session is still open at the time of Enterprise Manager data load. |
|
IS_CONNEC_M_ID |
Integer representation of the day and hour when the connection began. Format: YYYYMMDDHH (24 hours). |
|
IS_DISCON_M_ID |
Integer representation of the day and hour when the connection ended. Format: YYYYMMDDHH (24 hours). |
|
EM_CONNECT_SOURCE |
Connection source through which the session was established: 0: Unknown 1: MicroStrategy Developer 2: MicroStrategy Intelligence Server Administrator 3: MicroStrategy Web Administrator 4: MicroStrategy Intelligence Server 5: MicroStrategy Project Upgrade 6: MicroStrategy Web 7: MicroStrategy Scheduler 8: Custom application 9: MicroStrategy Narrowcast Server 10: MicroStrategy Object Manager 11: ODBO Provider 12: ODBO Cube Designer 13: MicroStrategy Command Manager 14: MicroStrategy Enterprise Manager 15: MicroStrategy Command Line Interface 16: MicroStrategy Project Builder 17: MicroStrategy Configuration Wizard 18: MicroStrategy MD Scan 19: MicroStrategy Cache Utility 20: MicroStrategy Fire Event 21: MicroStrategy Java Admin Clients 22: MicroStrategy Web Services 23: MicroStrategy Office 24: MicroStrategy Tools 25: MicroStrategy Portal Server 26: MicroStrategy Integrity Manager 27: Metadata Update 28: COM Browser 29: MicroStrategy Mobile 30: Repository Translation Wizard 32: MicroStrategy Cube Advisor |
|
DAY_ID |
Integer ID of the day. Format: YYYYMMDD. |
|
HOUR_ID |
Integer ID of the hour. Format HH (24 hours). |
|
MINUTE_ID |
Minute the job was executed. |
IS_SESSION_MONITOR
For MicroStrategy use. A view table that provides an overview of recent session activity.