Cube views definitions

The Schema Generator creates a DB2® Cube Views™ XML file. The database administrator (DBA) imports this XML file into the DB2 OLAP Center.

The Schema Generator generates a Cube Views XML file based on a business measures model. The business measures model contains information that helps to describe measures and dimensions. You can also describe what aggregations can be applied to the measures.

For each process in the business measures model, a cube and a cube model are created. As well, a cube and a cube model are generated for the activities associated with a process. Each cube model and cube contain some predefined measures and dimensions that are generated automatically.

Each cube model and cube contain three built-in measures:
The following dimensions are automatically generated: These time-based dimensions use a commonly defined dimension that is provided (DIM_TIME). It has three predefined levels: year, month, and day.

At modeling time, you can define your own business measures. The business measures that are created can be measures or dimensions. The WebSphere® Business Modeler documentation describes in detail how to use the WebSphere Business Modeler to create measures or dimensions.

For further information on DB2 Cube Views, refer to the DB2 documentation.

Related concepts
DB2 Cube Views metadata
Related tasks
Deploying Cube Views database schema on the Windows platform
Deploying Cube Views database schema on the AIX platform
Creating ABX cubes manually
Deploying Cube Views database schema

Copyright IBM Corporation 2005. All Rights Reserved.