[Mondrian] Aggregate tables and distinct-count
Pedro Alves
pmgalves at gmail.com
Mon Jan 14 12:17:55 EST 2013
The agg has one single (non-collapsed) level, and this is a star schema.
Could I get into troubles?
On 01/14/2013 05:14 PM, Luc Boudreau wrote:
> Be careful with the non-collapsed dimensions. This feature needs the
> tables to be in a snowflake form. If the dimension table is a single
> table and you join on the non-last level, you will get a cartesian product.
>
> Luc
>
> On Mon, Jan 14, 2013 at 12:04 PM, Pedro Alves <pmgalves at gmail.com
> <mailto:pmgalves at gmail.com>> wrote:
>
>
>
> IT IS WORKING!
>
>
> However, I had to skip the first level of a hierarchy, marking the
> second level as collapsed= false.. something I've never used before and
> seems to be exactly for this :p
>
>
>
> -pedro
>
>
>
>
> On 01/14/2013 05:01 PM, Julian Hyde wrote:
> > 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
> <mailto: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 <mailto:Mondrian at pentaho.org>
> >> http://lists.pentaho.org/mailman/listinfo/mondrian
> >
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
More information about the Mondrian
mailing list