BookmarkSubscribeRSS Feed
JGreenberg
Fluorite | Level 6

Hi,

 

Is it possible to filter a report with a User's ID to de-identify other users on a chart, but still display the information?
In other words, if a user logs in, they will see their performance compared with their colleagues, but not be able to identify which colleague is which.

 

I found the paper on row level security on the forums quite interesting, but is that the best option in this case?

 

Thanks,

JGreenberg

1 REPLY 1
TriciaAanderud
Lapis Lazuli | Level 10

The only thing I can think that you could do is use the row-level filtering and then allow the user to compare himself against one or all of the following:

 

  • Average across all users
  • Whomever ranked the best (as the case may be)
  • Whomever ranked the least  (as the case may be)

Possibly you can show where the person ranks among their peers.  If you want to use the best and least from the peers - you would probably have to take a few extra data steps - like creating a flag for the rows that were best and worse.

 

Let us know how you solve the issue.  It's a good idea.


Tricia Aanderud

Twitter: @taanderud - Follow me!

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1197 views
  • 2 likes
  • 2 in conversation