Regarding Link Tables between 2 fact tables

[pauljohansson]

Hi,

When you read about how to create a link table between 2 fact tables i have on several places(for example in book "Qlikview Developer 11" page 289) been told that i should identify the common fields between my fact tables and create one %Key field.

But, lets say that i use the respective %Primary Key field from each fact table.  Why should this not be possibly, or am i missing out something here? Do I always need to use the same %Key field for my two seperate fact tables?

Attached is a data model where i use the fact table respective primary key.

Comments and thoughts are welcome,

br

Paul

[pauljohansson]

Yes, without internal relationships in the LinkTable there wont be much of linking

My thinking goes like this:

if i keep all my dimension fields in the link table, i need to make sure that my fact table is linked to the link table with the "primary key". Otherwise i might risk that some of my facts wont  be "accessible" (since I with all my dimensions in the LinkTable always "start" my analysis from there).