Database Reference
In-Depth Information
Figure 1.15
Completed crosstab percentage calculation example
Step-by-Step
We will start with a simple crosstab template.
Step 1: Start the Report
1.
Launch Report Studio and select the GO Data Warehouse (analysis) package.
2.
Click on the Create new option.
COGNOS 8 NOTE
The option is Create a new report or template .
3.
Select the Crosstab report template and click OK .
We will be using the Sales (analysis) namespace inside the Sales and Marketing
(analysis) folder, same as we did for the previous examples in this chapter.
Step 2: Set Up the Crosstab
1.
From the Source tab of the Insertable Objects pane, drag the following levels into the
Crosstab:
Product Line from the Products dimension and Products hierarchy to the Rows
drop zone
Ye a r from the Time dimension and Time hierarchy to the Columns drop zone
2.
Drag Revenue and Planned revenue from the Sales fact measures to the Columns
drop zone and nest them under the Ye a r data item.
COGNOS 8 NOTE The Products and Time dimensions and hierarchies are called
Product and Time Dimension .
 
 
Search WWH ::




Custom Search