Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
With my limited experience with QlikView, I see not indication of how to handle the following commonly occuring situation in data warehousing.
The data warehouse has two facts, both of differing granularities. Say one is the sales fact, with time and product as the dimensions. The other is the budget fact, with time and cost center as the dimensions. Thus, there is a many-to-many relationship between the two facts.
If I bring metrics from the two facts into one document, with time, product, and cost center as the three dimensional tables, given the simple way the data is joined, there will be cartesian products across the sales fact and the budget fact, because of the non-conforming dimensions across. This will cause double counting (or multiple counting) to occur when simple metrics such as sum(sales) are created.
How does one handle this? Or can this situation not be easily handled? I.e., does the modeling only work for single facts or conformed facts? (i.e., multiple facts with the same dimensions and granularities across, or simple 1:N granularities).
One way you would achieve it by using Link Table method.
There is very nice presentation Natural Synergies people have put together explaining the same. HAve a look: http://www.naturalsynergies.com/LinkTable85_Qonnections.ppt