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

drill through SQL for parent-child hierarchy

    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.
    • Closer:
      nobody

      Description

      When getting the drill-through SQL for a cell which is located in a parent-child hierarchy, the SQL reflects only the values that make up that cell, not including its subordinate members. This is different than other types of hierarchy, where the drill-through SQL encompasses all lower members.

      It seems that the method for returning drill-through SQL would have to be extended to return a collection of queries in the case where there is no closure-table, and then the client would execute all of these and conglomerate the results.

      Attached is an illustrated foodmart example, with MDX query.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              sbirney sbirney
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: