Design one universe vs two universe....need opinion

[Former Member]

Hi

Data warehouse consist of 2 Fact table F1 and F2 and 8 dimensions(3 common dimension tables and 5 others).

Fact table F1 and F2 in warehouse have three common dimension table.

I need opinion about how to arrange universe for this data warehouse.

Report consist of measure from both fact tables.

What will be right way : -

1. create two separte universe - one for each fact table.

2. use single universe and use alias for common dimension.

3. use single universe ans use context.

Regards

[Former Member · Accepted solution]

Hi,

Creating Two Universes will be worst option I guess because it will be more or same like the option 2 you have mentioned. But creating 2 universes will increase the overhead of maintaining two universes.

From option 2 and option 3 you can select any one for such a requirement. I guess the performance of both will be the same.

The Advantage of option two will be that it will never asks for selecting context at run time, such situation might be possible in option 3.

Also, option 2 will take less time to develop as you may not find any loops.

Regards,

Rohit