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

no results when some level members in a member grant have no data


    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Incomplete
    • Affects Version/s: 3.2.1 GA (3.7.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • 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.


      This schema is for a multi tenancy system.
      All hierarchies have a top level that identifies the customer.
      This top level is used in member grants to specify what data is accessible to a given role.
      All these hierarchy grants work individually, but fail in combinations when no data is available for one or more members of a hierarchy.
      e.g. Customer 1 has access to products 3, 4, 5. The restriction on products works when no other hierarchy restrictions are specified in the schema. When there are other hierarchy restrictions and there is no data for one product (e.g. 3), but there is data for others (4, 5), the query returns no data.




            • Assignee:
              anthonycarter Anthony Carter (Inactive)
              bmaertens Bart Maertens
            • Votes:
              1 Vote for this issue
              2 Start watching this issue


              • Created: