#42 Parent-Child Hierarchy w/o Closure displays only one level

[Eduardo Andrade]

In a parent-child relation if we don't specify a Closure Element the relation only displays one child below the (All) Level.
Tested with JPivot from CVS (1.7.0 today) and Mondrian-HEAD (2.3.2.8944) and Foodmart.xml with the Dimension "Employees" from "HR" Cube. I tested it with JPivot war file, accessing Mondrian via API, not XML/A.

<Dimension name="Employees" foreignKey="employee_id">
<Hierarchy hasAll="true" allMemberName="All Employees"
primaryKey="employee_id">
<Table name="employee"/>
<Level name="Employee Id" type="Numeric" uniqueMembers="true"
column="employee_id" parentColumn="supervisor_id"
nameColumn="full_name" nullParentValue="0">
<!--
<Closure parentColumn="supervisor_id" childColumn="employee_id">
<Table name="employee_closure"/>
</Closure>
-->
<Property name="Marital Status" column="marital_status"/>
<Property name="Position Title" column="position_title"/>
<Property name="Gender" column="gender"/>
<Property name="Salary" column="salary"/>
<Property name="Education Level" column="education_level"/>
<Property name="Management Role" column="management_role"/>
</Level>
</Hierarchy>
</Dimension>

This is a introduced bug, because JPivot/Mondrian 2.1.1 displays the hierarchy correctly.

I think this is a JPivot problem because of this message : http://sourceforge.net/mailarchive/message.php?msg_id=45797628.4000600%40web.de

[Ken Geis]

Logged In: YES
user_id=3130
Originator: NO

It looks like this was fixed in Mondrian. The fix would be in Mondrian 2.4.

http://sourceforge.net/tracker/index.php?func=detail&aid=1708327&group_id=35302&atid=414613