topic Re: Multiple Fact Tables Sharing Common and Different Dimensions in QlikView

Multiple Fact Tables Sharing Common and Different Dimensions

Wed, 25 Nov 2020 16:16:04 GMT

Hi QlikView Experts,

I am stuck in the data modelling process. I have four fact tables. All share the same two dimensions (e.g. Dim1 and Dim2).

Moreover two fact tables share two dimensions (e.g. Dim3 and Dim4) which doesn't exist in the other two fact tables.

Following the two approaches I've tested. The first one works (because I want to do a selection for "Special_ID" in Fact1) but QlikView creates a synthetic key and I don't know how to avoid this.

For the second approach I've used generic keys, but can't do selections for the "Special_ID" :-(.

Should I live with the synthetic key from the first approach or do you have any ideas how best to solve this.

Many thanks in advance!

Re: Multiple Fact Tables Sharing Common and Different Dimensions

oscar_ortiz — Mon, 02 Oct 2017 17:45:43 GMT

Sven,

You may want to check out a couple of articles written by hic‌.

Fact Table with Mixed Granularity

Generic keys

Good luck

Oscar

Re: Multiple Fact Tables Sharing Common and Different Dimensions

hic — Tue, 03 Oct 2017 05:52:04 GMT

I would probably concatenate all four fact tables into one long table. This would result in a solution that is more efficient than one with a link table.

HIC

Re: Multiple Fact Tables Sharing Common and Different Dimensions

Fri, 06 Oct 2017 20:48:10 GMT

Thank you both for your responses,

but after concatenating the tables some of my calculations within the diagramms don't work anymore ;-(.

Best regards

Sven

Re: Multiple Fact Tables Sharing Common and Different Dimensions

Shubham_D — Thu, 08 Apr 2021 15:56:20 GMT

So can we say that link table architecture is a Star Schema ?