You are viewing a single comment's thread. Return to all comments →

Thanks Aldo.

Can you please relate this to the actual problem and help me to understand how it comes to the solution D (4,7,3,84,160,117).

Appreciate your time..

No problem, sorry for the late reply. The tuple must satisfy the equation :

a,b,c,

/* 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.

Hello Aldo,

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)

## OLAP Operation Types

You are viewing a single comment's thread. Return to all comments →

Thanks Aldo.

Can you please relate this to the actual problem and help me to understand how it comes to the solution D (4,7,3,84,160,117).

Appreciate your time..

No problem, sorry for the late reply. The tuple must satisfy the equation :

a,b,c,

/* 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.

Hello Aldo,

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)