Need opinion... one universe or two separate universe

building semantic layer
1

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

GBS74 (BOB member since 2007-01-23)

2

Choices 1 and 3 work for me, I have used both.

As the reports are using both facts then they must be part of the same business process / functional area.

If they are largely to be used in this combined way, then I would go for option 3.

This prevents your users having to join so many queries at the report side :).

Mak 1 :uk: (BOB member since 2005-01-06)

3

Clearly number 3.

Andreas :de: (BOB member since 2002-06-20)

4

Agree with Andreas.

Not sure why you want to alias common dimensions for what appears to be the sake of it, or rather a lack of understanding.

Alias tables when they mean different things, e.g. alias Dim_Date for it to represent sales date, purchase date and invoice date.

If Dim_Product has the same meaning across all tables, there’s no point in aliasing it. Aliases are geared to creating the correct objects with the correct business meaning. Hope that clears it up for you.

Regards,
Mark

5

Definitely number 3 for me too.

Understandability and ease of use by your end users should be high on your priority list.

SandiR :uk: (BOB member since 2004-12-20)

6

Its a simple and small universe go for a single universe and use alias to reolve loops and define context for each fact.

Rakesh_K :india: (BOB member since 2007-12-11)