Conformed Dimensions & 6 Fact tables - Loops issue

building semantic layer
1

I have got around 4 dimension tables, I have measures distributed in 6 fact tables.
Since I have 6 Fact tables, I have to connect all of them with the 4 dimension tables.
All my 4 dimension tables are confirmed dimension tables. When I check the loops, it says there are around 10 loops. This is not good. How can I fix this ?

Any help is highly appreciated.

shyamhr (BOB member since 2011-12-15)

2

Hi,

Use contexts. Since you have 6 fact tables, you should have 6 contexts in the universe.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Confirmed should read conformed, btw :).

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