Try It Yourself - Create a Cube Report

Create a Cube Report

Use View reports to show detailed information from your database, such as Sales and

OrderDate.

In this topic, you learn how to create a Cube report that shows sales Detail.

It should take 10 to 15 minutes to complete this topic, and your report will look like this.

Prerequisites:

•	Domain should be created.

•	Server should be created.

•	Query should be created.

•	Admin rights should be present.

Steps:

•	Click on Report Manager menu.

•	Click on Report Writer tab.

•	Click on Add Report.

•	Give Caption Name and select Report Type as a Cube Report.

•	Checked the Checkbox if you want to published report.

•	Click on accept changes

•	Select Report and click on Add Level ("see Creating a Level")

•	Fill all the entries.

•	Click on Accept Changes.

•	Click on Save.

•	Click on Exit.

•	Click on My Desk menu.

•	Click on Public Report button.

•	Click on domain.

•	Select the report.

•	Click on Show Report button.

User Guide 49