View Full Version : [Mondrian] Question concerning parent-child hierarchy in Levelelement

Eduardo Andrade
04-20-2007, 01:50 PM
can anyone enlighten me if a parent-child hierarchy with no closure supports
multiple levels ?

I have a mondrian cube definition like this :

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE Schema SYSTEM "mondrian.dtd">

<Schema name="CATEGORY1177069685000">
<Cube name="CATEGORY" caption="CATEGORY" cache="true" enabled="true">
<Table name="CATEGORY"/>

<Dimension name="CATEGORY">
<Hierarchy name="CATEGORY" allMemberName="CATEGORY" hasAll="true">
<Table name="CATEGORY"/>
<Level name="CATEGORY" table="CATEGORY" column="PKCOLUMN"
nameColumn="CATEGORYNAME" parentColumn="PARENTID" uniqueMembers="true"
nullParentValue="NULL" />

<Measure column="PKCOLUMN" name="PKCOLUMN" aggregator="count"

that builds to a hierarchical structure in mondrian 2.1.1 but not on
mondrian 2.3.2.

If no answer can be given, can someone advise where to lookup in source code
? I've been looking in mondrian.rolap.SqlMemberSource and

Thank you in advance.

Eduardo Andrade
eduardofandrade (AT) gmail (DOT) com

Mondrian mailing list
Mondrian (AT) pentaho (DOT) org