Analytics Software

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.