OBIEE - Dimension (Logical Table)

About

A dimension logical table is typically joined to a fact logical table that will contain measures.

Every logical dimension table should have a dimensional hierarchy associated with it. This rule holds true even if the hierarchy has only one level, such as a scenario dimension {actual, forecast, plan}.

Tips

  • Separate mini-dimensions from large dimensions as different logical tables – keeping options open on deleting large dimensions
  • If multiple calendars and time comparisons for both are required (e.g. fiscal and gregorian), then consider separating them into different logical dimension tables – simplifies calendar table construction
  • Each dimension logical table must correspond to one and only one dimension object.

Glossary: conformed dimension

A conformed dimension is a dimension that have relationships with many fact tables (not only one).

Documentation / Reference


Powered by ComboStrap