4 Replies Latest reply: Jan 25, 2013 12:11 PM by Srini VEERAVALLI RSS

    Snowflake in OBIEE

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