Chapter 7. Accessing dimensional data in DB2 using QMF for Windows 263
Figure 7-18 Slices of the product dimension
Drill through
Drill through refers to a specific analytical OLAP technique of switch from a cube
(multidimensional data model) to the primary relational data. Since QMF for
Windows is a complete relational query and reporting tool, the underlying
relational tables that develop the cube can be accessed and viewed as in
Figure7-19.
Figure 7-19 Portion of CONSUMER table from a relational view
7.5 OLAP report examples and benefits
In order to support multidimensional data via DB2 Cube Views, QMF for
Windows v7.2f provides users with th ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.