Following picture is illustrating the effect of hierarchy dimension reduction.
It reduces the number of cuboid from 2^N to N+1
With this dimension reduction, I wonder how following queries could give correct answer?
- select B, count(1) from X group by B
- select C, count(1) from X group by C
- select B,C,count(1) from X group by B,C