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 Cube and right-click on it.

3. Click on Create Report. Note that the list of report objects reflects the content of the cube.

4. Click on Reseller Attribute, drag-and-drop it to the area labeled Drop objects here to add rows.

5. Click on the Year attribute...