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

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


    • Type: Improvement Improvement
    • Status: Open
    • Severity: High High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • 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.


      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.


        There are no comments yet on this issue.


          • Assignee:
            Unassigned User (Do not use)
            Julian Hyde
          • Votes:
            1 Vote for this issue
            2 Start watching this issue


            • Created: