[Mondrian] Degenerate dimensions and Aggregate tables

Pedro Salgueiro pedro.salgueiro at inductiva.pt
Fri Aug 24 04:55:44 EDT 2012

You are right, haven't thought about it those terms, if we are able to 
maintain the aggregate table, we can also manage this small dimension.

We will try switching to a real dimension, probably based on view.

BTW, any idea on where to start digging to try to debug and solve this 
Pedro Salgueiro

On 08/23/2012 06:35 PM, Julian Hyde wrote:
>> On Thu 23 Aug 2012 05:47:22 PM WEST, Pedro Salgueiro wrote:
>>> 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.
> Does not compute. You can maintain an agg table but not a dimension table? Why not make the dimension table a view on the agg table?
>>>     http://jira.pentaho.com/browse/MONDRIAN-563
> On Aug 23, 2012, at 9:50 AM, Pedro Alves <pmgalves at gmail.com> wrote:
>> Afaik, that issue still holds
> I believe so, too.
> Vote for the jira case.
> Workaround to try: Create a real dimension table (which will have a small number of rows). Consider using a junk dimension -- I haven't tried these, though.
> Julian
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

More information about the Mondrian mailing list