How to connect 3 fact tables without concatenating any fact table

[farheenayesha]

Hi,

I want to create a linktable which connects 3 fact table and one Master calender. I dont want to concatenate two tables Quote and Opportunities though there are many common fields.It would be great if anyone could tell me how i can do this. Please find the data model below:

[#2]

See this excellent post by HIC:

http://community.qlik.com/docs/DOC-3451

Fabrice

[juleshartley]

I would strip the common dimension fields out into a dimension table, and then link them to the fact tables (opportunity and quotes).

QlikView handles it better (and the model is simpler) if you were to concatenate the fact tables, otherwise you have to ensure they have sepearte keys etc, to avoid circular relationships. Confusion is avoided through clearly named fields.