In MicroStrategy Enterprise Manager, the levels of Statistics logging are divided into Basic and Advanced Logging (and not per statistics table) as shown below. The level of Statistics logging is still controlled from the Project Configuration editor under Statistics > General.
Screenshots MicrosStrategy 9.4.1 | MicroStrategy 10.x |
 |  |
-It is not possible for users to enable advanced logging without logging basic statistics.
-In MicroStrategy 10.x statistics are logging first on Staging Statistics tables (STG_IS_XXX_STATS) then Enterprise Manager moves data from the staging statistics tables to the historical statistics tables (IS_XXX_STATS).
SummaryThe chart below shows how the statistics collection change from MicroStrategy version 9.x to version 10.x:
Statistics logging option | Statistics logged | Tables v9.x* | Tables v10.x |
All basic statistics | User session and project session analysis. This option must be selected for any statistics to be logged. | • IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9.2.1 and later)
• MSI_STATS_LOG (not used in MicroStrategy version 9.x)
• MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) | • IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes)
• IS_INBOX_ACT_STATS
• IS_MESSAGE_STATS
• IS_PR_ANS_STATS
• MSI_STATS_LOG
• MSI_STATS_PROP
• IS_ALERT_STATS (statistics related to Health Center alerts) |
Report job steps | Detailed statistics on the processing of each report. | IS_REP_STEP_STATS | IS_REP_STEP_STATS |
Document job steps | Detailed statistics on the processing of each document. | IS_DOC_STEP_STATS | IS_DOC_STEP_STATS |
Report job SQL | The generated SQL for all report jobs. | IS_REP_SQL_STATS | IS_REP_SQL_STATS |
|
*This option can create a very large statistics table. Select this option when you need the job SQL data. |
Report job tables/columns accessed | Data warehouse tables and columns accessed by each report. | IS_REP_COL_STATS | IS_REP_COL_STATS |
Prompt Answers | Collects information about prompts and prompt answers used during report execution. | IS_PR_ANS_STATS (New table introduced in MicroStrategy 9.0) | Merged into Basic Statistics |
Subscriptions deliveries | Collects information about deliveries scheduled through Distribution Services. | IS_MESSAGE_STATS (New table introduced in MicroStrategy 9.0) This table is to be used in conjunction with IS_SCHEDULE_STATS. | Merged into Basic Statistics |
Inbox messages | Log data about Inbox messages. | IS_INBOX_ACT_STATS (New table introduced in MicroStrategy 9.0.1) | Merged into Basic Statistics |
Mobile Clients | Detailed statistics on reports and documents that are executed on a mobile device. | • CT_EXEC_STATS
• CT_DEVICE_STATS
(New tables introduced in MicroStrategy 9.3.0) | • CT_EXEC_STATS
• CT_DEVICE_STATS |
Mobile Client Location | When the option 'Mobile Clients Location' is checked, and users allow the MicroStrategy app to use the current location, logs location. | CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table. | CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table. |
Mobile Clients Manipulations | Detailed statistics on actions performed by end users on a mobile client. | CT_MANIP_STATS (statistics related to manipulation of reports/documents in a mobile app. New table introduced in MicroStrategy 9.3.1) | Manipulations' column is populated in the CT_EXEC_STATS statistics table. |
|
|
KB424140
