Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Snowflake in OBIEE

ChiwatelJan 25 2013 — edited Jan 25 2013
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2013
Added on Jan 25 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
2,352 views