Monday, December 16, 2013

User unable to view any dashboards or reports to which he has access

We had  a new OBIEE user, that was added to an application role, but was still not able to vew dashboards and reports. This user did not have any subject area access, nor did he have access to create new reports / analysis. The user was just BI Publisher consumer which were also added to dashboards, and not for Analysis reports. We checked following, but nothing seems to fix the issue:

-The user was added to an application role, and this application role had read permission to the folder, right from root, all the way to dashboard and report level.
-The user was part of the application role that had access to my reports and my dashboards area.
-Other users part of same application role were able to view dashboards intended for the role.
-We were unable to add user directly to catalog group (or any user)
-When admin used 'act as' functionality, the dashboard was still not showing up even for admin

After trying several combination, we added the user to another application role, to see how permissions change. After doing this, we noticed that user was able to view the new dashboards as well as the dashboard which he was intended to view. Next, we removed the user from newly added role, and now the dashboard permissions kept working.

Appears to be clearly a bug. For solution like these the going goes, implementing BI is an art, as echoed by my client as well. It is more true for OBIEE 11g per say. Just an FYI, we had this issue on 11.1.1.6.9

Arun~

2 comments:

  1. did you manage to understand why it would not get privieleges with the initial app role?

    ReplyDelete