BEx Query RRI with authorization object

[Former Member]

Hi,

I have two queries linked using RRI (Sender and Receiver).

Queries have authorization object.

Both queries work fine with authorized user if I use them separately.

(Query Sender works fine with authorized user, Query Receiver works fine with authorized user)

Using BEx in Excel:

- when an authorized user jumps from the Sender to the Receiver, system tells him he doesn't have the authorizations, and Receiver query doesn't appear.

Using Web:

- when an authorized user jumps from the Sender to the Receiver it works fine and user can see the results in the Receiver Query

Could anyone help me?

Thanks in advance

Fede

Edited by: Federico Carta on Jun 23, 2009 2:53 PM

[Former Member]

Hi,

I copied my User in User1 with same authorizations, profiles etc.

They are identical, User1 works fine!

Then I've deleted User from my system, I don't know what he had, but if

I

create a new user with the same name of old User, he doesn't work!

I solved my problem in this way,

thanks for your help

Best Regards

Fede

[Former Member]

Hi Fede,

You need to add a authorization object for document store. I do not remember the name of authorization object. You can do the authorization trace and check the logs and you will find the exact name of missing authorization object.

Regards, Niraj

[Former Member]

Hi,

Assign the authorization object S_BDS_D and check whether it resolves ur issue.

Regards, Niraj

[Former Member]

Hi Niraj,

I used authorization trace but in the log and I didn't find the name of missing authorization object,

it told me only "you don't have authorization"...

The authorization object S_BDS_D is already assigned to my role, and it has all authorizations, but it doesn't work!

Best Regards

Fede

[Former Member]

Please check the authorizations for these Authorization components

S_RS_COMP

S_RS_COMP1

S_RS_MPRO

S_RS_ICUBE

These are related to BI BEx queries authorization in role. Hope this would help you.

[Former Member]

Hi Mohan,

I checked the authorizations and S_RS_COMP, S_RS_COMP1, S_RS_MPRO, S_RS_ICUBE are correctly set.

The strange thing is that if user calls the Receiver query from the web (BI web server), it works fine. The problem is only if user executes them by BEx in Excel. If he uses Receiver query directly without using Sender query, it works fine!!!

Best Regards

Federico