You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When the fact table is sparse (There are no facts for some dimension points) drilldown results do not contain the aggregates corresponding to dimension points which are not represented in fact table rows. (Those aggregations want to be represented as zeros)
Outer join the dimension table or the "detail method" will work but there is another problem. When there is a cut from another dimension these aggregates are missing again. (Due to WHERE condition rows added by outer join are ruled out because other columns are empty.)
Appropriate suggestion is to change cut parameters to Join condition ( for example a.dateid=b.id and b.product='PIZZA')
To implement this in a general way is hard. However it is better if we have this feature at least for time role. All cuts except time cuts come into the join condition and time cuts are in the where condition.
The text was updated successfully, but these errors were encountered:
When the fact table is sparse (There are no facts for some dimension points) drilldown results do not contain the aggregates corresponding to dimension points which are not represented in fact table rows. (Those aggregations want to be represented as zeros)
Outer join the dimension table or the "detail method" will work but there is another problem. When there is a cut from another dimension these aggregates are missing again. (Due to WHERE condition rows added by outer join are ruled out because other columns are empty.)
Appropriate suggestion is to change cut parameters to Join condition ( for example a.dateid=b.id and b.product='PIZZA')
To implement this in a general way is hard. However it is better if we have this feature at least for time role. All cuts except time cuts come into the join condition and time cuts are in the where condition.
The text was updated successfully, but these errors were encountered: