[Mondrian] Degenerate dimensions and Aggregate tables

[Pedro Salgueiro]

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 
issue?
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
>