To calculate
the Price, we need to take the individual price and multiply it with the
quantity ordered. We will use the following query to bring in the
required information:
select
CLASSICMODELS.EMPLOYEES.LASTNAME || ???, ??? || CLASSICMODELS.EMPLOYEES.
FIRSTNAME employeeName,
CLASSICMODELS.ORDERS.ORDERDATE,
CLASSICMODELS.ORDERDETAILS.PRICEEACH * CLASSICMODELS.ORDERDETAILS.
QUANTITYORDERED totalPrice
from
CLASSICMODELS.EMPLOYEES,
CLASSICMODELS.CUSTOMERS,
CLASSICMODELS.ORDERDETAILS,
CLASSICMODELS.ORDERS
where
CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER =
CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER
and CLASSICMODELS.ORDERS.CUSTOMERNUMBER =
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
and CLASSICMODELS.ORDERS.ORDERNUMBER =
CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
4. In order to create a Crosstab, we have to create a Data Cube. In BIRT, a Data
Cube is an implementation of an OLAP Cube built using Data Sets. In BIRT,
Dimensions are called Groups, and Measures are called Summary Fields. We
need to create Dimensions based on the Order Dates and Employee. Under
the Data Explorer, right-click on the Data Cubes folder and choose New
Data Cube.
Working with Data
[ 108 ]
5. Name the Cube employeeSalesDataCube, and choose employeeSales as the
Primary dataset.
6. Under the Groups and Summaries screen, you can drag over the database
fields that you want to summarize as your Dimensions|Groups and
Measures|Summary Fields.
Pages:
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115