user rights - query panel does not show up

[Former Member]

Hello,

I am struggling with application rights for webi reporting.

I created new user and I would like to allow him to create webi reports.

I created new Access Level with all WEBI permissions enabled (application + content) and assigned to this web intelligence application and this user.

When I open web intelligence application, I select "New" and then I select universe, query panel does not show up.

When I add this user to Administrators group, same procedure causes query panel to show up. So it is obvious that Administrators group has some permission which I am missing in my own access level, but I have no clue which one.

Could you help me to find missing permission?

Is there any way to trace permission checks like in ABAP ST01?

Regards,

Martin

[Former Member · Accepted solution]

Hi Martin,

try running a security query for the user to see if there is an explicit denial somewhere. Select the user, right click, tools > Create Security Query. Select "Do not query by permissions" check box.

Below in the query context area, select the folder and run the query.

_panda_

[Former Member · Accepted solution]

Hello guys,

I did it!. I have used Panda's approach and I discovered that my webi user had no permission to use universe connection, so I set it up:

and then I was getting following error just before query panel should show up:

 

So I added following rights to my "webi creator" group over universe eFashon:

Result:

Thanks for help!

Regards,

Martin

[Former Member · Accepted solution]

Glad it worked...!!

_panda_

[nscheaffer · Accepted solution]

Good job!