556 DB2 Cube Views: A Primer
Figure 12-11 AVG aggregation example
The MAX aggregation becomes Inventory by Channel as in Figure 12-12.
Figure 12-12 MAX aggregation example
Chapter 12. Accessing DB2 dimensional data using BusinessObjects 557
The SUM aggregation becomes Inventory by other dimensions as in
Figure 12-13.
Figure 12-13 SUM aggregation example
The universe list includes the new measures as shown in Figure 12-14.
Figure 12-14 Universe result
558 DB2 Cube Views: A Primer
12.2.3 Data type conversion
BusinessObjects objects support four data types:
򐂰 Date
򐂰 Character
򐂰 Number
򐂰 Long text
Figure 12-15 lists the internal data types and their equivalent in BusinessObjects
Figure 12-15 Data types

Get DB2 Cube Views: A Primer now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.