You are viewing a single comment's thread. Return to all comments →
No problem, sorry for the late reply.
The tuple must satisfy the equation :
/* Aggregation number of rows */ a*b*c,
/* Cube number of rows */ a*b*c+a*b+b*c+a*c+a+b+c+1,
/* Rollup number of rows */ a*b*c+a+a*b+1
And only one answers satisfies this.
This is really helpful to understand,However I have one question about Rollup tuples count:-
Intstead of a*b*c+a+a*b+1,it should be ,a*b*c+a+b+c+1
I think it goes from smaller combination to bigger, like this:
/* Aggregation */ (a*b*c),
/* Cube */ 1+a+b+c+(a*b)+(b*c)+(c*a)+(a*b*c),
/* Rollup */ 1+a+(a*b)+(a*b*c)