Cross Table Revenue By Product (BIRT)
This example illustrates using the Cross Table Element and the Cube Builder.
BIRT Version Compatibility
This example was built and tested with BIRT 2.2 RC0.
When using the Cross Table element it is important to understand that is sources its data from a BIRT Cube, which is built on top of BIRT Data Sets.
In this example the data set is built first against the sample db and has the following query.
select * from CLASSICMODELS.ORDERS, CLASSICMODELS.CUSTOMERS, CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS where CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS.ORDERNUMBER and CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCTS.PRODUCTCODE and CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS.CUSTOMERNUMBER and CLASSICMODELS.ORDERS.STATUS = 'Shipped'
The cube is then constructed against this data set with Product Line and shipped date as dimensions and a calculated revenue as the measure. Dates are special dimensions and the group levels are generated automatically. Additional group levels can be added to dimensions using the drag and drop capability from the available data fields in the Cube builder. Revenue is caclulated using the expression:
Although not shown in the example, multiple measures are supported.
Once the cube is complete you can drag the Cross Table element to the report canvas and drag the dimensions from the cube to the columns or rows and the measures to the intersection point.
The Cross Table element supports a GUI for setting the display group levels and adding aggregation totals. In this example product lines are cross tabulated with year/quarter revenue. The values are totaled by year, with grand totals in the last column and row.
Please enter comments below by selecting the edit icon to the right. You will need a Bugzilla account to add comments.