[Mondrian] MDX Query error

Julian Hyde jhyde at pentaho.com
Wed Apr 30 15:48:13 EDT 2008

Please google 'appears in more than one independent axis'. You will find the


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Jayachandran,Sivagnanamoorthy
Sent: Wednesday, April 30, 2008 4:00 AM
To: mondrian at pentaho.org
Subject: [Mondrian] MDX Query error

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

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/8b6199a6/attachment.html 

More information about the Mondrian mailing list