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

Cannot use visual totals members in calculations

    Details

    • Type: Bug
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release)
    • Fix Version/s: Backlog
    • 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

      Cannot use visual totals members in calculations. The following query:

      with member [Measures].[Foo] as
       [Product].Name || [Product].Level.Name
      select {[Measures].[Unit Sales], [Measures].[Foo]} on columns,
      {[Product].[All Products],
       [Product].[All Products].[Food].[Baked Goods].[Bread],
       VisualTotals(
          {[Product].[All Products].[Food].[Baked Goods].[Bread],
           [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels],
           [Product].[All Products].[Food].[Baked Goods].[Bread].[Muffins]},
         "**Subtotal - *\")} on rows
      from [Sales]
      

      gives error "mondrian.olap.fun.MondrianEvaluationException: Could not find an aggregator in the current evaluation context" in one of the cells.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jhyde Julian Hyde
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: