
86 DB2 Cube Views: A Primer
Study the usage:
– Types of accesses to the cube model, like drill through, extraction, ad-hoc
reports, and drill down.
– Type of dimensional model: MOLAP, ROLAP, or HOLAP. This may be
used to determine if you require to have a single cube model with one or
several cubes.
– Identify business names for the columns from the relational tables for
better understanding of data for the users.
The designer can then proceed to build the cube model.
3.3.2 Preparing the DB2 relational database for DB2 Cube Views
Setting up the database to be used with DB2 Cube Views includes:
Registering the DB2 Cube Views stored procedure with ...