[Mondrian] Order by OrderKey

Julian Hyde jhyde at pentaho.com
Wed Oct 9 14:26:31 EDT 2013


On Oct 8, 2013, at 7:33 AM, Matt Campbell <mcampbell at pentaho.com> wrote:

> Regarding non-deterministic ordering of members:  if I'm reading you correctly hierarchical sort order should still be deterministic, correct?  There are some tests which currently fail the assertion in compareHierarchically because two different members result in a compare of 0.  For example testBug1438285() defines ordinalColumn=region_id for [Store Id], which is non-unique under the same parent for some members.

We don't recommend it, but we allow people to define an order key that is not unique among siblings of the same parent. (We might even allow two siblings to have the same name.)

Aside from that, hierarchical sort order should be deterministic.

Julian



More information about the Mondrian mailing list