How do I use the in-memory cube option?

Once you've designed your data cube (ETL process), you can choose the in-memory storage type which can significantly improve the performance of data retrieval.


Building the in-memory cube can take some time though, depending on the columns and default measures selected in your data cube. For this reason, the build can be scheduled to run periodically.


The in-memory cube is also persisted to the Dundas BI Warehouse database so that it can be reloaded back into memory in the event the server is restarted.


If you make changes to your data cube after the in-memory storage has been built, you should manually rebuild the in-memory storage.


See also: Data cube storage types

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri