This discussion is archived
4 Replies Latest reply: Jan 25, 2013 10:11 AM by Srini VEERAVALLI RSS

Snowflake in OBIEE

Chiwatel Newbie
Currently Being Moderated
Hello All,

I have a snowflake in my database schema and I am looking for the best way to design it.

The first idea is to create a Materialized View and join this view in the physical layer (in order to leverage star query transformation) with my Fact table and then in the OBIEE BMM layer join the MW to the fact table to form a star schema.

Is there any issues with this approach ?

Thanks,

Chiwatel.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points