Database Reference
In-Depth Information
Figure 1.15
Completed crosstab percentage calculation example
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
.