I have a requirement in which I need to create a Webi report over BEX query.
BEX query contains summary data for all authorizations; however, Webi report should ONLY show the data which is as per the user's authorization.
To handle this, we are fetching the records as per the user authorization through DSOs in Business Layer and are passing those values as prompt parameters through open doc to the Webi report.
Once the user will open thsi report, he will only see the restricted data as per his authorization.
The issue is that once the user will open the report through Open Doc, he will be able to refresh the report and eventually he can refresh the LOVs of the prompt and might choose some values for which he is not authorized.
There are no restrictions applied at the BEX level.
Is there any way through which we can pass the values to the BEX query prompt through open doc link; however, user should not have the option to refresh and view the list of values?
Please let me know in case I need to further elaborate the requirement?