Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this blog post: Fact Table with Mixed Granularity
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/
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.
I have 8 fact tables .Is it advisable to concatenate even at different levels of granularity.
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.