Uploaded image for project: 'Pentaho BA Platform'
  1. Pentaho BA Platform
  2. BISERVER-2491

Mondrian: rollupPolicy=partial and queries to upper members don't work: (Was: BISERVER-1655)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.1.GA, 3.0.0.GA
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mondrian 3.0.4
    • 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

      <Role name="California manager">
      <SchemaGrant access="none">
      <CubeGrant cube="Sales" access="all">
      <HierarchyGrant hierarchy="[Store]" access="custom" rollupPolicy="partial">
      <MemberGrant member="[Store].[USA].[CA]" access="all"/>
      <MemberGrant member="[Store].[USA].[CA].[Los Angeles]" access="none"/>
      </HierarchyGrant>
      </CubeGrant>
      </SchemaGrant>
      </Role>

      -------------------------------------------

      Works: select [Measures].[Unit Sales] ON COLUMNS, [Store].[Store Name].Members ON ROWS from [Sales]

      Doesn't work: select [Measures].[Unit Sales] ON COLUMNS, Descendants([Store],[Store].[Store Name]) ON ROWS from [Sales]

      Doesn't work: select [Measures].[Unit Sales] ON COLUMNS, [Store].[Store Country].Members ON ROWS from [Sales]

      Attaching relevant files to reproduce this

        Attachments

        1. FoodMart.xml
          32 kB
        2. index.html
          2 kB
        3. testrole.jsp
          1 kB
        4. testrole2.jsp
          1 kB
        5. testrole3.jsp
          1 kB

          Activity

            People

            • Assignee:
              wgorman Will Gorman (Inactive)
              Reporter:
              pmalves Pedro Alves
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: