Shared dimensions

Typically, dimension tables that are shared by multiple fact tables (or multiple dimensional models) are called shared dimensions.

If shared dimensions already exist for any of the dimensions in the data warehouse or dimensional model, you should use the shared dimensions. If you are developing new dimensions that may be used across the entire enterprise warehouse, you should develop a design that anticipates the needs of the enterprise warehouse. In order to find out the anticipated warehouse needs, you might need to interact with several business processes to find out how they would define the dimensions.

In the workbench, shared dimensions use the following icon: Shared dimension icon


Feedback