topic Re: How to handle multiple fact tables in QlikView

How to handle multiple fact tables

Anonymous — Wed, 22 Jul 2015 12:39:18 GMT

Hi All,

I am bit weak in handling multiple fact tables with different levels of granularity .Please share some examples how to deal.

Thanks,

R.Rand

Re: How to handle multiple fact tables

Gysbert_Wassenaar — Wed, 22 Jul 2015 12:47:15 GMT

See this blog post: Fact Table with Mixed Granularity

Re: How to handle multiple fact tables

Kushal_Chawda — Wed, 22 Jul 2015 12:47:44 GMT

You can either concatenate fact tables or you can create Link table based on the scenarios.

Please find the below link for better understanding of both approach

http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Re: How to handle multiple fact tables

manojkulkarni — Wed, 22 Jul 2015 12:55:16 GMT

You can concatenate both the tables into a single fact table. If you provide some sample data then it will be easy to suggest the better approach.

Re: How to handle multiple fact tables

Anonymous — Wed, 22 Jul 2015 13:20:23 GMT

I have 8 fact tables .Is it advisable to concatenate even at different levels of granularity.

Re: How to handle multiple fact tables

sgrice — Wed, 22 Jul 2015 13:30:54 GMT

If they Share Dimensions but are at different levels of summary then Concatenate them together;

Load

'Detail' as Level,

from myDetailTable;

Concatenate

Load

'Summary' as Level,

from mySummaryTable;

Note that if you have a field that you sum and do not want to effect existing charts then load summary fields into different fields

I.e. SALES field is in both Detail and Summary. Then Rename the Summary on SUMofSALES. This way you can use either SUM(SALES) or SUM(SUMofSALES) and they will give you same answer.

You can also do nice things like SUM(SALES)/SUM(SUMofSALES) would give the % of the Sales by Summary Level.