I have setup cost centre authorizations in SAP BW and configured an authorisation variable in the BEx Query Designer. When users log into a Web Intelligence reports which connects to the BEx Query they are restricted to the dataset configured in SAP BW.
Now I need to schedule the reports overnight so that users are sent a link for an instance which is generated for them. That is, using their authorisations.
For example, User A - restricted to America, User B - restricted to UK.
The report is scheduled and a link is sent to user A to a report which contains data for America (as this is what the report would be restricted to if they ran the report online), similarly user B gets a report restricted to UK.
The users must not be able to see the other persons instances when the login into SAP BI platform.
Im sure this is possible. I tried using scheduling and selecting "run as different user" but this didnt seem to work.