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