This content has been marked as final. Show 4 replies
You can try the below approach.
Check this for a simple example,
I have a snowflake in my physical layer (so in my database schema) and the goal is to design it on the BMM Layer in OBIEE as I know that OBIEE wants star schema in the BMM Layer.
So for simplicity, I was wondering if creating a Materialized View will do it ?
You can go with Materialized view as you said.1 person found this helpful
We can design in BMM such way that you get only star schema that can be by LTS or for a source physically mapping other tables as said in links.
Dimensions with extensions we go for LTS and other cases like normalised we map them.
Hope this helps, if helps mark
Edited by: Srini VEERAVALLI on Jan 25, 2013 12:11 PM