Hi, i'm having a problem with Mondrian's parent-child hierarchies. In a parent-child hierachy if we don't specify a Closure Element the results obtained from Mondrian are different on each version. Tested with Mondrian 
2.1.1, 2.2.2 and 2.3.2.8944 (Foodmart.xml - with the Dimension &quot;Employees&quot; from &quot;HR&quot; Cube).<br><br>---------------------------------------------------------------------------------------------------------------------
<br>&lt;Dimension name=&quot;Employees&quot; foreignKey=&quot;employee_id&quot;&gt;<br>
    &lt;Hierarchy hasAll=&quot;true&quot; allMemberName=&quot;All Employees&quot; primaryKey=&quot;employee_id&quot;&gt;<br>
      &lt;Table name=&quot;employee&quot;/&gt;<br>
      &lt;Level name=&quot;Employee Id&quot; type=&quot;Numeric&quot; uniqueMembers=&quot;true&quot; column=&quot;employee_id&quot; parentColumn=&quot;supervisor_id&quot; nameColumn=&quot;full_name&quot; nullParentValue=&quot;0&quot;&gt;
<br>
        &lt;!--<br>&nbsp;&nbsp; &lt;Closure parentColumn=&quot;supervisor_id&quot; childColumn=&quot;employee_id&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Table name=&quot;employee_closure&quot;/&gt;<br>&nbsp;&nbsp; &lt;/Closure&gt;<br>
        --&gt;<br>
        &lt;Property name=&quot;Marital Status&quot; column=&quot;marital_status&quot;/&gt;<br>
        &lt;Property name=&quot;Position Title&quot; column=&quot;position_title&quot;/&gt;<br>
        &lt;Property name=&quot;Gender&quot; column=&quot;gender&quot;/&gt;<br>
        &lt;Property name=&quot;Salary&quot; column=&quot;salary&quot;/&gt;<br>
        &lt;Property name=&quot;Education Level&quot; column=&quot;education_level&quot;/&gt;<br>
        &lt;Property name=&quot;Management Role&quot; column=&quot;management_role&quot;/&gt;<br>
      &lt;/Level&gt;<br>
    &lt;/Hierarchy&gt;<br>
  &lt;/Dimension&gt;<br>---------------------------------------------------------------------------------------------------------------------<br><br>With this JAVA code :<br>---------------------------------------------------------------------------------------------------------------------
<br>import mondrian.olap.*;<br>import java.io.PrintWriter;<br><br>public class MondrianCCATest {<br><br>&nbsp;&nbsp;&nbsp; public static void main(String[] args) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcUrl = &quot;jdbc:mysql://localhost:3306/foodmart&quot;;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcUser = &quot;foodmart&quot;;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String jdbcPass = &quot;foodmart&quot;;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String connectionString = &quot;Provider=mondrian; Locale=pt_PT; Jdbc=&quot; + jdbcUrl + &quot;; JdbcUser=&quot; + jdbcUser + &quot;; JdbcPassword=&quot; + jdbcPass
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + &quot;; Catalog=file:FoodMart.xml;&quot;;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Connection connection = DriverManager.getConnection(connectionString, null, false);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query query = connection.parseQuery(&quot;SELECT {[Measures].[Org Salary]} on columns,&quot; + &quot; {[Employees].[All Employees].[Sheri Nowmer].children} on rows &quot;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + &quot;FROM [HR] &quot;);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Result result = connection.execute(query);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Position[] positions = result.getAxes()[1].positions;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result.print
(new PrintWriter(&quot;mondrian.html&quot;));<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (Exception e) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.printStackTrace();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp; }<br>}<br>---------------------------------------------------------------------------------------------------------------------
<br><br>With Mondrian 2.1.1 I get the list of members correctly :<br>- Derrick Whelply<br>- Michael Spence<br>- Maya Gutierrez<br>- Roberta Damstra<br>- Rebecca Kanagaki<br>- Darren Stanz<br>- Donna Arnold<br><br>But with Mondrian 
2.2.2 and 2.3.2.8944 I get an empty result. Should I log a bug request with this information ?<br><br>Thank you for your time.<br><br>Best Regards,<br><br>-- <br>Eduardo Andrade<br><a href="mailto:eduardofandrade@gmail.com">
eduardofandrade@gmail.com</a>