SUMMARY:
Inside the Strategy product documentation located in the following link: https://microstrategyhelp.atlassian.net/wiki/spaces/MSTRDOCS/overview?mode=global
Under the section Supplemental Admin Guide, Chapter - Intelligence Server Statistics Data Dictionary, the table STG_IS_REP_COL_STATS is defined as follows:
(*In newer version, Supplemental Admin Guide is merged into System Administration Guide. For example, as of 10.10, this information can be found under System Administration Guide > Intelligence Server Statistics Data Dictionary).
This table tracks the column-table combinations used in the SQL during report executions. This table is used when the Report job tables/columns accessed option is selected in the Statistics category of the Project Configuration Editor. Then the data load process moves this table’s information to the IS_REP_COL_STATS table, which has the same columns and datatypes.
The values and descriptions are not specified in the Supplemental Admin Guide for the column SQLCLAUSETYPEID. These values describe the SQL clause where the column is being used.
ACTION:
In the following list you'll find the possible values and descriptions for the different SQL clauses, ie: select, from, group by, aggregate.
1 - Select
2 - Group by
4 - Aggregate
8 - From
16 - Where
17 - Order by
KB7489
