Lookup Tables

Lookup table for mobile client execution type.

0: Unknown

1: User

2: Pre-cached

3: Application recovery

4: Subscription cache pre-loading

5: Transaction subsequent action

6: Report queue

7: Report queue recall

8: Back button

Lookup table for mobile client manipulation type:

0: Unknown

1: Selector

2: Panel Selector

3: Action Selector

4: Change Layout

5: Change View

6: Sort

7: Page By

8: Information Window

9: Annotations

10: E-mail Screenshots

11: Widget: Video-Play

12: Widget: Video-Pause

20: Widget: Multiple-Download

21: Widget: Multiple-Open

Lookup table for Days in the Date hierarchy.

Lookup table for Months in the Date hierarchy.

Lookup table for Months of the Year in the Date hierarchy.

Lookup table for Quarters in the Date hierarchy.

Lookup table for the Quarters of the Year in the Date hierarchy.

Lookup table for the Days of the Week in the Date hierarchy.

Lookup table for Weeks of the Year in the Date hierarchy.

Lookup table for Years in the Date hierarchy.

Lookup table for Intelligence Server machines used in statistics.

Lookup table for Client Machines used in the statistics.

Lookup table for the connection source of a session on Intelligence Server.

Lookup table for the database users used in the statistics.

Lookup table for the existence status of objects.

Lookup table for the hidden status of objects.

Lookup table for the job status of job executions on Intelligence Server:

0: Ready

1: Executing

2: Waiting

3: Completed

4: Error

5: Cancelled

6: Stopped

7: Waiting for governor

8: Waiting for prompt

9: Waiting for project

10: Waiting for cache

11: Waiting for children

12: Waiting for fetching results

Provides information about the projects being monitored and when the first and last data loads occurred.

Provides descriptive information about the owners being tracked. This table is a view based on columns from the EM_USER table.

Provides descriptive information about the users being tracked.

Provides descriptive information about the user groups being tracked.

Lookup table for the Web Server Machines used in the statistics.

Lookup table for the Ad Hoc indicator.

Provides descriptive information about the attributes being tracked.

Provides descriptive information about the attribute forms being tracked.

Lookup table for the Cache Creation indicator.

Lookup table for the Cache Hit indicator:

0: Reserved

1: Server cache or no cache hit

2: Device cache

6: In-memory view cache

Lookup table for the Canceled indicator.

Lookup table for the Child Job indicator.

Provides descriptive information about the columns being tracked.

Lookup table for Intelligence Server and project-level configuration settings.

Provides descriptive information about the consolidations being tracked.

Lookup table for the type of contact delivered to through Distribution Services.

Lookup table for the manipulations that can be performed on an Intelligent Cube.

Lookup table for the Cube Hit indicator.

Provides descriptive information about the Intelligent Cubes being tracked. This table is a view based on columns from the IS_REP table.

Provides descriptive information about the custom groups being tracked.

Lookup table for the job type:

3: Report

55: Document

Lookup table for the Data Mart indicator.

Lookup table for the Database Error indicator.

Provides descriptive information about the database instances in the monitored Intelligence Servers.

Lookup table for the database tables being monitored.

Lookup table for the Delivery Status indicator.

Lookup table for the Distribution Services delivery type.

Provides descriptive information about the devices being tracked.

Provides descriptive information about the document objects being tracked.

Lookup table for the step types in document execution. For a list and explanation of values, see Lookup Tables.

Indicator lookup table for document or dashboard type. Types include:

-1: Unknown

0: HTML document

1: Report Services document

2: Visual Insight dashboard

Lookup table for the Drill indicator.

Lookup table for the Element Load indicator.

Lookup table for the Error indicator.

Provides descriptive information about the events being tracked.

Lookup table for the Export indicator.

Provides descriptive information about the facts being tracked.

Provide descriptive information about the filters being tracked.

Provides descriptive information about the hierarchies being tracked.

Lookup table for the Drillable Hierarchy indicator.

Provides a list of the different manipulations that can be performed on a History List message.

Lookup table for the Job Priority type.

Provides descriptive information about the metrics being tracked.

Provides descriptive information about the Intelligent Cubes being tracked.

Indicator lookup table for priority maps.

Provides descriptive information about the projects being tracked.

Provides descriptive information about the prompts being tracked.

Lookup table for the Prompt indicator.

Provides descriptive information about the reports being tracked.

Lookup table for the SQL pass types of report execution.

Lookup table for the step types of report execution. For a list and explanation of values, see Lookup Tables.

Lookup table for the Report Cube Type indicator:

0: Reserved

1: Base Report

2: Working Set Report

3: Private Base Report

5: Report Services Base Report

6: CSQL Pre-Execution Report

7: OLAP Cube Report

8: OLAP View Report

9: Incremental Refresh Report

Indicator lookup table for report type. Report types include:

-1: Unknown: The server is unable to retrieve the report type.

0: Reserved: Ad hoc reports. May include other reports that are not persisted in the metadata at the point of execution.

1: Relational: All regular project reports.

2: MDX: Reports built from SAP BW, Essbase, Analysis Services, and other cube sources.

3: Custom SQL Freeform: MicroStrategy Freeform SQL reports, in which the SQL is entered directly into the interface.

4: Custom SQL Wizard: MicroStrategy Query Builder reports.

5: Flat File: Reserved for MicroStrategy use.

Provides descriptive information about the schedules being tracked.

Lookup table for the Schedule indicator.

Provides descriptive information about the security filters being tracked.

Lookup table for the Security Filter indicator.

Provides descriptive information about the server definitions being tracked.

Lookup table for the session statistics logged by Intelligence Servers.

Primary key: DAY_ID, IS_SESSION_ID

Lookup table for SQL clause types; used to determine which SQL clause (SELECT, WHERE, GROUP BY, and so on) a particular column was used in during a report execution.

SQL Clause Type attributes:

1: Select: Column was used in the SELECT clause but was not aggregated, nor does it appear in a GROUP BY clause. For example, a11.Report column in "Select a11.Report from LU_REPORT a11".

2: Select Group By: Column was used in the GROUP BY clause. For example, a11.Report Column in "select a11.Report, sum(a11.Profit) from LU_REPORT group by a11.Report".

4: Select Aggregate: Column was used for aggregation. For example, a11.Report column in "select count(a11.Report) from LU_REPORT".

8: From: Column was used in a FROM clause

16: Where: Column was used in a WHERE clause

17: Order By: Column was used in an ORDER BY clause.

Lookup table for the SQL Execution indicator.

Provides descriptive information about the logical tables being monitored.

Provides descriptive information about the templates being monitored.

Provides descriptive information about the transformations being monitored.

Lookup table for the transformation mapping types.

Provides descriptive information about the information transmitters being monitored.

Lookup table for Hour in the Time hierarchy.