<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18023" name=GENERATOR>
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
span.highlight1
{color:#EF8033;
font-weight:bold;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=749244719-30042008><FONT face=Verdana
color=#000080 size=2>Please google '<FONT color=#000000><FONT size=3>appears in
more than one independent <SPAN class=highlight1><SPAN
style="COLOR: windowtext">axis'.<FONT color=#000080 size=2> You will find the
answer.</FONT></SPAN></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=749244719-30042008><FONT face=Verdana
color=#000080 size=2><FONT color=#000000><FONT color=#000080 size=2><SPAN
class=highlight1><SPAN
style="COLOR: windowtext"></SPAN></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=749244719-30042008><FONT face=Verdana
color=#000080 size=2><FONT color=#000000><FONT color=#000080 size=2><SPAN
class=highlight1><SPAN
style="COLOR: windowtext">Julian</SPAN></SPAN></FONT></FONT></FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of
</B>Jayachandran,Sivagnanamoorthy<BR><B>Sent:</B> Wednesday, April 30, 2008
4:00 AM<BR><B>To:</B> mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] MDX
Query error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Verdana color=gray size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: gray; FONT-FAMILY: Verdana">First, thank u for
your considerations,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana color=gray size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: gray; FONT-FAMILY: Verdana">
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana">Select NON EMPTY
{[Measures].[New]} ON COLUMNS,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana"> 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<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana">From
[cube_1]<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana">Where ([queue.queue]. [All
queue].[{queue}], [site.site].[All
site].[{site}]).<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana color=gray size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: gray; FONT-FAMILY: Verdana">This one has the
same error: </SPAN></FONT><SPAN class=highlight1><B><FONT face=Verdana
color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: windowtext; FONT-FAMILY: Verdana">Dimension</SPAN></FONT></B></SPAN><FONT
face=Verdana size=2><SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: Verdana">
'[queue]' appears in more than one independent <SPAN class=highlight1><B><FONT
color=black><SPAN
style="COLOR: windowtext">axis</SPAN></FONT></B></SPAN>..<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: Verdana"> Here I am going to pass
the parameter as queue and sites. I need the queue and sites. How I can
rectify this problem .<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: Verdana">Kindly
advice.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><B><FONT face=Garamond color=gray size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: gray; FONT-FAMILY: Garamond">Thanks
& Regards<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoNormal><B><FONT face=Garamond color=navy size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Garamond">Sivagnanamoorthy
j.<o:p></o:p></SPAN></FONT></B></P></DIV></BLOCKQUOTE></BODY></HTML>