<div dir="ltr">Will,<div><br></div><div>Great job guys. I love where this is going. I&#39;m a little curious about this change:</div><div><br></div><div><a href="https://github.com/tgf/mondrian/blob/evergreen/src/main/mondrian/olap4j/MondrianOlap4jExtra.java?source=c#L232">https://github.com/tgf/mondrian/blob/evergreen/src/main/mondrian/olap4j/MondrianOlap4jExtra.java?source=c#L232</a><br>

</div><div><br></div><div>We have been progressively removing all ordinals from the specs since the cost to compute them is too expensive. Even MSFT is doing the same. The replacement for ordinals is an order key. This allows the client to figure out the ordering, if needed, while sparing the effort server-side.</div>

<div><br></div><div>What&#39;s the reason for the change? Maybe we can fix the issue some other way.</div><div><br></div><div>Luc</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 23, 2014 at 11:22 AM, Will Gorman <span dir="ltr">&lt;<a href="mailto:wgorman@pentaho.com" target="_blank">wgorman@pentaho.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">Hi Lakshmi,<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">That is great news!  We are working on something similar, so it would be nice if we could collaborate.  We are in the process of adding <a href="http://ADOMD.NET" target="_blank">ADOMD.NET</a> and SSRS support for Mondrian in the master branch.  The work right now is going on in our personal github accounts.  <u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">Here is the link to the JIRA case:<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><a href="http://jira.pentaho.com/browse/MONDRIAN-1836" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-1836</a><u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">Here is a link to a branch of Mondrian with our <a href="http://ADOMD.NET" target="_blank">ADOMD.NET</a> changes:<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><a href="https://github.com/tgf/mondrian/commits/evergreen" target="_blank">https://github.com/tgf/mondrian/commits/evergreen</a><u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">We’ve added a couple Mondrian Properties to enable Microsoft compatibility: <u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">•             mondrian.xmla.AlwaysIncludeDefaultSlicer=true<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:.5in">

<span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">o             always output the default members in the slicer axis for unconstrained dimensions in xmla queries. if not true we get exceptions reading members on adomd client;<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">•             mondrian.xmla.CustomProviderVersion=10.0.1600.22<u></u><u></u></span></p><p class="MsoNormal" style="text-indent:.5in">

<span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">o             &#39;spoofs&#39; the ProviderVersion XMLA property to this value; there are fields for which the adomd client will throw a NotSupportedException if the version isn&#39;t recognized as supporting them, regardless of the actual value in xmla<u></u><u></u></span></p>

<p class="MsoNormal" style="text-indent:.5in"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">o              if set to empty would show the mondrian version<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">Here is a link to our ADOMD.net test suite, which is a command line C# app that exercises various <a href="http://ADOMD.NET" target="_blank">ADOMD.NET</a> calls:<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><a href="https://github.com/portisheadaff/adomdtest" target="_blank">https://github.com/portisheadaff/adomdtest</a><u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">It would be great to see the changes you made, if you have a github account you can just point us to your fork of Mondrian.<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d">Hope we can share efforts!<br>

<br>Will<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Dhanalakshmi N<br>

<b>Sent:</b> Thursday, January 16, 2014 10:43 PM<br><b>To:</b> <a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br><b>Subject:</b> [Mondrian] Microsoft Excel with Mondrian through MS OLEDB provider for analysis services driver<u></u><u></u></span></p>

<div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">Hi,<u></u><u></u></p></div><div><p class="MsoNormal">I was working on integrating Microsoft Excel with mondrian through MS OLEDB provider for analysis services driver. I have made some changes in Mondrian 3.5.0 source code. Now Excel is working fine for me with Mondrian through this driver. Please let me know where can I submit these changes.<u></u><u></u></p>

</div><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <u></u><u></u></p><div><p class="MsoNormal">Thanks &amp; Regards,<u></u><u></u></p><div><p class="MsoNormal">Lakshmi<u></u><u></u></p></div>

</div></div></div></div></div></div><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>