Dashboards: Issue with BEx Authorization Variable
I have created a dashboard using a Bex query which has a ready for input authorization variable.
I have used this variable as a query prompt selector in the dashboard.
When a user with restricted authorizations executes the dashboard, he gets the following error.
'Request processing failed. BW System returned state USER_NOT_AUTHORIZED. Message 'You do not have sufficient authorizations'.
However, when the same user executes the BEx query, he gets the correct data without any error message.
Can you please help?
I solved this issue by using two variables, one of authorization and one without.