Discovering the facts and dimensions in a dimensional model

Use the workbench to discover the facts and dimensions of a dimensional-physical or dimensional-logical data model. You can also automatically generate a hierarchy for each dimension that is discovered.

Before you begin

You must enable dimensional notation on an existing dimensional data model before you can discover the facts and dimensions.

About this task

You can discover the facts and dimensions of the following objects:
Note: By default, the workbench does not overwrite the dimensional notation that you assign to your data objects. You can discover the facts and dimensions periodically to keep the model and dimensional notation synchronized. You can change this default setting in the Dimensional Preferences page.

Procedure

To discover the facts and dimensions of objects in a dimensional model:

  1. Right-click the object.
  2. Select Discover Facts and Dimensions from the menu that opens.
  3. Optional: If you want to automatically generate a hierarchy for each dimension that is discovered, click Yes when you are prompted to generate the hierarchy. If you select No, a hierarchy is not generated within the dimensions that are discovered.

Feedback