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

Duplicate dimensions in crossjoin

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • 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 2.4.2 doesn’t return an error when crossjoining members of the same dimension.

      For example the following MDX query works in Mondrian but fails in MSAS 2000 ("duplicate dimensions across independent axes" error):

      select Crossjoin(

      {[Product].defaultMember}

      ,

      {[Product].defaultMember.firstChild}

      ) on 0 from Sales

      Placing the same dimension on different axes (which theoretically should cause similar result) causes parser error in Mondrian.

      Julian Hyde wrote:

      "Mondrian can detect that issue at validate time, and it should. There's another case to the same bug where mondrian cannot detect the duplicate dimensions until runtime, e.g. crossjoin(dimensions(1).currentmember, dimensions(1).children)"

      The above case is covered by the following MDX which also fails in MSAS but succeedes in Mondrian:

      select crossjoin(

      {dimensions(1).currentmember}

      , dimensions(1).children) on 0 from Sales

        PractiTest Integration




          Attachments

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              anikitin anikitin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: