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

Explicit aggregates with count distinct measures can give incorrect results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.6.0 (5.0.0 GA Suite Release), 4.0.0 (5.1.0 GA Suite Release)
    • Fix Version/s: Mondrian 4.0 Sprint 5
    • 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

      Using an explicit aggregate with a count distinct measure can result in the measure being incorrectly summed. The attached test case demonstrates the problem, and the patch gives a potential fix. Contributed by Tomasz Karlik.

      Success Criteria:

      Passes test case.

        Attachments

          Activity

            People

            • Assignee:
              tgf Tiago Gomes Ferreira
              Reporter:
              mcampbell Matt Campbell
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: