[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
answer.
 
Julian


  _____  

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


More information about the Mondrian mailing list