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

• OBIEE 10G/11G - Dimension Hierarchy (logical dimensions)
• OBIEE - Identifying a Dimension Table
• OBIEE - Data Navigation (Drill Down, Through, Link, )
• OBIEE - Time Series Conversion Functions : AGO and TODATE
• OBIEE 10G/11G - How to set up the time dimension (for time series functions Ago, Todate, ) ?

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

• Conformed and Non-Conformed Dimensions errors out - Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request