Automatic filter based on current session user

[Former Member]

Hello,

I am wondering if it is possible to create an automatic filter on a WebI report based on the current user of the system against their employee ID in the report. Ultimately I am looking for the fastest way for a user to access the data that only they are responsible for. Any suggestions are much appreciated.

Thank you,

Nicole

[Former Member]

Thank you everyone, I have discovered that you can solve this issue by customizing the script (if you have access to do so) I am currently in the process of getting the correct access for the script and will update my progress on that

[mhmohammed]

Hi Nicole,

What kind of data is that filter supposed to restrict? Is it the data by Region or Department or something else?

You can use the Employee table (if you have one) and create a filter in the Universe as below:

RegionDim.Region =

     (select distinct EmployeeDim.Region from EmployeeDim

      where EmployeeDim.Name = @variable('BOUSER'))

That filter basically filters and show the data only for the Region, which the Employee/User belongs to.

Thanks,

Mahboob Mohammed

[amitrathi239]

What is the backend database?

This you can handle by data authorisation..

[kohesco]

Nicole,

Amit is correct,

if it need to be done an reporting level, you can always use publishing/personalization for this.

Grtz

Koen

[Former Member]

Thank you for your reply! I'm curious how you would go about doing this, I am a beginner with Web Intelligence.