[Mondrian] Question concerning parent-child hierarchy in Level element

Eduardo Andrade eduardofandrade at gmail.com
Fri Apr 20 13:47:20 EDT 2007

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.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070420/cbbdf0af/attachment.html 

More information about the Mondrian mailing list