Creating a cube from an existing report

There is an increasing demand, from users across all organizations, for higher BI performance, driven by the rapid growth of data volumes and number of users. In this recipe, we will see how to transform a report into a cube.

In-Memory cubes help reduce data transfer between the RDBMS and the Intelligence Server, thus decreasing network bandwidth utilization.

A faster response helps improve user satisfaction, and ultimately, wide adoption of the platform and productivity.

When we execute an In-Memory cube, no data is displayed. The query is run and the result set is stored in memory ready to be used by reports, documents, or Visual Insight analyses (starting from 9.3.1 analyses are called dashboards). The process ...

Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.