Thank you very much for your answer.<br>I will wait for the next release.<br><br>Eduardo Andrade<br><br><div><span class="gmail_quote">On 7/30/07, <b class="gmail_sendername">Will Gorman</b> &lt;<a href="mailto:wgorman@pentaho.org">
wgorman@pentaho.org</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Eduardo,<br><br>This bug is known and has been fixed.&nbsp;&nbsp;The next release of Mondrian will
<br>contain the fix:<br><br><a href="http://sourceforge.net/tracker/index.php?func=detail&amp;aid=1708327&amp;group_id=35302&amp;atid=414613">http://sourceforge.net/tracker/index.php?func=detail&amp;aid=1708327&amp;group_id=35302&amp;atid=414613
</a><br><br>If you can&#39;t wait until the next release, which is coming out soon, you<br>will need to implement a closure table to get your parent-child<br>hierarchy to work properly.<br><br>Will<br><br>On Mon, 2007-07-30 at 14:38 +0100, Eduardo Andrade wrote:
<br>&gt; Hi, i&#39;m having a problem with Mondrian&#39;s parent-child hierarchies. In<br>&gt; a parent-child hierachy if we don&#39;t specify a Closure Element the<br>&gt; results obtained from Mondrian are different on each version. Tested
<br>&gt; with Mondrian 2.1.1, 2.2.2 and 2.3.2.8944 (Foodmart.xml - with the<br>&gt; Dimension &quot;Employees&quot; from &quot;HR&quot; Cube).<br>&gt;<br>&gt; ---------------------------------------------------------------------------------------------------------------------
<br>&gt; &lt;Dimension name=&quot;Employees&quot; foreignKey=&quot;employee_id&quot;&gt;<br>&gt; &lt;Hierarchy hasAll=&quot;true&quot; allMemberName=&quot;All Employees&quot;<br>&gt; primaryKey=&quot;employee_id&quot;&gt;
<br>&gt; &lt;Table name=&quot;employee&quot;/&gt;<br>&gt; &lt;Level name=&quot;Employee Id&quot; type=&quot;Numeric&quot; uniqueMembers=&quot;true&quot;<br>&gt; column=&quot;employee_id&quot; parentColumn=&quot;supervisor_id&quot;
<br>&gt; nameColumn=&quot;full_name&quot; nullParentValue=&quot;0&quot;&gt;<br>&gt; &lt;!--<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Closure parentColumn=&quot;supervisor_id&quot; childColumn=&quot;employee_id&quot;&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Table name=&quot;employee_closure&quot;/&gt;
<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/Closure&gt;<br>&gt; --&gt;<br>&gt; &lt;Property name=&quot;Marital Status&quot; column=&quot;marital_status&quot;/&gt;<br>&gt; &lt;Property name=&quot;Position Title&quot; column=&quot;position_title&quot;/&gt;
<br>&gt; &lt;Property name=&quot;Gender&quot; column=&quot;gender&quot;/&gt;<br>&gt; &lt;Property name=&quot;Salary&quot; column=&quot;salary&quot;/&gt;<br>&gt; &lt;Property name=&quot;Education Level&quot; column=&quot;education_level&quot;/&gt;
<br>&gt; &lt;Property name=&quot;Management Role&quot; column=&quot;management_role&quot;/&gt;<br>&gt; &lt;/Level&gt;<br>&gt; &lt;/Hierarchy&gt;<br>&gt; &lt;/Dimension&gt;<br>&gt; ---------------------------------------------------------------------------------------------------------------------
<br>&gt;<br>&gt; With this JAVA code :<br>&gt; ---------------------------------------------------------------------------------------------------------------------<br>&gt; import mondrian.olap.*;<br>&gt; import java.io.PrintWriter
;<br>&gt;<br>&gt; public class MondrianCCATest {<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; public static void main(String[] args) {<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcUrl = &quot;jdbc:mysql://localhost:3306/foodmart&quot;;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcUser = &quot;foodmart&quot;;
<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcPass = &quot;foodmart&quot;;<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String connectionString = &quot;Provider=mondrian; Locale=pt_PT;<br>&gt; Jdbc=&quot; + jdbcUrl + &quot;; JdbcUser=&quot; + jdbcUser + &quot;; JdbcPassword=&quot; +
<br>&gt; jdbcPass<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + &quot;; Catalog=file:FoodMart.xml;&quot;;<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Connection connection =<br>&gt; DriverManager.getConnection(connectionString, null, false);<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query query = 
connection.parseQuery(&quot;SELECT {[Measures].[Org<br>&gt; Salary]} on columns,&quot; + &quot; {[Employees].[All Employees].[Sheri<br>&gt; Nowmer].children} on rows &quot;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + &quot;FROM [HR] &quot;);
<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Result result = connection.execute(query);<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Position[] positions = result.getAxes()[1].positions;<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result.print (new PrintWriter(&quot;mondrian.html
&quot;));<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (Exception e) {<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.printStackTrace();<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&gt; }<br>&gt; ---------------------------------------------------------------------------------------------------------------------
<br>&gt;<br>&gt; With Mondrian 2.1.1 I get the list of members correctly :<br>&gt; - Derrick Whelply<br>&gt; - Michael Spence<br>&gt; - Maya Gutierrez<br>&gt; - Roberta Damstra<br>&gt; - Rebecca Kanagaki<br>&gt; - Darren Stanz
<br>&gt; - Donna Arnold<br>&gt;<br>&gt; But with Mondrian 2.2.2 and 2.3.2.8944 I get an empty result. Should I<br>&gt; log a bug request with this information ?<br>&gt;<br>&gt; Thank you for your time.<br>&gt;<br>&gt; Best Regards,
<br>&gt;<br>&gt; --<br>&gt; Eduardo Andrade<br>&gt; <a href="mailto:eduardofandrade@gmail.com">eduardofandrade@gmail.com</a><br>&gt; _______________________________________________<br>&gt; Mondrian mailing list<br>&gt; <a href="mailto:Mondrian@pentaho.org">
Mondrian@pentaho.org</a><br>&gt; <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><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">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br></blockquote></div><br><br clear="all">
<br>-- <br>Eduardo Andrade<br><a href="mailto:eduardofandrade@gmail.com">eduardofandrade@gmail.com</a>