Request proProcessing failed. (XLS 000009) You do not have data access rights for the connection.

[Former Member]

Hello,

I have created a universe UNX on top of a sql table. and i used this UNX via query browser to create a dahsboard. when i run this dashboard with "administrator" the dashboard runs but when i run with any other user it shows the below error. I have checked the connections user security and the i have given "full rights" to the user group and also the universe user security has "full rights" but still i get this error. How do i solve this issue. Couldnt find where the authorization is missing. Please help

[arijit_das]

Please re-check the rights assigned. Clearly, you need "Data Access" right for the universe as well as the connection. Do you have any object-access level security in place ?

[Former Member]

Hi Arjit,

I have object level security set in universe security for my universe folder in which i have all universes as below. "Everyone" is the user group i am trying to access which is showing error and administrator works fine.

I also have set some universe security on the particular universe i am using as below:

User security is set to full control for user group "everyone"..

[former_member202257]

Hello,

You also need to check the access to the connections. Go to CMC --> Connections and check if you have the required access.

Regards,

Shwetha