Showing results for 
Search instead for 
Did you mean: 

BI analysis authorization in webi problem

Former Member
0 Kudos

Hi Gurus,

Below is my scenario:

1. In SAP BI, create one authorization where, let's say, 0compcode, EQ 8000

2. In SAP BI, ceate role "report_user" and attach above authorization to it.

3. In SAP BI, ceate user "report_user01" and put into above role.

4. In query designer, create a query using anthoriztion variable about 0compcode, 'varible is ready for input' uncheck

5. In SAP BI, user "report_user01" log-in, use rsrt1, the query runs successfully, he can only see relevant data from company code "8000"

6. In BO CMC, import "report_user" role, and assign this group authorization to relevant folders(view on demand)

(here entitlement system user name and password, I tried both crystal and some SAP BI administrator, the problem is the same)

7. In BO designer, log-in with another SAP user (say, report-designer, assigned with BO universe designer authorization), create universe upon the above query using SSO when refreshing at view time.

8. In BO infoview, report-designer creates a webi report using above universe. This webi report runs successfully with all data including company 8000

9. In BO infoview, report-user logs in, tried to open the above webi report, it displayed ALL data besides company 8000. BUT, when he tried to refresh the data, it poped some olap load error (WIS 10901)


1. MDX test is fine.

2. In CMC authorization SAP

3. Ingo, I kinda read through all relevant article(manual, blog,article), but this end-to-end issue still not solved.Really need some of your input.


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos


can you run the BEx Query in the BEx web reporting with several users and the authorization query is filtering the data ?

important - no BusinessObjects involved at this point.