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

    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:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: