The Pre-Aggregations page in Cube Cloud allows you to inspect all pre-aggregations in your deployment at a glance. You can see which pre-aggregations are accelerating queries, if they are being refreshed, along with the last 24 hours of build history.
Pre-Aggregations are available in Cube Cloud on all tiers (opens in a new tab).
The Pre-Aggregations tab shows a list of all configured pre-aggregations for the deployment, and is useful for quickly checking details such as when the last build occurred, how long the build took to complete, the total size of the pre-aggregated data, and how many partitions the data is split across. To see more information about a specific pre-aggregation, click on it.
The Partitions tab shows all partitions (as specified by
partitionGranularity) of the
pre-aggregation. In the example below, the pre-aggregation has a single
Pre-aggregations with multiple partitions show a list of all partitions, which is helpful for checking pre-aggregation partition build times and sizes:
Ideally partitions should be of a similar size and build time. If a partition is taking significantly longer to build than others, it may be worth investigating why.
If the pre-aggregation requires rebuilding (usually due to the underlying data changing in a significant way), clicking Build All rebuilds all partitions of the pre-aggregation:
You can also choose to rebuild specific partitions by selecting them and then clicking the Build Selected button:
The Definition tab shows how the pre-aggregation is defined in the data model without having to switch to the Data Model page:
To see a sample of the data contained in the pre-aggregation, click the Preview tab:
This can be used to verify that the data within the pre-aggregation is being built correctly.
The Used By tab shows recent queries that used this pre-aggregation for acceleration:
This is especially useful for checking that the pre-aggregation is being used as expected by queries sent to the deployment.
Indexes significantly improve the performance of configured pre-aggregations. The Indexes tab displays any configured indexes for this pre-aggregation:
The Build History tab shows the last 24 hours of build history for all pre-aggregations in the deployment. From here, you can see if a pre-aggregation build succeeded (or failed), how the build was triggered, when the build started, and how long it took to complete.
To see more information about a specific build, click on it: