MicroStrategy ONE
STG_IS_CUBE_REP_STATS
Records statistics related to Intelligent Cube manipulations. This table is not populated unless at least one of the Advanced Statistics Collection Options are selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Datatype | Oracle Datatype | DB2 Datatype | Teradata Datatype | Sybase Datatype | MySQL Datatype |
|
DAY_ID (I) |
Day the action was started. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the action was started. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the action was started. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SESSIONID |
GUID of the session that executed the action on the Intelligent Cube. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
JOBID |
Job ID for the action on the Intelligent Cube. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
STARTTIME |
Timestamp of when the action started. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
FINISHTIME |
Timestamp of when the action finished. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CUBEREPORTGUID |
GUID of the Intelligent Cube report that was executed. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CUBEINSTANCEID |
GUID of the Intelligent Cube instance in memory. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CUBEACTIONID |
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 |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
REPORTGUID |
If a report hit the Intelligent Cube, the GUID of that report. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CUBEKBSIZE |
If the Intelligent Cube is published or refreshed, the size of the Intelligent Cube in KB. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CUBEROWSIZE |
If the Intelligent Cube is published or refreshed, the number of rows in the Intelligent Cube. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SERVERMACHINE |
Name of the Intelligence Server processing the request. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
RECORDTIME |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |