
Chapter 3. Building a cube model in DB2 101
Specify the name of the Dimension object, including the schema name under
which it needs to be created (see Figure 3-33).
As an example, we will create a
Time dimension based on the relational table
DATE.
Figure 3-33 Provide name of dimension object
Click Next to move to the next screen.
Note: The context menu option on a dimension named Remove removes the
dimension information from only the cube model. However, the dimension
object still remains available in “All Dimensions”. The “Drop” option removes
the dimension information, including hierarchies created, from both the cube
model and “All Dimensions”. ...