Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1585

Support hybrid hierarchies that have both regular and parent-child levels

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Not Planned
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Mondrian parent-child hierarchies can today only contain a single named level (based on an attribute, and with a parent attribute).

      This case proposes to allow hierarchies that have 1 or more regular levels, then a parent-child hierarchy at the bottom. For example, the Employees hierarchy might have levels Organization and Employee.

      In scope:
      1. Provide a way to define closure tables to accelerate such hierarchies;
      2. Access control must work (perhaps with documented restrictions such as that members of the parent-child level cannot be granted/revoked);
      3. Provide a way to define aggregate tables that roll up correctly (perhaps working with closure tables).

      For this feature to be widely used, client tools such as Analyzer and Saiku would need to support hybrid hierarchies. This support is probably expensive. Out of scope of this case.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jhyde Julian Hyde (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: