How to avoid synthetic table creation and circular references.

[#1]

Hi everyone ,

If I have 2 fact tables that need to be connected to two same dimensions. In this scenario how can I avoid creation of synthetic tables and circular references.

Thanks.

[#2]

use concatenate instead. join both into one fact table.

[#3]

Hi,

you can make Link table to connect tables. In it you need to have Fact1 key, Fact 2 key, Dimension 1 Key and Dimension 2 Key. Also you need to delete Dimension 1 Key and Dimension 2 Key from Fact tables.

EDIT: You can see that http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Best,

Yani

[#4]

As datulkim have said, join the tables. Then you can add a flag field to identify to which dimension each record belongs.

[#5]

Hi,

You can use the 'Qualify' in the tables!

Rebeca