About Aggregates
Two forms of aggregates are involved in measure objects: SQL functions and projection aggregates. Users can create a third aggregate called calculations within individual reports.
SQL Aggregates
SQL aggregates—such as SUM, MIN, and MAX—require a GROUP BY clause that the query engine automatically includes in each SQL statement.
Refer back to Figure 7-2. The sample fact table contains 23 rows of data. If a user selects debits and credits without the SQL SUM function, the report will display 23 rows. If the object uses the SUM function and requests only debit and credits by day, SQL will group the debits and credits for each day.
For example, there are four detail entries for September 12, 2011, in Figure 7-2. With the SUM function, ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
