BookmarkSubscribeRSS Feed
Chokin
Fluorite | Level 6

We are starting to design our reporting framework.

 

We have 2 questions which we would appreciate some input.

 

1. We need to restrict the viewing of certain reports with a dashboard which contains mulitple reports to specific user groups.   What is the best practise for this?  In SMC, best practise would suggest that this should not occur at the object level.

 

2. In terms of drilldown functionality - what is the best practise for restrict drilldown by specific user groups for the same report?

    i.e We may want a senior staff to be able to drill all the way down into the line level data however other staff to only access to higher level information.

 

Many thanks

Richard

 

 

 

 

 

2 REPLIES 2
muralavenu_gmail_com
Obsidian | Level 7

Hi There,

 

If you want to restrict the viewing of data or certain reports which contains mulitple reports\sections in Single Report, you need to use Administrator in SAS VA.  

First of all you need to know the imported data where it is stored stored.

Please find the attached document for detailed information.

 

Before applying Row-Level-Security, the User\s or Group Identity should be ready in SMC. SAS Admin will make it ready for you.

 

Thanks & Regards,

Venu Murala  | Sr. SAS Consultant, USA

Venu Murala
Chokin
Fluorite | Level 6

Hi Venu

 

Many thanks for your response.  This is great.

 

We are using Visual Analytics version 7.1.  Unfortunately we do not have Conditional Grant available in the drop down as per your list of instructions.  I have enclosed a screenshot.

 

One final question, is there any way that we can restrict by variable name for particular users or user groups?

 

Thanks again

Richard

 


Capture.JPG

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 2381 views
  • 0 likes
  • 2 in conversation