Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-981

Poor performance when >=2 hierarchies are access-controlled with rollupPolicy=partial

    Details

    • Customer Case:
    • 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

      Mondrian seems to have poor performance when >=2 hierarchies are access-controlled with rollupPolicy=partial. Mondrian burns a lot of CPU; the time is not spent in SQL, and extra caching does not help.

      I suspect that Mondrian is performing a cartesian product of the accessible members. Suppose that you have 3 levels, each with 100 members, and access control that makes one of those members invisible. To compute the right total for the cell whose coordinates are 'all' for each level, mondrian has to aggregate 99 * 99 * 99 ~= 1M cells.

      Possible fixes? May be able to solve this by adding expression caching. Failing that, may need to push the access-control predicates down to SQL.

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated: