[Mondrian] proposal for Order function with key specification list

[Julian Hyde]

I could support that change. I am not usually support extensions to MDX, but
this seems to be backwards compatible with SSAS and it is functionality
difficult to provide otherwise.

Like Zelaine, I would like to see some examples. 

I am not sure that we should allow sort by <Level>, because that can be
coerced into an expression. Is it not sufficient to sort by a member
expression, such as <Hierarchy>.CurrentMember or perhaps
Ancestor(<Hierarchy>.CurrentMember, <Level>)? Members ought to collate by
ordinal, if they do not already.

Julian

> -----Original Message-----
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Rushan Chen
> Sent: Tuesday, September 02, 2008 12:08 AM
> To: Mondrian developer mailing list
> Subject: [Mondrian] proposal for Order function with key 
> specification list
> 
> Mondrian implements the standard ORDER function as specified here:
> http://msdn.microsoft.com/en-us/library/ms145587.aspx
> 
> It allows sorting of a set using one sort order based on a  value or 
> string expression for each cell.
> 
> In our client, we would like to be able to sort a set using 
> not just the 
> value_expression for a cell but also the level coordinates, 
> similar to 
> the SQL order by clause. For MDX, it looks something like this:
> 
> ORDER(<set> {, <key_specification>}...)
> <key_specification> ::= {<level>|<value_expression>} [, ASC | DESC | 
> BASC | BDESC]
> <value_expression> ::= <numeric_value_expression> | 
> <string_value_expression>
> 
> If <level> is specified, cells are compared using the ordinal column 
> value (if CompareSiblingsByOrderKey is set) for that level.
> 
> I would like to know if this is something useful to everyone, and 
> whether for this it makes sense to extend Mondrian MDX beyond 
> standard MDX.
> 
> Thanks!
> 
> -- 
> Rushan Chen
> 
> 
> 
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> 
>