MicroStrategy ONE
Cache Hierarchy
The Cache hierarchy provides analysis for Cache Object related actions. Cube actions can include both executions (Cube publish, Report hit Cube, etc) as well as cube administration tasks (Cube Load, Cube Unload, Delete Cube, etc).
The fact_action_cube_cache table stores the data for Cache instances used during a cube action. Key facts include: Cache Expiration Timestamp (UTC), Cache Last Update Timestamp (UTC), Cache Size (KB), Historical Hit Count, and Hit Count.
The cache hierarchy is specific to MicroStrategy and does not include analysis for any Badge actions.
lu_cache_object
Cache Objects stored in the table represents the cube objects for which the cache was created. The cache hierarchy only stores information related to cube and report caches. This table is a view on table lu_object.
|
View Table Column |
Warehouse Table Column |
Description |
Data-Type |
|---|---|---|---|
|
cache_object_id |
object_id |
The fixed ID for the Cache Object. |
bigint(20) |
|
cache_object_guid |
object_guid |
The GUID of the Cache Object in the metadata. |
varchar(32) |
|
cache_object_name |
object_name |
The name of the Cache Object in the metadata. |
varchar(255) |
|
cache_object_desc |
object_desc |
The detailed description of the Cache Object. |
varchar(512) |
|
cache_object_location |
object_location |
The navigation path to the Cache Object in the project. For example: Platform Analytics/Shared Reports/1. Dashboards/Telemetry |
longtext |
|
cache_object_type_id |
object_type_id |
The ID of the Cache Object Type. For example: Data Import Cube OLAP Cube |
smallint(6) |
|
cache_object_creation_ timestamp |
creation_timestamp |
The UTC timestamp for when the Cache Object was first created. |
datetime |
|
cache_project_id |
project_id |
The numeric ID of the corresponding project. |
bigint(20) |
|
cache_object_owner_id |
owner_id |
The ID of the corresponding Cache Object Owner in the metadata. |
bigint(20) |
|
cache_object_modification_timestamp |
modification_timestamp |
The timestamp of when the Cache Object was last modified. |
Datetime |
| cache_object_status_id | object_status_id | The status of the Cache Object. | tinyint(4) |
|
cache_object_version |
object_version |
The version of the Cache Object. |
varchar(32) |
| cache_object_certified | object_certified |
The flag used to track if the Cache Object is certified in the metadata. The flag can be: Not Applicable N Y |
varchar(14) |
lu_cache
The cache instances are stored in the lu_cache table. This stores all cube cache instances created in the metadata over time. Cache instances are identified based on the GUID.
|
Column |
Description |
Data-Type |
|---|---|---|
|
cache_id |
The auto-generated ID for the cache instance. |
bigint(20) |
|
cache_instance_guid |
The GUID of the cache instance in the metadata. |
varchar(32) |
|
cache_type_id |
The ID corresponding to the type of cache. Only Intelligent cube caches are supported. |
tinyint(4) |
|
cache_object_id |
The ID corresponding to the object to which the cache instance was created. |
bigint(20) |
|
metadata_id |
The ID of the corresponding metadata where the cache was created. |
bigint(20) |
lu_cache_type
Cache Type is the categorization of the Cache. Only report Cache and Intelligence Cube Cache types are tracked.
|
Column |
Description |
Data-Type |
|---|---|---|
|
cache_type_id |
The fixed ID for the Cache Type. |
tinyint(4) |
|
cache_type_desc |
The predefined list of Cache Types. For example, a sample element includes an Intelligence cube cache. |
varchar(25) |
lu_cache_object_owner
The lu_cache_object_owner table is used to track the user who created the Cache Object or the user who currently owns the Cache Object. The Cache Object Owner usually defines the permissions for how the Cache Object can be used and by whom. The lu_cache_object_owner table is a view on the lu_mstr_user table in the warehouse.
|
View Table Column |
Warehouse Table Column |
Description |
Data-Type |
|---|---|---|---|
| cache_object_owner_id | mstr_user_id | The auto-generated ID for the current Owner/User in the MicroStrategy metadata. | bigint(20) |
|
cache_object_owner_guid |
mstr_user_guid |
The GUID of the MicroStrategy User in the metadata. |
varchar(32) |
|
cache_object_owner_name |
mstr_user_name |
The name of the MicroStrategy User in the metadata that has ownership of the object. |
varchar(255) |
|
cache_object_owner_login |
mstr_user_login |
The login of the MicroStrategy User in the metadata. |
varchar(255) |
|
creation_timestamp |
creation_timestamp |
The UTC timestamp of when the user was first created in the metadata. |
datetime |
|
modification_timestamp |
modification_timestamp |
The latest UTC timestamp from when the MicroStrategy User was modified. The value will continually update as the User is modified or changed. |
datetime |
|
cache_object_owner_status |
mstr_user_status |
The latest status of the User in the metadata. The status can be: Visible Deleted |
varchar(25) |
|
metadata_id |
metadata_id |
The numeric ID for the corresponding metadata where the MicroStrategy User was created. All users are stored at the metadata level. |
int(11) |
| cache_object_owner_version_id | mstr_user_version | The version ID of the owner of the Cache Object. | varchar(32) |
lu_cache_object_type
The Cache Object Type represents the type of objects the cache instances created. This attribute provides more granular grouping options for the Cache Objects. The data in this table is predefined and this is a view on the table lu_object_type.
|
View Table Column |
WH Table Column |
Description |
Data-Type |
|---|---|---|---|
|
cache_object_type_id |
object_type_id |
The fixed ID for the Cache Object Type. |
smallint(6) |
|
cache_object_type_des c |
object_type_desc |
The fixed list of Cache Object Types. Sample elements include: OLAP Cube Data Import Cube |
varchar(128) |
|
cache_object_category_ id |
object_category_id |
The numeric ID of the corresponding Cache Object Category. Not supported in the schema. |
smallint(6) |
lu_cache_status
The Cache Status indicates the status of the cache instance. The Cache Status can change for the cache instance overtime. Therefore, the Cache Status is stored in the fact_latest_cube_cache and fact_action_cube_cache tables to track the latest, historical, and changing status over the life of the cube cache instance. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9.4.x - 10.x Intelligent Cube status indication and workflow.
|
Column |
Description |
Data-Type |
|---|---|---|
|
cube_status_id |
The fixed numeric ID for the Cache Status. |
int(11) |
|
cube_status_desc |
The description form of the Cache Status. The status can be the combination of any of the following elements: Processing Active Filed Monitoring Information Dirty Dirty Loaded Load Pending Unload Pending Imported Foreign |
varchar(255) |
Cache Project
The Cache Project attribute is a logical table alias based off the lu_project table in the warehouse.
fact_action_cube_cache
The fact_action_cube_cache table records the transactions telemetry related to Cube Cache instances as well as key metrics for each cube action.
Key facts include:
- Hit Count - the number of times the Intelligent cube is used by reports/documents/dashboards since it was last updated. This number increases every time the report/document/dashboard is executed and hits the cache. Hit Count resets when the cache is updated.
- Historical Hit Count - the number of times the Intelligent cube is used by reports/documents/dashboards since it was published. This number will increment regardless of cache updates.
- Cache Size (KB) - records the size of the cube cache instance in KB.
- Cube Last Update Timestamp (UTC) - The UTC timestamp when the cube was last updated.
- Cache Expiration Timestamp (UTC) - The UTC timestamp the cache instance is set to expire.
The Action Categories recorded in the fact_action_cube_cache table include:
- Cube Modification
- Cube Executions
- Cube Cache Hit
- Cache Hit
- Cache Creation
|
Column |
Description |
Data-Type |
|---|---|---|
|
parent_tran_id |
The auto-generated numeric Parent Action ID. This is a source column of the Parent Action attribute. Parent Action is the lowest level that is defined in the Platform Analytics project schema. |
bigint(20) |
|
cache_id |
The auto-generated ID for the cube cache instance. |
bigint(20) |
|
cube_status_id |
The ID corresponding to the status of the cube instance at the transaction level. The status of the cube instance can change over time. |
int(11) |
|
cache_size |
Size of the cube instance in KB. |
bigint(20) |
|
historical_hit_count |
Historical Hit Count of a cube instance. |
bigint(20) |
|
hit_count |
Hit Count of a cube instance. |
bigint(20) |
|
last_update_timestamp |
Last update timestamp (UTC) of the cube. |
datetime |
fact_latest_cube_cache
The fact_latest_cube_cache table records only the latest transaction related to the cube cache instance.
Key facts include:
- Hit Count - the number of times the Intelligent Cube has been used by reports/documents/dashboards since it was last updated. Hit count will increase every time the report/document/dashboard gets executed and hits the cache but will reset when the cache is updated
- Historical Hit Count - the number of times the Intelligent Cube has been used by reports/documents/dashboards since it was published. This number will increment regardless of cache updates.
- Cache Size (KB) - records the size of the cube cache instance in KB.
- Cube Last Update Timestamp (UTC) - The timestamp (in UTC timezone) when cube was last updated.
- Cache Expiration Timestamp (UTC) - The timestamp (in UTC timezone) when the Cache instance is set to expire.
|
Column |
Description |
Data-Type |
|---|---|---|
| cache_id | The auto-generated ID for the cube cache instance. | bigint(20) |
| iserver_instance_id | The auto-generated ID for the cube cache instance. | bigint(20) |
| cube_status_id | The ID corresponding to the status of the cube instance at the transaction level. The status of the cube instance can change over time. | int(11) |
| cache_size | Size of the cube instance in KB. | bigint(20) |
| historical_hit_count | Historical Hit Count of a cube instance. | bigint(20) |
| hit_count | Hit Count of a cube instance. | bigint(20) |
| transaction_timestamp | MicroStrategy internal use. | bigint(20) |
|
last_update_timestamp |
Last update timestamp (UTC) of the cube. |
datetime |