Pre-aggregate, Post-aggregate, and Ranking Conditions

Pre-aggregate conditions are applied to the detail rows of the table, whereas post-aggregate conditions are applied to the data in the summary rows of the table. (Pre-aggregate conditions are equivalent to conditions defined in the 'Where' clause of the SQL statement, and post-aggregate conditions are equivalent to conditions specified in the 'Having' clause of the SQL statement.) Ranking conditions specify the Top N or Bottom N number of rows that should be presented in the table. See Filtering Operators for information about the filtering options.

Example: Defining Advanced Conditions  >>

Say that you want to view the sales information of only the top three product categories in the table that you created in the previous section, Defining Simple Conditions.

1. Press the 'Condition' button located in the upper right corner of the table's title bar. This opens the 'Conditions' dialog box.

2. Click on the 'Advanced Conditions' check box. Notice that the condition added to the 'Total Sales' field is included in the 'Pre-aggregate' conditions list.

 

3. Click on the 'Edit' button for the 'Ranking Conditions' and click on the 'More' button.

4. From the drop-down list, select 'Total Sales'.

A Variable value can be used as the rank­ing condition value by selecting 'variable' from the drop-down list to the right of the value text box and specifying the param­eter name in the text box. See Creating a Variable for more information.

5. Ensure that the ranking operation is set to 'top' and specify “3” as the value.

 

6. Click on the 'OK' button to go back to the 'Conditions' dialog.

7. Click on the 'OK' button to apply all of the conditions to the table.

8. Preview the table. Data for only the top three categories, based on the 'Total Sales' value, is listed.

 

 

<< 6.2.2 Defining Advanced Conditions © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2.3 Defining a Materialized View Update Condition >>