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

DrillThrough on Parent-Child Hierarchy

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • 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

      DrillThrough on cell with parent-child hierarchy delivers wrong SQL-Statements.

      The generated Drillthrough-SQL joins the fact table with the parent-child dimension table T, selects T.PARENT_CHILD_NAME_COL as "A" and T.PARENT_CHILD_KEY_COL as "A (Key)", but does not restrict the result to the cell's member of this hierarchy in the Where-Clause.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jens0310 jens0310
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: