Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: mondrian roles management

  1. #1
    Join Date
    Jul 2014
    Posts
    1

    Question mondrian roles management

    Hi folks!

    I need more knowledge, about how mondrian roles are managed by default, i shoot the scenario:

    I have this role definition:

    <Role name="M_Development">
    <SchemaGrant access="none">
    <CubeGrant cube="MyCube" access="all">
    <HierarchyGrant hierarchy="[Organization]" access="custom" rollupPolicy="partial">
    <MemberGrant member="[Organization].[Organization].[37518]" access="all"/>
    </HierarchyGrant>
    </CubeGrant>
    </SchemaGrant>
    </Role>

    Over this Dimension:

    <Dimension name="Organization">
    <Hierarchy hasAll="true">
    <Table name="`my_table`" schema="`my_schema`"/>
    <Level name="Organization" column="organization_id" type="Numeric" uniqueMembers="false">
    </Level>
    <Level name="Name" column="orgName" type="String" uniqueMembers="false">
    </Level>
    </Hierarchy>
    </Dimension>

    And the question is, if the member [Organization].[Organization].[37518] doesn't exists in my_table, i can see all the other members and not an empty result, why ?

    It's about any setting by default? Is for the CubeGrant definition?

    PD: I use Pentaho release: 4.5.0.stable.49886, it's old, i know.

    Thank you!

  2. #2
    Join Date
    Nov 2017
    Posts
    7

    Default

    I guess the hierarchy has to be named "Organization" although

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.