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


    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s:, GA, 6.0.0 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: None
    • Story Points:
    • 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)


      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

      1. FoodMart 2399.xml
        2 kB
        Strelchanka Stanislau
      2. FoodMart 2399 Rollup Type.xml
        2 kB
        Strelchanka Stanislau

        Issue Links


          There are no comments yet on this issue.


            • Assignee:
              upihin Uladzimir Pihin
              mcampbell Matt Campbell
            • Votes:
              0 Vote for this issue
              4 Start watching this issue


              • Created: