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

Parent-Child Hierarchy with Closure Table not generating full dimension results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Not a Bug
    • Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release)
    • Fix Version/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.
    • Operating System/s:
      RedHat Enterprise Linux 5, Windows XP

      Description

      When querying my Employee Dimension, which has a parent-child hierarchy built in Schema Workbench, from the Ad-hoc query on Mondrian and the MDX Explorer in Schema Workbench not all of the possible results are shown. Some of the top level people in the hierarchy are shown with the summation of all the employees who report to them, but none of the employees are actually shown. The number of results show seem to be equal to the number of distinct parent keys that it queries for with the addition of the All line.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dsplats Daniel
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: