Link table with different dimensions for different Facts

[#1]

Hello,

I am trying to find out if it is possible to create a link table which will have 2 Fact tables with similar dimensions and keys, while the third Fact will not have the same set of dimension keys. is it possible to create a separate composite key just to connect the fact2 and fact3? Or is it possible to use the same key created for the Fact1 and 2 for joining Fact3 as well.

Thanks.

[Oleg_Troyansky]

Yes, you can create a Link Table that connects different Facts with difference granularity levels. You will need to generate two Combo keys - one with all three common keys and another one with only the two common keys. Fact1 and Fact2 will be joined by the first key, while Fact3 will be joined by the second key.

I'm describing this kind of a data model with a lot of detail in my book QlikView Your Business.

cheers,

OlegTroyansky

[jampierre]

Hi Oleg,

could you please help me creating a link table.

Hi have:

T1:

ID_T

...

T2:

ID_A

ID_T

...

T3:

ID_R

ID_A

...

T4:

ID_R

ID_T

...

T5:

ID_R

I found big problems creating my Link Table.

I tried many times in different ways but no results.

Could you please help me

best regards

Giampiero

[federerman]

Oleg, can you go into a bit more detail on why two combo keys are necessary, as opposed to a single key?