OBI Security.
MDixitFeb 5 2009 — edited Feb 7 2009Hi,
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.