BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
acordes
Rhodochrosite | Level 12

Dear experts,

I consider myself quite experienced with VA reports using all kind of stuff that it has to offer. 

BUT with the latest request I'm quite speechless. 

 

They ask us to build-in user-specific controls. Depending on the user's role he can access certain level of information. This could translate into the depth (or height) of an hierarchy item he/she navigates. 

I don't even know where to start, but my first idea would be:

If I had 3 user groups I would load 3 specific tables in VA, each one having its user-group specific information. 

 

And they want me to include a tree-like navigation display in the report. 

Depending on the route the user takes to delve into the information he should see a graphical representation where he/she is right now.

When I link objetcs in VA by the action functionality I can see the filters that have led to this visualisation of the target object. I would need these filters be represented graphically. 

 

Probably my post is a little bit confusing, so am I 🙂

 

Any idea will be highly welcome. 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
HarrySnart
SAS Employee

Hi @acordes , is this something that could be achieved with Row-level security? You could have one table with three types of grant on it based on user group. This video is a bit old but gives a useful overview of applying RLS in Visual Analytics: https://www.youtube.com/watch?v=s7Ogy75InVE 

 

Thanks,

Harry

View solution in original post

2 REPLIES 2
HarrySnart
SAS Employee

Hi @acordes , is this something that could be achieved with Row-level security? You could have one table with three types of grant on it based on user group. This video is a bit old but gives a useful overview of applying RLS in Visual Analytics: https://www.youtube.com/watch?v=s7Ogy75InVE 

 

Thanks,

Harry

acordes
Rhodochrosite | Level 12

Exellent Harry. 

 

With your video proposal I got to know what to search for.

And I came up with this link was even more helpful and directly applicable.

 

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/caspg/n1pfdbcsk67kgdn1t5e5bp79o50h.htm  

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
  • 2 replies
  • 297 views
  • 3 likes
  • 2 in conversation