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.
Amr Salem 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
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')