Creating reports and documents based on a cube

Reports and documents based on a cube give fast access to the data and are very similar to their data warehouse counterparts. The main difference is that the objects available are only those attributes and metrics present in the cube.

Of course, we can use features such as sorting, totals, prompts, and view filters as we did in previous chapters with standard reports and documents.

Drilling is limited to the objects included in the cube unless you specifically allow reports to drill outside.

Getting ready

You need to have completed the preceding recipes to continue.

How to do it...

To create a report based on a cube:

  1. Open the Web Interface and go to My Reports folder.
  2. Scroll down to find the 54 ResellerSales ...

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.