Restrict OLAP schemas per user
Procedure
Log on to the Pentaho User Console as the administrator user.
Create new a solution directory for the user you want to provide a private analysis schema for.
Change the access permissions on the new user directory so that only the specified user has access to it.
Copy the target schema to the private directory that you just created.
Rename the copied schema such that it reflects the user account that now owns it.
Refresh the solution repository.
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>
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>
Restart the Pentaho Server.
Results