Dear BI Experts,
We made the Infoobject '0EMPGROUP' as authorization relevant and also created a variable in the BEX Querry Designer and using this variable in the selction screen before the Query is executed. We have about 5 level of Authorizations and the users assigned with the different levels are able to see only the relevant values of the variant in the selction screen. They are also able to see the desired results in the query.
However, users are complaining that they are forced to select the list of values in the variable every time before running the report. You may ask them to save them as variant but you have to train some 100 of users to do this.
Therefore, is there any other way of making the Infoobject '0EMPGROUP' as authorization relevant so that the users without selecting the values are able to run the report and see their authorized data. I have seen a Business Object report where the report shows all the line items but puts a '*' in the lines for which they not authorized to view. Is similar concept possible in Bex Reports.
Thanks & Regards,
Sai