Dashboards: Issue with BEx Authorization Variable

Hello Experts,

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?

Regards,

Suraj