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

Closure tables for diferents hierarchies in same dimension don't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Incomplete
    • Affects Version/s: 3.2.1 GA (3.7.0 GA Suite Release)
    • Fix Version/s: Backlog
    • Labels:
      None
    • Environment:
      Windows 7, MySQL 5.1
    • 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

      the scheme has a dimension (account), and this dimension has two hierarchies (account, account management). Each hierarchie has a closure table differently. When performing a query using the second hierarchy (account management) is a generated SQL with reference to the closure table of the first.

        Attachments

        1. bi dialogo.zip
          13 kB
        2. dre.xml
          11 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              diego.muriel Diego Muriel
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: