Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: "Tree" hierarchy

  1. #1
    Join Date
    May 2014

    Default "Tree" hierarchy

    Hi everybody!
    I need to create a "tree" hierarchy. I mean a normal hierarchy where some level have a separate branch that determines a particular characteristic of that level.
    I hope I explained it well, can I do that in Mondrian?

  2. #2
    Join Date
    May 2014


    you can use closure in level that contains id parent and id child
    for example:
    <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"/>
    <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"/>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.