Skip to main content

Qlik

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
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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

8,777 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

243 Views
0 Likes