Hi All,
I am using a dimensional package .In order to burst report I have created a relational table with a data item column and corresponding distribution list containing cam id.
Now I am able to burst the report by creating a master detail relationship between these.
My issue is I dont want users to see this relational table in the package, say they are given access to analysis studio, both the cube and this relational table shows up.
Thanks,
Nithya
Quote from: nithya1224 on 16 Dec 2014 02:16:52 PM
Hi All,
I am using a dimensional package .In order to burst report I have created a relational table with a data item column and corresponding distribution list containing cam id.
Now I am able to burst the report by creating a master detail relationship between these.
My issue is I dont want users to see this relational table in the package, say they are given access to analysis studio, both the cube and this relational table shows up.
Thanks,
Nithya
You could define object security for it in FM so the only people who it is available for are yourself and any others responsible for creating burst reports?
Relational objects are not visible in Analysis Studio anyway, so this isn't a problem for you. It would only be an issue in Query Studio/Report Studio/Cognos Workspace Advanced.
Cheers!
MF.