
228 DB2 Cube Views: A Primer
6.3 Accessing OLAP metadata and data in DB2
Using Office Connect to access multidimensional metadata and data in DB2 is
illustrated in the following sections.
The process flow is represented in Figure 6-2.
Figure 6-2 Process flow chart for Office Connect
6.3.1 Prepare metadata
First, the relational database in DB2 that is being used as the data source must
be prepared for DB2 Cube Views (see 3.3.2, “Preparing the DB2 relational
database for DB2 Cube Views” on page 86)
Second, a cube model needs to be created in DB2 Cube views. Office Connect is
designed to work with only DB2 Cube Views cubes. Therefore, cubes (a subset ...