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

CacheControl.flush(MemberSet) does not flush NativeSet member caches.

    XMLWordPrintable

    Details

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

      Description

      The Mondrian CacheControl api is intended to all fine grained control over flushing cached cells and members. Flushing members only flushes from the member reader associated with the members hierarchy, however, which omits a cache associated with native set evaluation.

      Running the following block, you'll see only one execution of member load for the gender members, where there should be two.

      String mdx = "select filter( gender.gender.members, measures.[Unit Sales] > 0) " +
                  "on 0 from sales ";
              mondrian.olap.Result rest = executeQuery(mdx);
              RolapCube cube = (RolapCube) rest.getQuery().getCube();
              RolapConnection con = (RolapConnection) rest.getQuery().getConnection();
              CacheControl cacheControl = con.getCacheControl(null);
      
              for (RolapHierarchy hier : cube.getHierarchies()) {
                  if (hier.hasAll()) {
                      cacheControl.flush(cacheControl.createMemberSet(hier.getAllMember(), true));
                  }
              }
              executeQuery(mdx);
      

        Attachments

          Activity

            People

            Assignee:
            pavel_hrakovich Pavel Hrakovich (Inactive)
            Reporter:
            mcampbell Matt Campbell
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 16h
                16h