Hitachi Vantara Pentaho Community Forums
Results 1 to 21 of 21

Thread: Pentaho Cube - role setup not working

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Pentaho Cube - role setup not working

    I designed a cube and tried to set access controls for the cube by adding roles. But the access levels i designed is not reflecting when i viewed the cube via Pentaho User Console.
    Tools Used:
    Pentaho Community Edition BI Suite 3.0 RC2
    Schema Workbench 3.0.4
    Datasource: HSQLDB
    Database: SampleData
    The steps i followed in the above issue is,
    Step 1:
    I designed a cube using Schema Workbench 3.0.4, which will list all the cities, the customer names in each of those cities, and number of customers in each city. This cube has a role called 'Admin' for which, the dimension 'Cities' has to be hidden.
    Schema for the cube is as follows,
    <Schema name="CubeTesting">
    <Cube name="CustomerCube" cache="true" enabled="true">
    <Table name="CUSTOMERS" schema="PUBLIC">
    <Dimension type="StandardDimension" foreignKey="CUSTOMERNUMBER" name="Cities">
    <Hierarchy hasAll="true" allMemberName="All Cities">
    <Table name="CUSTOMERS" schema="PUBLIC">
    <Level name="Country" column="COUNTRY" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    <Level name="City" column="CITY" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    <Dimension type="StandardDimension" foreignKey="CUSTOMERNUMBER" name="CustomerNames">
    <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="All Customers">
    <Table name="CUSTOMERS" schema="PUBLIC">
    <Level name="CustomerName" column="CONTACTFIRSTNAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
    <Measure name="CustomerCount" column="CUSTOMERNUMBER" datatype="Integer" formatString="####" aggregator="count" visible="true">
    <Role name="Admin">
    <SchemaGrant access="none">
    <CubeGrant cube="CustomerCube" access="all">
    <DimensionGrant dimension="Cities" access="none">
    Step 2:
    I published the cube into the pentaho server in the following path "biserver-ce\pentaho-solutions\bi-developers\analysis" (username & password used to publish was 'Joe' & 'password' respectively)
    Got 'Publish successful' message as well.
    Step 3:
    Again, in pentaho user console, logged in as user 'joe' who has the role 'Admin'.
    Clicked on 'New Analysis View' button. It listed out the schema and cube i published in step 2.
    Step 4:
    In the analysis view window, it is showing the complete cube instead of hiding the dimension 'Cities' which was orginally expected based on my 'Dimsension Grant' setting in schema file.

    If anyone can guide me on this, it will be really helpful. Or let me know if you need more details.
    Please advice.
    - Senthil Kumar.

  2. #2


    New Analysis View doesn't enable roles by default. You can hack the xaction behind it, or deploy your own xaction with roles enabled.

    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(

  3. #3

    Default Pentaho - hacking xaction files for enabling roles

    Hello Tom,

    Thanks for your swift reply.

    Can you tell me where i can find the .xaction file for my cube?

    As I am not knowledged in this, pls help me on hacking the xaction file (or to deploy my own xaction file) to enable the roles.

    - Senthil Kumar.

  4. #4
    Join Date
    Oct 2006

    Default try

    Try this:


    I was speaking to Tom about it yesterday. Turns out Tom is completely insane.. Who would have thought?

    Haza - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on in the ##pentaho channel

  5. #5

    Default Roles not working

    hey haza,

    To enable roles, what i have to do in that file you have specified...? If you have any such sample xaction files for enabling roles, pls provide me.

    Or is there any sample available (other than foodmart) to learn about setting access controls for cube?

    - Senthil Kumar.

  6. #6
    Join Date
    Oct 2006


    Senthil Kumar,

    Have you got roles and OLAP permissions working at all? Or is this what you are trying to do? If so i can dig out some samples i made a while back to test this.


    Harris - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on in the ##pentaho channel

  7. #7


    Still can see everything....

  8. #8


    how do you define the roles and grants in Workbench??

  9. #9


    as in attached screens
    Last edited by Bezan; 10-18-2011 at 05:34 AM.

  10. #10


    what are you trying to restrict??. Can you tell me what is the expected behavior?

  11. #11


    I have the same problem. After creating role in Workbench and assigning it to user in PAC I can still see everything.
    How can I force this roles to work correct?

  12. #12


    Hi, wich version of biserver are you using?.

  13. #13


    Hi, it is 3.8.0

  14. #14


    try with this steps:

    1- Stop the biserver
    2- Edit the file pentahoObjects.spring.xml located in /biserver-ce-3.8.0-stable/biserver-ce/pentaho-solutions/system and uncomment this lines:

    <bean id="Mondrian-UserRoleMapper"
    scope="singleton" />
    3- Start the biserver
    4- Define the same role names in the Worckbench and in PAC and define the grant permissions for every role.

    This method of Role mapper is one of the three available in Pentaho.


    Marcos Pierri

  15. #15
    Join Date
    Feb 2013


    HI...I'm newbie to Mondrian. I need the same functionality in Mondrian ?
    Can anybody help me how to achieve this ?
    Requirement is :
    I need to create a cube and have to restrict some columns(measures) for specific users for eg: joe or suzy ?
    i.e, for one user I wanna show for eg: 5 measures and for another user I wanna show 7 measures ....

    Your help would be great
    Thanks in Advance
    Last edited by sadakar; 04-05-2013 at 09:22 AM.

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.