[Mondrian] Specifying Properties in MDX Statement

Julian Hyde jhyde at pentaho.org
Tue May 6 19:39:53 EDT 2008


Maybe you have a comma before the 2nd MEMBER? That's a common mistake.

Julian

On Tue, 2008-05-06 at 15:47 -0700, Alan Jackson- Indicee wrote:
> Hi Guys
> This has been driving me nuts for the last 4 hours.
> 
> I have a query that looks like this
>  
> WITH
> MEMBER [Measures].[Member1] As '...', FORMAT_STRING='#,##0'
> MEMBER [Measures].[Member2] As '...',
> CELL_FORMATTER='com.acme.myformatter'
> 
> Select {...} On Rows, {...} On Columns from Cube
>  
> I keep getting an exception from the parser complaining about token
> MEMBER
>  
> According to my understanding of MDX, the above is valid in Mondrian
> and is as good as the same as the MDX in TestCalculatedMembers.java
>  
> So, what's wrong?
>  
> I'm using the latest source from Perforce
>  
> TIA
> Alan
> 
> _______________________________________________
> 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/20080506/a1cbc011/attachment.html 


More information about the Mondrian mailing list