[Mondrian] MDX Query error

Jayachandran, Sivagnanamoorthy sivagnanamoorthy.jayachandran at capgemini.com
Wed Apr 30 06:59:42 EDT 2008


First, thank u for your considerations,

                             

Select NON EMPTY {[Measures].[New]} ON COLUMNS,

  NON EMPTY {([queue.queue].[All queue], [site.site].[All site],
[manager. manager].[All manager], [supervisor. supervisor].[All
supervisor], [Agent. Agent].[All Agent], [Date. Date].[All Date])} ON
ROWS

>From [cube_1]

Where ([queue.queue]. [All queue].[{queue}], [site.site].[All
site].[{site}]).

This one has the same error: Dimension '[queue]' appears in more than
one independent axis..

 Here I am going to pass the parameter as queue and sites. I need the
queue and sites. How I can rectify this problem .

Kindly advice.

 

Thanks & Regards

Sivagnanamoorthy j.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080430/1492fbe6/attachment.html 


More information about the Mondrian mailing list