[Mondrian] Problem with aggregate tables..
Ati Rosselet
ati.rosselet at gmail.com
Mon Oct 22 11:50:20 EDT 2007
>From delving into the Mondrian code, it appears to have something to do with
the following:
findTableWithLeftJoinCondition in RolapStar.java (called from
AggTableManager.java:483) ..there is also a findTableWithLeftCondition
which seems to be identical.. and unused.. btw.. anyhow.. if there is a
column in the Star (here pillangoperiodid) that maps to more than one
dimension/hierarchy.. this function returns only the FIRST match...(creating
only one usage entry) leaving all other matching dimensions/hierarchies out
in the cold. I assume there is more to this.. and will keep digging...
I'm guessing it may be a combination of this with the subsequent agg
matching (maybe again only checking for first somewhere?)
Cheers
Ati
On 10/18/07, Julian Hyde <julianhyde at speakeasy.net> wrote:
>
> Can you clarify? Period and Period2 are based on the same dimension
> table, with the same primary key, and the same foreign key from the fact
> table?
>
> At this point, it sounds like a bug in the aggregate table recognizer
> algorithm. There may be a bug logged already. If you can convert into
> a testcase on the foodmart schema that would help.
>
> Julian
>
> <http://lists.pentaho.org/mailman/listinfo/mondrian>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071022/a4492f85/attachment.html
More information about the Mondrian
mailing list