I have created the dashboard against Bex–>BICS–> BIWS connection. I am passing Business area as a prompt and the security is set on Org Units. When i run the dashboard, i don’t get any errors but when the users run the dashboard, they get “BW System BWP returned state ‘USER_NOT_AUTHORIZED’.”. When user executes the report underlying the dashboard, he gets the results as the Org Units as automatically populated based on his authorization. It seems that Org units is not populated when passing through BIWS. Can you please let me know what should i modify in BIWS/ Webi ?
I tried the approach Ingo provided and it worked.
Approach: Duplicate the Auth variable and remove the input values option. Remove the original Auth variable from the query and it works.
I am facing the same issue. My Web Intelligence report refreshes fine with designated authorizations but web service created on this report gives me error “BW System QBW returned state ‘USER_NOT_AUTHORIZED’. Message = You do not have sufficient authorization”.
We have created Auth variables on Sales org in BW. Same is also working fine with queries created using BICS in Dashboard.
Please let me know what the real cause of error is. This is very urgent.