Task 3: In this procedure, build a data set to indicate what data to retrieve from various tables in the database.
Data Set Type specifies that the data set uses a SQL SELECT query to retrieve the data.
4 In New Data Set—Query, type the following SQL SELECT statement to retrieve the revenue and total of items sold for each country:SUM(CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH) as SALES,WHERE CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = CLASSICMODELS.ORDERS.CUSTOMERNUMBERAND CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBERHAVING SUM(CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH) > 200000
5 Choose Finish to save the data set. Edit Data Set displays the columns specified in the query, and provides options for editing the data set.
6 Choose Preview Results. Figure 18-21 shows the data rows that the data set returns.
Figure 18-21
|
|
Copyright Actuate Corporation 2012 |