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

No way to use an AvgFromSum calculation with explicitly defined aggregate tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 5.3.0.5, 5.4.0.2 GA, 6.0.0 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: None
    • Story Points:
      0
    • 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.
    • Sprint Team:
      Tatooine (Maint)

      Description

      Using an explicitly defined aggregate table which includes an average measure (i.e. defined in the Mondrian schema), there is no way to get the calculation to use AvgFromSum. It will attempt to rollup with AvgFromAvg, which assumes the rolled up avg value is captured in the aggregate table.That method can result in rounding errors and is not always desired.

      Ideally there would be some way to specify the exact rollup method used when averages are involved: AvgFromSum, AvgFromAvg, SumFromAvg

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              upihin Uladzimir Pihin (Inactive)
              Reporter:
              mcampbell Matt Campbell
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: