Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Eclipse BIRT Report Developer Guide
Previous Page Home Next Page

Previous Next

Task 6: 

Each number that is displayed in the cross tab represents the sales total of a particular product for a particular state. In this procedure, you add grand totals to display the total sales of all products for each state, the total sales of each product, and the total of all sales across products and states.

2
Select the cross tab by clicking on the tab in the lower left corner of the cross tab. Make sure you select the entire cross tab, not just a part of it. Property Editor displays the general properties of the cross tab, as shown in Figure 17‑12.

Figure 17-13 Property Editor displays the general properties of the selected cross tab

5
On Grand Total, shown in Figure 17‑13, use the default values, then choose OK.

Figure 17-14 Creating grand totals in the cross-tab row area

A new row is added to the bottom of the cross tab, as shown in Figure 17‑14. In this row is a label that displays Grand Total and a data element that displays [EXTENDED_PRICE].

Figure 17-15 Cross tab including a new row to display grand totals

Figure 17-16 Cross tab with a new column to display grand totals

How to create data sets for a multi-dataset cube

In this procedure, you create two data sets:

Note that we are not creating a separate data set for the year dimension, as is typical in a star schema. It is sometimes too complicated to create a pure star schema design when working with data stored in an OLTP system.

CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH as "EXTENDED_PRICE"
 
where CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
n
The query creates a calculated column, EXTENDED_PRICE, whose values will be aggregated to calculate the sales totals.
n
The query creates a join between the Orders and OrderDetails tables to get all the necessary data about the orders. Because the data set is retrieving data from an OLTP database, joins are unavoidable.
n
The query contains a filter condition to retrieve order data for orders that have been shipped, and therefore, that have been paid.
n

How to create a multi-dataset cube

2
In Primary dataset, select SalesTotal. In a multi-dataset cube, the fact data set that retrieves the data to calculate measures is the primary data set.

3
Choose Groups and Summaries to define the dimensions and measures for the cube. The Groups and Summaries page, shown in Figure 17‑17, displays the available data sets and fields.

1
Under the Sales Totals (Primary) data set, drag SHIPPEDDATE and drop it under Groups (Dimensions) in the drop location that displays (Drop a field here to create a group).
Group Level displays the different ways to group the dates. To display the dates as they appear in the data source, select Regular Group. To group the dates by any of the time periods, select Date Group.

1
Under the Productlines data set, drag PRODUCTLINE and drop it under Groups (Dimensions) in the drop location that displays (Drop a field here to create a group). On Add Group, use the default group name.
2
Under the Productlines data set, drag PRODUCTCODE and drop it on the PRODUCTLINE dimension. This action creates a hierarchical relationship between PRODUCTLINE and PRODUCTCODE.
6
Define the cube’s measure. Under the Sales Totals (Primary) data set, drag EXTENDED_PRICE and drop it under Summary Fields (Measures) in the drop location that displays (Drop a field here to create a summary field).
The Groups and Summaries page, shown in Figure 17‑19, displays the dimensions and measure that you define.

1
Choose Link Groups. The Link Groups page displays the Productline dimension you created and the primary (fact) data set.

Figure 17‑20

Figure 17‑21 shows a cross tab that uses the year and PRODUCTLINE dimensions and the EXTENDED_PRICE measure from the cube.

Figure 17‑21

Figure 17‑22 shows the generated cross tab.

Figure 17‑22

(c) Copyright Actuate Corporation 2009

 
 
  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire