Time Series Analysis Tables

Starting in MicroStrategy ONE (September 2024) several aggregate tables have been added to the Platform Analytics Warehouse. These tables enable more performant time-series analysis so you can evaluate adoption or usage month over month, quarter over quarter, or year over year, without waiting hours for a report to aggregate the transactional data. The tables are updated by a series of procedures in platform_analytics_wh that are executed across daily and hourly schedules.

Table Name	Update Frequency
agg_fact_client_executions	Every five minutes
agg_fact_dossier_page_views	Every five minutes
agg_fact_ai_chatbot_interactions	Every five minutes
agg_fact_access_transactions	Every five minutes

All metrics associated with aggregate tables are postfixed with (agg), and they can be found throughout the different folders of Platform Analytics depending on their associated topic. The aggregate table dimensions have been mapped to their respective attributes. Simply add the (agg) metric in your report with the usual attributes and see improved query performance when not performing transaction-level analysis.