Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-06-12 05:55 AM

2 Fact tables share Dimension table at different granularity

Hi All

I have 2 fact tables containing data at different granularity (no option to concatenate).  They both use the same hierarchy dimension table but link to it at different points in the hierarchy, one links to the primary key, the other links in the middle of the hierarchy.  Do I have any choice but to create 2 dimension tables at different levels?

Thanks

9,578 Views
10 Replies
Not applicable
‎2014-06-12 11:03 AM
Author

In response to hic

Apologies for my bad explanatory skills. There is one other field in common with a similar issue of differing dimensionality.  So I would need the link table and key tables as per your Link table and multiple fact tables example, unless I concatenate.  Thanks

314 Views
0 Likes