(v23) Data Cube Data Storage Options

Data Cube Data Storage Options

This applies to: Managed Dashboards, Managed Reports

A data cube is a multidimensional model of your data that can optionally include a Storage Type to potentially increase data retrieval performance or reduce the load on your database servers or other data sources. There are three storage options available from the toolbar when you create or edit a data cube:

• None – (Default) Connects to data sources directly when the data cube is used in a visualization. You can opt for short term caching or real-time updates of the live data.

• Warehouse – Stores or caches the transformed data in the Symphony Warehouse database when the cube is built.

• In-Memory – Stores data in server memory for even greater performance potential for data analysis queries.

When you select warehouse or in-memory storage, you can build the storage on-demand or schedule it to run periodically, in off-peak hours. Additionally, you can select to perform incremental updates, and retrieve only data added to the database since the last build. Incremental updates can potentially help you build large data cubes faster.

Important: A data cube that contains public parameters or user-specific filters cannot be built as a warehouse or in-memory cube. A security hierarchy can be used instead of filtering by custom attributes.

For more information, see Data Cube Storage Preparation and Use.