Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

restriction on webi report

Does anybody help me with following problem?

I have completed report in webi. And I need to define restrictions (limited view) for various users viewing reports in webi aka where restriction on table.

For example: I have a report - one table with column 'name_user' and I need following procedure: User 'Bob' can view report in webi but he can only see data aka where column_name='Bob', next example Bob can view only data for one Region.

Thank you for reply.

Marika

Former Member
Former Member replied

i think its not the right place to add this post, but anyway i'm gonna answer here

i think you are looking for

Variable('BOUSER')

which returns the UserName of the current connection session user name

use this at the universe level, just add some condition in the where section of all the dimensions of this table

name_user = Variable('BOUSER')

good luck

Amr

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question