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:
- Data models
- Databases within a data model
- Package objects within a logical data model
- Schemas
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:
- Right-click the object.
- Select Discover Facts and Dimensions from the menu that opens.
- 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.