Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • 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

      While executing a query that has the Hierarchize function applied to tuples, one or more of whose dimensions has rollupPolicy="partial", get error "assertion failed in HierarchizeArrayComparator".

      Full stack is attached.

      Have reproduced with a query against foodmart:

      select hierarchize(
      crossjoin(

      {[Store Size in SQFT], [Store Size in SQFT].Children}

      ,

      {[Product]}

      )) on 0,
      [Store Type].Members on 1
      from [Warehouse]

      running under role1 defined as follows:

      <Role name="role1">
      <SchemaGrant access="none">
      <CubeGrant cube="Warehouse" access="all">
      <HierarchyGrant hierarchy="[Store Size in SQFT]" access="custom" rollupPolicy="partial">
      <MemberGrant member="[Store Size in SQFT].[20319]" access="all"/>
      <MemberGrant member="[Store Size in SQFT].[21215]" access="none"/>
      </HierarchyGrant>
      <HierarchyGrant hierarchy="[Store Type]" access="custom" rollupPolicy="partial">
      <MemberGrant member="[Store Type].[Supermarket]" access="all"/>
      </HierarchyGrant>
      </CubeGrant>
      </SchemaGrant>
      </Role>

        Activity

          People

          • Assignee:
            jhyde Julian Hyde
            Reporter:
            jhyde Julian Hyde
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: