Data snapshots and multiple breakdowns
The Data snapshots feature in Platform Analytics allows for multiple breakdowns while analyzing your indicators (KPIs). This architecture uses a change data capture (CDC) process, which captures data changes from configurable tables that are optimized for generating scores and time series at run-time.
Classic Performance Analytics calculates multiple breakdowns applied to an indicator through a matrix. Mathematically, the number of calculations increases geometrically with the number of breakdowns. Practically, this approach limits you to a maximum of two breakdowns that can be applied to an indicator simultaneously.
The Data snapshots feature does not use breakdown matrixes. Thanks to the use of CDC instead, you can apply multiple breakdown levels. The ability to apply more than two levels of breakdown addresses one of the longstanding pain points of Performance Analytics. This feature deepens your ability to analyze data and broadens the insights you can gain through Performance Analytics.
- Data snapshots requires that your instance uses the RaptorDB Professional database.
- Domain-separated instances are not supported.
- To get Data snapshots and enable multiple levels of breakdown, activate the Data Snapshots (com.snc.pa.mlb) plugin. A Performance Analytics subscription and the admin role are required. If you have Australia Patch 3 or later, the plugin is installed automatically on qualified instances.
- Consider testing the Data snapshots feature in a development environment before activating it on a production instance.
- To convert classic Performance Analytics indicators to Data snapshots, check whether the indicator supports Data snapshots. Then activate Data snapshots for the indicator if it does. For more information, see Activate Data snapshots.
- Only Platform Analytics experience components (Data visualizations, KPI Details) support Data snapshots. You cannot show more than two levels of breakdowns in Core UI components like PA widgets and the Analytics Hub.
- Data snapshots collection jobs may result in increased storage use by Performance Analytics. The jobs copy subsets of the source tables and store every daily change for related records.
- Automated indicators that do not use scripted aggregations (non-scripted indicators).
- Formula indicators with only non-scripted, automated contributing indicators
- Formula indicators that contain other formula indicators, provided that ultimately the underlying indicators are non-scripted, automated indicators.
If an indicator does not support Data snapshots, the reasons appear in a warning on the indicator's record page.