Chapter 12. Accessing DB2 dimensional data using BusinessObjects 571
12.4 Reports and queries examples
To demonstrate how the MQTs built using DB2 Cube Views Optimization Advisor
improved BusinessObjects queries performance we used a simple business
Query1: Who are the most profitable consumers?
Query 2: What do they buy?
To check if the report query is optimized by DB2 Cube Views through the
Optimization Advisor, we used the following method:
1. In BusinessObjects, launch SQL Viewer from the Query Panel (see
Figure 12-30), and copy the SQL statement.
Figure 12-30 Get the SQL statement from SQL Viewer
2. In DB2 Control Center, launch Explain SQL Panel, and paste the SQL