# OBIEE - Dimension (Logical Table)

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