"Authorization error" while accessing Multiprovider in Analysis for excel tool

[deepa_bheemu]

Hi,

We are using "Analysis for excel" 1.4 version. My users are executing all queries out of any MP with out any issue. But while accessing Multi Provider in "Analysis for excel" tool they are geeting "Authorization" error.  Any suggestions please.

Thanks,

Deepa.

[Former Member]

Hi Deepa,

I'm facing the same problem, which basically is no issue but expected behaviour?!

Reason: When allowing access on Multiproviders via queries you probably restrict the data selection with authorization variables, where users have to select characteristics they are allowed to see.

In that way, you prevent that users can see data for which they are not authorized.

Finally, if the direct selection via Multiprovider was allowed without any restriction, your whole authorization concept would be for the birds 🙂

In my case, I wanted to give users just an overview of the "last update dates" of several infocubes:

=SAPGetSourceInfo("DS_1"; "DataSourceName")

=SAPGetSourceInfo("DS_1"; "LastDataUpdate")

(... we all know that Multis can display only the oldest load date of any of all Cubes below....)

I even deleted the cross-tabs, and kept only the reference to the DS_x ... But still, when users try to refresh the data sources they are not even allowed to select pure technical Cube Information 😕

Regards, Martin

PS: If anyone else has a different idea as solution to my problem, just let me know 🙂

[deepa_bheemu]

Hi Tammy,

I did STAUTHTRACE. In logs I am seeing " No authorization in user master record"  for roles. Any thoughts on this.

Regards,

Deepa.

[TammyPowlas]

Hi Deepa - it has been a very long time since I've had to look at BW/Analysis authorizations

Would you please work with your BW security person to analyze?

Thank you,

tammy

[TammyPowlas]

Analysis uses the BW Analysis authorizations

If they are getting an authorization error, I recommend doing an ST01 transaction trace on the backend to see which Analysis authorizations could be missing.