Eclipse BIRT Designer Version 2.2.1.r221_v20070924 Build <2.2.0.v20070924-1550> in Copyright (c) 2006 <<Your Company Name here>> Creates a blank report with no predefined content. Customer Cube.Data Set.x integer false Customer Cube.Data Set.y integer false salesbydate.DataForCube.x integer false salesbydate.DataForCube.y integer false salesByDateCube.DataForCube.x integer false salesByDateCube.DataForCube.y integer false 235 105 135 80 135 80 Blank Report /templates/blank_report.gif org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels 1 SHIPPEDDATE date 91 2 STATUS string 12 3 QUANTITYORDERED integer 4 4 PRICEEACH float 8 5 PRODUCTLINE string 12 revenue row["PRICEEACH"]*row["QUANTITYORDERED"] float SHIPPEDDATE SHIPPEDDATE STATUS STATUS QUANTITYORDERED QUANTITYORDERED PRICEEACH PRICEEACH PRODUCTLINE PRODUCTLINE 1 SHIPPEDDATE date 2 STATUS string 3 QUANTITYORDERED integer 4 PRICEEACH float 5 PRODUCTLINE string 6 revenue float Data Source select orders.shippeddate, orders.status, orderdetails.quantityordered, orderdetails.priceeach, products.productline from ORDERS inner join CUSTOMERS on CUSTOMERS.CUSTOMERNUMBER=ORDERS.CUSTOMERNUMBER inner join ORDERDETAILS on ORDERS.ORDERNUMBER=ORDERDETAILS.ORDERNUMBER inner join CLASSICMODELS.PRODUCTS on ORDERDETAILS.PRODUCTCODE=PRODUCTS.PRODUCTCODE where orders.status = 'Shipped' revenueMeasure NewTabularHierarchy2 string PRODUCTLINE DataForCube true NewTabularHierarchy3 date-time year SHIPPEDDATE date-time quarter SHIPPEDDATE date-time month SHIPPEDDATE date-time week-of-month SHIPPEDDATE date-time week-of-year SHIPPEDDATE date-time day-of-week SHIPPEDDATE date-time day-of-month SHIPPEDDATE date-time day-of-year SHIPPEDDATE date-time hour SHIPPEDDATE date-time minute SHIPPEDDATE date-time second SHIPPEDDATE DataForCube dataSetRow["revenue"] float DataForCube html new Date()]]> revenue sans-serif 10pt 0pt 0pt 0pt 0pt Currency $#,##0 right revenue timeGroup/year productLineGroup/PRODUCTLINE sans-serif 10pt 0pt 0pt 0pt 0pt Currency $#,##0 right revenue_timeGroup/year_productLineGroup/PRODUCTLINE totalCell productLineGroup/PRODUCTLINE sans-serif 10pt bold 0pt 0pt 0pt 0pt Currency $#,##0 right revenue_productLineGroup/PRODUCTLINE totalCell timeGroup/year sans-serif 10pt 0pt 0pt 0pt 0pt Currency $#,##0 right revenue_timeGroup/year totalCell timeGroup/quarter sans-serif 10pt 0pt 0pt 0pt 0pt Currency $#,##0 right revenue_timeGroup/quarter totalCell sans-serif 10pt bold 0pt 0pt 0pt 0pt Currency $#,##0 right revenue_1 totalCell #808000 "Microsoft Sans Serif" 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px Grand Total timeGroup timeGroup/year #808000 sans-serif 10pt bold #FFFFFF Year/QTR #808000 sans-serif 10pt bold #FFFFFF year solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 #808000 sans-serif 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px center Total timeGroup/quarter #808000 sans-serif 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px center quarter #808000 sans-serif 10pt bold #FFFFFF right Grand Total #808000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 productLineGroup productLineGroup/PRODUCTLINE #808000 sans-serif 10pt bold #FFFFFF right PRODUCTLINE #808000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 false solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 0pt salesByDateCube PRODUCTLINE dimension["productLineGroup"]["PRODUCTLINE"] any year dimension["timeGroup"]["year"] any quarter dimension["timeGroup"]["quarter"] any revenue_timeGroup/year_productLineGroup/PRODUCTLINE measure["revenue"] float timeGroup/year productLineGroup/PRODUCTLINE sum revenue_productLineGroup/PRODUCTLINE measure["revenue"] float productLineGroup/PRODUCTLINE sum revenue measure["revenue"] float revenue_timeGroup/year measure["revenue"] float timeGroup/year sum revenue_timeGroup/quarter measure["revenue"] float timeGroup/quarter sum revenue_1 measure["revenue"] float sum