[Mondrian] Degenerate dimensions and Aggregate tables

Pedro Alves pmgalves at gmail.com
Thu Aug 23 12:50:42 EDT 2012


Afaik, that issue still holds



On Thu 23 Aug 2012 05:47:22 PM WEST, Pedro Salgueiro wrote:
> Greetings!
>
> The cube we are using contains a very simple degenerate dimension
> which only have a single level. We are using this degenerate dimension
> in all our queries and it's not practical to create a fact table for
> this dimension since it would be hard to maintain.
>
> Some of our queries are getting very heavy and we are now starting to
> experiment the use of Aggregate Tables, trying to speed-up these
> queries. After the creating a couple of simple aggregate tables that
> cover some simple MDX queries, we got to the conclusion that if using
> the degenerate dimension in the MDX, mondrian does not uses the
> aggregate tables, otherwise it uses the right aggregate table.
>
> After googling about the problem, we saw a couple of opened mondrian
> issues related to this problem, where Mondrian seems unable to
> recognize degenerate dimension in aggregate tables, completely
> ignoring them:
>
>     http://jira.pentaho.com/browse/MONDRIAN-563
>     http://forums.pentaho.com/showthread.php?47852-Degenerate-Dimensions-and-Aggregate-Tables
>     http://lists.pentaho.org/pipermail/mondrian/2007-March/000281.html
>
>
> Is this still an open issue in Mondrian?
> If so, any hint on how to approach the problem and try to solve it?
>
> Cheers,
> Pedro Salgueiro
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian


More information about the Mondrian mailing list