[Mondrian] Forcing "expr direction NULLS LAST" in order by without rebuild?

[Jesús Barrasa]

Thanks! That sounds great but I cannot make it work :(
Is this on 3.6.1 ?
I've been trying to set the dialect to the Oracle one as it seems to use the group by notation that I need.
That's what my connection string looks like:

Provider=mondrian;Jdbc=jdbc:<mydb>;JdbcUser=<myuser>;JdbcPassword=<pwd>;Dialect=mondrian.spi.impl.OracleDialect;JdbcDrivers=<mydriver>;Catalog=/WEB-INF/queries/mycat.xml

But I see no difference, still generating the default SQL with the CASE expressions in the ORDER BY.
Am I missing something?

Regards,

JB.



> From: julianhyde at gmail.com
> Date: Tue, 8 Apr 2014 18:12:24 -0700
> To: mondrian at pentaho.org
> Subject: Re: [Mondrian] Forcing "expr direction NULLS LAST" in order by	without rebuild?
> 
> You can pass Dialect=com.example.MyDialect as part of the connect string. Mondrian will ignore its usual process of deducing the dialect from the JDBC database name and use the class you provide. You don’t need to re-compile Mondrian.
> 
> In other words, dialects are pluggable.
> 
> Julian
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140409/4546c871/attachment.html