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

Slicer size is quadratically inflating the cell requests

    Details

    • 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

      I have a simple test below that has a n day date range (in mondrian food mart only 5 days in this month have data, but theoretically, lets say this number is n)

      Then what I end up seeing when walking the code is that the CellReader gets issued O(n^2) requests.
      This seems to be happening via the call to RolapTupleCalculation which adds a calculated member to the RolapEvaluator.... We end up making n calls to this calculation, and each call results in n cell requests.

      I do not fully understand what this calculation is doing, and it is essentially introduced in the lines 365 to 391 in RolapResult

      public void testQueryEvaluation() {
      final TestContext testContext = getRestrictedTestContext();
      testContext.assertQueryReturns(
      "select

      {[Measures].[Unit Sales]} on COLUMNS, \n"
      + "[Store].[USA].[CA].Children on ROWS \n"
      + "from [Sales] \n"
      + "where ([Time.Weekly].[All Time.Weeklys].[1997].[2].[1] : [Time.Weekly].[All " +
      "Time.Weeklys].[1997].[2].[21])" ,
      "Axis #0:\n"
      + "{[Time].[1997].[Q1].[1]}\n"
      + "{[Time].[1997].[Q1].[2]}\n"
      + "Axis #1:\n"
      + "{[Measures].[Unit Sales]}

      \n"
      + "Axis #2:\n"
      + "

      {[Store].[USA].[CA].[Los Angeles]}

      \n"
      + "

      {[Store].[USA].[CA].[San Francisco]}

      \n"
      + "Row #0: 4,490\n"
      + "Row #1: 289\n");
      }

        Attachments

          Activity

            People

            • Assignee:
              bbruce Brandon Bruce (Inactive)
              Reporter:
              lboudreau Luc Boudreau
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: