Rollup Designer
Rollup Designer provides an easy way to create and edit pre-aggregations.
Rollup Designer is available in Cube Cloud on all product tiers (opens in a new tab).
Identifying slow queries
You can identify queries that might be accelerated with pre-aggregations in Playground and Query History.
You can also access Rollup Designer from Data Model.
Playground
When you execute a query in Playground that has no matching pre-aggregations, you would see this notificaton. Clicking on it will open Rollup Designer with a suggested pre-aggregation:
Query History
When you browse a query in Query History that has no matching pre-aggregations, you would see this notificaton. Clicking on Accelerate will open Rollup Designer with a suggested pre-aggregation:
Creating pre-aggregations
When you open Rollup Designer from Playground or Query History, it will suggest a pre-aggregation accelerating the query in question:
If desired, you can also modify settings such as the refresh key, the partition granularity, and indexes to further optimize the pre-aggregation by clicking the Settings tab:
Click Add to the Data Model to add the pre-aggregation to the data model.