Creating a reference dimension

To hold the reference structures and templates relating to a specific business dimension, you need to create a reference dimension. The reference dimensions form the dimensional framework, which is used for providing information when merging data and delivering dimension data into data marts.
About this task

A reference dimension can contain hierarchies, auto-level hierarchies, and lookups.

To create a reference dimension:
  1. Start IBM® Rational® Data Manager and load the extract, transform, and load (ETL) catalog.
  2. Expand the catalog, click the Library node, right-click Dimensions and click Insert Reference Dimension.
  3. Type a name.
    Note: Business name and description are optional.
  4. If the dimension is based on time, select Dimension Represents Time.
  5. Click OK.

Feedback