Skip to Content
0
Former Member
Aug 18, 2015 at 01:32 PM

SAP BI 4 - Reporting Bursting using BEx Authorisations

72 Views

Hi,

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.

Any ideas?

Cheers,