[Mondrian] parent child hierarchies
jhyde at pentaho.com
Tue Apr 2 14:19:20 EDT 2013
Sounds like good general advice. Thanks for letting us know.
Please log a case. I don't see any reason why, say, VARCHAR columns couldn't be used as key columns for parent-child hierarchies and their closure tables, but I can believe there is a bug.
On Apr 2, 2013, at 9:10 AM, Paul Stoellberger <p.stoellberger at gmail.com> wrote:
> Because I just lost almost half a day on this:
> Can we add a note in the documentation that when using parent child hierarchies and closure tables, it is mandatory to use numeric keys - otherwise the whole thing will just blow up in your face
> I ended up getting arbitrary hierarchies because the order by clause etc. was actually necessary to compute a correct parent child hierarchy.
> And ordering on string values seem to produce a different result than ordering numeric values.
> I only changed that and suddenly my PC hierarchies work correctly.
> And if thats still an issue in mondrian 4 - please add it to the book :-)
> Mondrian mailing list
> Mondrian at pentaho.org
More information about the Mondrian