Database Reference
In-Depth Information
15.
Close
IBM Cognos Viewer
to return to your report design.
16.
Save this report as
Shipping Dashboard
.
The dashboard now graphically displays the key metrics that drive the shipping organization.
Now that the dashboard has been built, you can create the reports that provide supporting informa-
tion for the data on the dashboard. The manager has three reports in mind. These reports should be
designed to work independently and then drill-through links can be added to the dashboard.
The next three sections will build the detail reports and the last section will link all of them
together.
To analyze the efficiency of a shipping location, a manager may look at the ratio of items returned
to items shipped. An advantage of working with a multidimensional data source is that you can drill
from higher- to lower-level details easily. At a corporate level, a manager may want to see ratios on
a global, regional, or local basis, depending on the situation. Instead of creating multiple reports,
you can create a single report that will allow a user to respond to a prompt at any level of detail.
In addition to being a nice analysis tool, this same report can provide additional details
from our dashboard. Figure 2.12 shows how the completed returned/shipped report should look
after prompting a user for a location.
We will prompt the user to pick a member from the Employee by region hierarchy. You want to
allow users to pick from any level (any time period) and not just a single one, like Year. Another
set will list the members that exist one level below the selected one. This set will allow users to
see the numbers for a region and all the countries in it. Another user could run the report to look
at the employees in a selected city.
The manager would like to see totals of the reasons products were returned, along with the
returned/shipped ratio. Since the orders shipped are not directly linked to how they were
returned, we will provide totals in list headers along with the ratio.
The list will show details for the sub-location, and totals for the selected location will be
displayed at the bottom of the report.
After creating the query, the list report will provide more details regarding the returned to shipped
ratio by the prompted locations.
Step 1: Start the Report
1.
Launch
Report Studio
and select the
GO Data Warehouse (analysis)
package.
2.
Click on the
Create New
option.