<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2>Parameters are a mondrian-specific extension to
MDX.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2>We'd have to (1) extend XMLA to support parameter binding
(i.e. pass parameters & values along with a the query to be executed) or (2)
we could do some simple text-based substitution of Parameter(...) calls on the
client side.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2>This is also a problem which will have to be solved when
the XMLA driver for olap4j gets written.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685030216-19072007><FONT face=Verdana
color=#000080 size=2>Julian</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>Pappyn
Bart<BR><B>Sent:</B> Thursday, July 19, 2007 2:36 AM<BR><B>To:</B> Mondrian
developer mailing list<BR><B>Subject:</B> [Mondrian] Passing Parameters to mdx
- not working for XMLA<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial size=2>I have noticed
there is no support in jpivot to pass parameters to an
analysis</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial size=2>when operating in
xmla mode.</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial size=2>Is there a known
way to do this ?</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial size=2>Is there an option
to pass parameters using http ?</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=687322909-19072007><FONT face=Arial
size=2>Bart</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>