OBIEE - Dimension (Logical Table)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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}.


3 - 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.

4 - Glossary: conformed dimension

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

5 - Documentation / Reference