4 Replies Latest reply on Jan 25, 2013 6:11 PM by SriniVEERAVALLI

    Snowflake in OBIEE

      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 ?