13. A computer program product comprising a non-transitory computer-readable medium further comprising: computer-readable code for receiving a query having a select list, a from element, and a summary filter having a filter condition; computer-readable code for analyzing the filter condition to determine a filter group of the filter condition, the filter group comprising a list of expressions over which the filter condition is computed; computer-readable code for creating a derived table for computing the filter condition, the derived table having a select list, creating the derived table comprising: adding the list of expressions of the filter group to the derived table as one or more columns of the derived table's select list; and adding the filter condition to the derived table as a one or more columns of the derived table's select list; computer-readable code for transforming the received query by combining the received query with the derived table, transforming the received query comprising: traversing the select list of the received query and transforming one or more aggregates of the select list to reference one or more of the columns of the derived table; transforming the from element of the received query to reference the derived table; and adding a WHERE clause to the transformed original query, the WHERE clause based on the filter condition and referencing one or more of the columns of the derived table.
13. A computer program product comprising a non-transitory computer-readable medium further comprising: computer-readable code for receiving a query having a select list, a from element, and a summary filter having a filter condition; computer-readable code for analyzing the filter condition to determine a filter group of the filter condition, the filter group comprising a list of expressions over which the filter condition is computed; computer-readable code for creating a derived table for computing the filter condition, the derived table having a select list, creating the derived table comprising: adding the list of expressions of the filter group to the derived table as one or more columns of the derived table's select list; and adding the filter condition to the derived table as a one or more columns of the derived table's select list; computer-readable code for transforming the received query by combining the received query with the derived table, transforming the received query comprising: traversing the select list of the received query and transforming one or more aggregates of the select list to reference one or more of the columns of the derived table; transforming the from element of the received query to reference the derived table; and adding a WHERE clause to the transformed original query, the WHERE clause based on the filter condition and referencing one or more of the columns of the derived table. 14. The computer program product as claimed in claim 13 , the creating the derived table further comprising: identifying aggregates in the select list of the received query having PREFILTER clause; adding the identified PREFILTER aggregates from the select list of the received query to the select list of the derived table; and replacing the PREFILTER aggregates in the select list of the received query with a reference to the added PREFILTER aggregate in the derived table.