Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBI Security.

MDixitFeb 5 2009 — edited Feb 7 2009
Hi,

I would like to know more about OBI EE authentication using an external table and data authorisation (access to specific data).

I have a dimensional model and I want to implement security based on Team dimension. This dimension has three levels - 'All Teams', 'Team' and 'Sales Person'. I could successfully implement the OBI EE security using the Built In option. So, I created Users (Sales Persons) and Groups (Teams), defined the filters and could log in as a Group or User and could see only the data pertaining to that Group or User.

Now, I am trying the Authentication using External Table. As per the manual I have followed the steps. Before that I took a backup of the the repository that was working as mentioned above. Once configured, I deleted all the Groups and Users mentioned above from Security. Now, I can log in successfully, however, it shows me all the data (all teams and users) in Answers. I have joined the external table to the Team dimension (thinking that this may work). So data authorisation / access is failing. Where could I be wrong?

Please let me know. Thanks.

Manoj.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details