SAP BusinessObjects BI 4.0 The Complete Reference 3/E

Measure Conditions with Aggregate Functions

When you place a condition on a measure object that uses an aggregate function, Web Intelligence does not generate a WHERE clause, but instead generates a HAVING clause. The RDBMS first performs the aggregations and GROUP BY, and then returns only those results that satisfy the HAVING condition. In the following example, the query returns rows for which the SUM of SHOP_FACTS.MARGIN is less than or equal to 0.

The problem here is that many users are deceived into thinking this is a simple query, as it ...