Skip to content

Opening book details…

About this document

Dimensional Modeling in OBIEE Explained by magalilais is a document available to read on EtoBox.

The document discusses dimensional modeling in OBIEE, noting that while it may seem complex, any normalized data model can be transformed into a dimensional model. It presents an algorithm for deriving dimensional models from ER models in 4 steps: classifying entities, designing a high-level star schema, designing fact tables, and designing dimension tables. It also addresses complex cases that may be encountered, such as subtypes/supertypes, recursive relationships, and multi-valued dependencies, and how t

Author
magalilais
Language
EN