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}.
Articles Related
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).