Skip to Content
avatar image
Former Member

Distribute same Web Intelligence report to different users

I just started using SAP Web Intelligence and I have a couple of reports ready to deploy for end users. The report includes a "Region" field, and I want each user to be able to only see data in their respective "Region". I know I can make several copies of the report and filter by each region, but this will make it difficult to maintain. Does anyone know how I can use the same Report but set different filters for the end-users?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 01, 2016 at 05:02 PM

    What is your backend database?

    If it's universe then option is to implement row level security.

    https://blogs.sap.com/2014/07/03/implementing-row-level-security-in-idt-using-data-security-profile/

    If it's BW and reports on BICS connection then enabling the SSO and implementing the Data authorisation in BW will handle your requirement.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 03, 2016 at 08:00 PM

    You can also refer to the below blog post.

    https://blogs.sap.com/2012/07/05/user-attribute-mapping-in-bi4/

    -Faiz

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2016 at 04:15 PM

    You can create a publication, using the Dynamic Recipients functionality. For that, you'll need to first create another Webi, where has entries for ID/Region/email for example, where:

    ID (any unique name you give to that specific slice of users), Email (users' email), Region (the region selection for that specific ID/user)

    Add comment
    10|10000 characters needed characters exceeded