MicroStrategy ONE
STG_IS_REPORT_STATS
Tracks job-level statistics information about every report that Intelligence Server executes to completion. This table is used when the Basic Statistics option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_REPORT_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Data-type | Oracle Data-type | DB2 Data-type | Teradata Data-type | Sybase Data-type | MySQL Data-type |
|
DAY_ID |
Day the report was requested for execution. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the report was requested for execution. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the report was requested for execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
JOBID (I) |
Job ID. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SESSIONID (I) |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
GUID of the Intelligence Server's server definition that made the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Server machine name, or IP address if the machine name is not available. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
USERID |
GUID of the user. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
REPORTID |
GUID of the report. For an ad hoc report, the Template ID is created on the fly and there is no corresponding object with this GUID in the object lookup table. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
FILTERID |
GUID of the filter. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
EMBEDDEDFILTER |
1 if an embedded filter was used in the report, otherwise 0. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
TEMPLATEID |
GUID of the template. For an ad hoc report, the Template ID is created on the fly, and there is no corresponding object with this GUID in the object lookup table. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
EMBEDDEDTEMPLATE |
1 if an embedded template was used in the report, otherwise 0. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
PARENTJOBID (I) |
Job ID of the parent document job, if the current job is a document job's child. -1 if the current job is not a document job's child. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
DBINSTANCEID |
GUID for the physical database instance. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DBUSERID |
Database user ID for the physical database instance. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
PARENTINDICATOR |
1 if this job is a document job's child, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
REQUESTRECTIME |
Timestamp when the request is received. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
REQUESTQUEUETIME |
Total queue time of all steps in this request. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECSTARTTIME |
Time passed before the first step started. An offset of the RequestRecTime. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECFINISHTIME |
Time passed when the last step is finished. An offset of the RequestRecTime. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SQLPASSES |
Number of SQL passes. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
INTEGER |
|
JOBERRORCODE |
Job error code. If no error, the value is 0. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CANCELINDICATOR |
1 if the job was canceled, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
ADHOCINDICATOR |
1 if the report was ad hoc, otherwise 0. This includes any executed job that is not saved in the project as a report (for example: drilling results, attribute element prompts, creating and running a report before saving it). |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
PROMPTINDICATOR |
Number of prompts in the report. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
DATAMARTINDICATOR |
1 if the report created a data mart, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
ELEMENTLOADINDIC |
1 if the report was a result of an element browse, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
DRILLINDICATOR |
1 if the report was the result of a drill, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
SCHEDULEINDICATOR |
1 if the report was run from a schedule, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
CACHECREATEINDIC |
1 if the report created a cache, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
PRIORITYNUMBER |
Query execution step priority. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
JOBCOST |
User-supplied report cost. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
FINALRESULTSIZE |
Number of rows in the report. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
RECORDTIME (I) |
Timestamp of when the record was logged in the database, according to the database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
ERRORMESSAGE |
The error message displayed to the user when an error is encountered. |
VARCHAR(4000) |
VARCHAR2(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
|
DRILLTEMPLATEUNIT |
For MicroStrategy use. GUID of the object that was drilled from. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
NEWOBJECT |
For MicroStrategy use. GUID of the object that was drilled to. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DRILLTYPE |
For MicroStrategy use. Enumeration of the type of drilling action performed. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
TOTALTABLEACCESS |
Total number of unique tables accessed by the report during execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
INTEGER |
|
SQLLENGTH |
Length in characters of the SQL statement. For multiple passes, this value is the sum of SQL statement lengths of each pass. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECDURATION |
Duration of the report execution, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CPUTIME |
CPU time used for report execution, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STEPCOUNT |
Total number of steps involved in execution (not just unique steps). |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
EXECACTIONS |
Intelligence Server-related actions that need to take place during report execution. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECFLAGS |
Intelligence Server-related processes needed to refine the report execution. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
DBERRORINDIC |
1 if a database error occurred during execution, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT |
|
PROMPTANSTIME |
Total time, in milliseconds, the user spent answering prompts on the report. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CUBEINSTANCEID |
GUID of the Intelligent Cube used in a Cube Publish or Cube Hit job. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CUBESIZE |
Size, in KB, of the Intelligent Cube in memory for a Cube Publish job. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SQLEXECINDIC |
1 if any SQL was executed against the database, otherwise 0. |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT |
|
EXPORTINDIC |
1 if the report was exported, otherwise 0. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MESSAGEID |
ID of the message. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |