MicroStrategy ONE
STG_CT_MANIP_STATS
Records statistics related to manipulation of reports/documents in a mobile app. This table is used when the Mobile Clients and Mobile Clients Manipulations options are selected in the Statistics category of the Project Configuration Editor and the mobile client is configured to log statistics. The data load process moves this table's information to the CT_MANIP_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 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 |
|
DEVICEINSTID (I) |
Unique installation ID of the mobile app. |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
|
STATECOUNTER (I) |
An integer value that increments when the device information, such as DEVICETYPE, OS, OSVER, or APPVER (in STG_CT_DEVICE_STATS), changes. |
INTEGER |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
USERID |
GUID of the user making the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SESSIONID |
GUID of the session that executed the request. This should be the same as the SESSIONID for this request in STG_ IS_REPORT_STATS. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CTSESSIONID |
GUID of the MicroStrategy Mobile client session ID. A new client session ID is generated every time a user logs in to the mobile app. |
CHAR(32) |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
ACTIONID |
Similar to JOBID but generated by the client and cannot be NULL. The JOBID may be NULL if user is offline during execution. |
INTEGER |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SERVERID |
GUID of the Intelligence Server processing the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Name of the machine hosting the Intelligence Server processing the request. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
REPORTID |
GUID of the report used in the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DOCUMENTID |
GUID of the document used in the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MANIPSEQUENCEID |
The order in which the manipulations were made. For each manipulation, the mobile client returns a row, and the value in this column increments for each row. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
MANIPTYPEID |
Type of manipulation: 0: Unknown 1: Selector 2: Panel Selector 3: Action Selector 4: Change Layout 5: Change View 6: Sort 7: Page By |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
MANIPNAME |
Name of the item that was manipulated. For example, if a selector was clicked, this is the name of the selector. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
MANIPVALUE |
Value of the item that was manipulated. For example, if a panel selector was clicked, this is the name of the selected panel. |
VARCHAR(2000) |
VARCHAR2(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
|
MANIPVALUESEQ |
If the value for MANIPVALUE is too long to fit in a single row, this manipulation is spread over multiple rows, and this value is incremented. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
CTMANIPSTARTTIME |
Time when the user submits the manipulation. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTMANIPFINISHTIME |
Time when the mobile app finishes processing the manipulation and forwards it for rendering. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTMANIPTIME |
Difference between CTMANIPSTARTTIME and CTMANIPFINISHTIME, in milliseconds. |
FLOAT |
FLOAT |
DOUBLE |
FLOAT |
FLOAT |
FLOAT |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DETAIL1 |
A flexible column to capture different states of manipulation. |
VARCHAR(2000) |
VARCHAR2(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
|
DETAIL2 |
A flexible column to capture different states of manipulation. |
VARCHAR(2000) |
VARCHAR2(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
VARCHAR(2000) |
|
RECORDTIME |
Date and time when this information was written to the statistics database. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |