Choosing the schema for Universe is based on underlying datawarehouse schema design ? especially if it has to be snowflake Universe ?
since In Snowflake Schema each level of a hierarchy is stored in a separate table by normalizing the dimension table.
For example If i have 'Location' dim table and 'Territory ' info in another dim table and i have a report requirement that wants sales for different territory with locations , i will have to build a snowflake schema Universe ? (I cannot possibly chose star schema here right !)
The only way to design Star schema by denormalizing i.e not have a seperate table for Territory breakdown ? which will be ETL or Database design aspect ?
I am trying to understand if there is any other specific reporting requirements that make me choose snowflake design or if has everything to do with how the data is stored in my Database.
Any , insights greatly appreciated.