[Mondrian] Aggregate tables and distinct-count
Julian Hyde
jhyde at pentaho.com
Mon Jan 14 12:01:10 EST 2013
yes, it should be used.
furthermore, mondrian knows that it is safe to roll up any attributes that are functionally dependent on the measure column. (e.g. if you have computed count(distinct customer_id), and you have in the agg table the distinct count for male and female customers in each state, you can compute the number of distinct customers in each state by adding the distinct males and females.)
Julian
On Jan 14, 2013, at 8:52 AM, Pedro Alves <pmgalves at gmail.com> wrote:
>
>
> I know we can't aggregate distinct-count measures like we do with the
> others.
>
> But if a query matches a specific aggregation table's bitkey,
> couldn't/shuoldn't it be used?
>
>
>
> -pedro
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
More information about the Mondrian
mailing list