Joins to Detail level Facts and Aggregate Fact tables

[#1]

I have 2 aggregate fact tables and 2 detail level fact tables. There are several dimension tables to be joined to all these 4 fact tables. Reports need metrics from any fact table to be computed against any of the dimension attributes. How do I create a data schema so I can avoid synthetic joins and data from all facts can be accessed in a single report.

Thank You.

[stephencredmond]

Hi,

Often I will just concatenate all the Fact tables. For example, if I have 2 fact tables like this:

DimKey1 DimKey2 Fact1
K1.1 K2.1 100
K1.2 K2.2 200

DimKey1 DimKey2 DimKey3 Fact2 Fact3
K1.1 K2.1 K3.1 100 300
K1.2 K2.2 K3.2 200 400

If you concatenate them then you get something like this:

DimKey1 DimKey2 DimKey3 Fact1 Fact2 Fact3
K1.1 K2.1 100
K1.2 K2.2 200
K1.1 K2.1 K3.1 100 300
K1.2 K2.2 K3.2 200 400

Which will allow you to create sums (the nulls are ignored) and avoid synthetic keys.

Regards,

Stephen

[#3]

Hi,

Have a look at this discussion about linktables:

http://community.qlik.com/forums/p/15825/61487.aspx

Regards,

Martijn ter Schegget