Designing snowflake in OBIEE repository.
Hi everybody,
I am a beginner and I have a question about designing snowflake in the OBIEE repository.
I have a Fact table and 6 dimension tables
The joins are something like this
Dim B --> Fact A
Dim C --> Fact A
Dim D --> Fact A
Dim E --> Fact A
Dim F --> Dim E
So the Dim E is snowflake to Dim F. The joins are pretty straighforward.
I would like to know the best way to design these tables in the OBIEE repository. My first idea is to create a view in my Oracle database of Dim F and Dim E in order to link these two tables directly to Fact A. Would it be a good idea performance wise ? If not, what would be a better design ?
Many thanks !
Chiwatel.