I have a schema and a report using this schema. Now I would like to show in this report different parts of my data to different roles (e.g. different partner shops should only see the data concerning them). For that I made one perspective for every partner and gave each of them a different role using only this perspective. The report itself I set up to use the whole cube.
But apparently this is not working, as I thought, since they can all see the whole cube.
Did I miss something? Is it even possible, what I try to achieve?
Thanks in advance for your help!
I'd advise using the authorization instead of the perspectives to limit roles access ( access rights ). You can still keep the perspectives if it's not possible with the authorization.
If you need to use perspectives, you can setup cube/perspective access right per role.
If this does not work, contact support directly (not easy without the schema to understand the problem)