Use Materialized Views (Experimental)
Materialized views allow you to use pre-aggregated query results to speed up query processing in certain scenarios, especially when processing a query with heavily aggregated data. This boosts your visual rendering time.
This is an experimental feature.
Materialized views only work if the metrics and groups in the materialized view definitions match those used by your visuals. For example, no benefit from using materialized views will occur if you define a materialized view for the Planned Sales metric in a data source, but none of the visuals in your environment use the Planned Sales metric. Consequently, it is a good idea to understand what data in your data source is used (or will be used) in visuals before you define a materialized view.
A Volume metric is required in all materialized view definitions. The supplied Volume metric can be renamed.
Support for materialized views is performed using the REST API endpoint
/api/materialized-views, described in Materialized Views API (Experimental). You can also specify materialized view settings for a data source configuration using the UI. See the following topics: