Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Data Model Linking Problem!!!

I have 4 Facts and 3 dimension table.
I have made a link table to link these fact table.
Now the problem is, I have made link key from 3 fields in first 3 facts. But in the fourth Fact table I have only one field out of these 3 fields, So how should I link my fourth Fact table to the Link Table. Or which approach should I follow in linking my fourth Fact table to the model.

I have linked all my Dimension table to my link table
I am explained in the diagram below:

Linking Problem.png


Please suggest me the best approach for linking my last Fact Table to the model.

6 Replies
Highlighted

Re: Data Model Linking Problem!!!

Create a LinkTable at the center of your current model. The LinkTable will match all Full Link Keys to Link keys that only have Dimension 1 values. This way you're matching keys with a high granularity (for example, Order Date values) to corresponding keys with low granularity (for example Budget MonthYear values)

Make sure that the LinkTable contains all key combinations from all connected facts tables. To avoid creating one facts table that filters all the others, move Dimension 1, Dimension 2 and Dimension 3 to the LinkTable as well.

Best,

Peter

Highlighted
Valued Contributor

Re: Data Model Linking Problem!!!

Hi,

Does the 4th fact table can be joined with the big fact table?

The best way for this case, should be first check how to join or concatenate the facts tables, then add Link Keys.

Zhihong

Highlighted
Not applicable

Re: Data Model Linking Problem!!!

The central table is Link table. I forgot to name it.
See the changed.

Linking Problem New.png

Now suggest me the best way for linking Data model.

Highlighted
Not applicable

Re: Data Model Linking Problem!!!

No the 4th fact table cannot be joined to central big fact table as it has dimension key of only one dimension table.
This is the problem. Now how should I link 4th fact table which has only Dim 3 key.

Highlighted
Not applicable

Re: Data Model Linking Problem!!!

Please somebody solve the model.

Highlighted
Valued Contributor

Re: Data Model Linking Problem!!!

Hi,

In this case, then you must first join the first 3 fact tables  with a link key to get a big fact table, and then link the 4th fact table directly to the big fact table. See the model link as in the attached file.