SAP BI 4 - Reporting Bursting using BEx Authorisations

[Former Member]

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,

[amitrathi239 · Accepted solution]

Hi,

Have you tried from CMC to schedule for option in scheduling?

Schedule for specified users checkbox

Amit

[Former Member · Accepted solution]

Hi,

I got it working via a publication which is good. I needed to make the "country" object (the one with the authorisation variable) optional. Otherwise I am forced to select a value in the publication. Guess there is no way around this?

Is there a way to restrict access to instances to ones which have been scheduled for that user? Otherwise a user will be able to see all other instances for other users - this would make the scheduling redundant?

Cheers,

[amitrathi239 · Accepted solution]

Hi,

in this case select the destination is BI Inbox for users.Then users cannot see others instance.

Amit