Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Restrict OLAP schemas per user

Parent article
To enable user-level access restrictions for each published analysis schema in the Pentaho User Console, follow the instructions below.
NoteThere is a different process for restricting OLAP schemas per role. See Mondrian Role Mapping in the Pentaho Server for instructions on role mapping.

Procedure

  1. Log on to the Pentaho User Console as the administrator user.

  2. Create new a solution directory for the user you want to provide a private analysis schema for.

  3. Change the access permissions on the new user directory so that only the specified user has access to it.

  4. Copy the target schema to the private directory that you just created.

  5. Rename the copied schema such that it reflects the user account that now owns it.

  6. Refresh the solution repository.

  7. Add data source entries for each personalized schema copy you created, using the Data Source Wizard to edit the data source.

    <Catalog name="Suzy">
        <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
        <Definition>solution:suzy/suzy.mondrian.xml</Definition>
    </Catalog>
    <Catalog name="Tiffany">
        <DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
        <Definition>solution:tiffany/tiffany.mondrian.xml</Definition>
    </Catalog>
  8. Edit the pentaho/server/pentaho-server/pentaho-solutions/system/pentaho.xml file and add a ,xml to the end of the <acl-files> list.

    <acl-files>xaction,url,prpt,xdash,xcdf,xanalyzer,xanalyzer,xml</acl-files>
  9. Restart the Pentaho Server.

Results

The schema copies you created are now only available to the users you specified.