How to handle multiple fact tables

[Anonymous]

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

[Gysbert_Wassenaar]

See this blog post: Fact Table with Mixed Granularity

[Kushal_Chawda]

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/

[manojkulkarni]

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.

[Anonymous]

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

[sgrice]

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.