Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Dynamic data filter with user login

Reply
Contributor
Posts: 31

Dynamic data filter with user login

Hi All,

I want to dynamically set the data filter of the report, with the type of user login. 

I do not want to use "Row level security"as it will filter the data on the basis of the logins.

 

For example, What I wish to achieve in my report is:

Three user id:

John (deals with USA data)

Sara (deals with Australia data)

Marc (deals with Europe data)

So, now when John logs in, he shuould be able to see the report dynamically filtered on USA data as per his login, but he should also be able to see the report for Ausrtalia and Europe data by changing the options in the report filter.

 

Please let me know, if it is possible or if anyone has already done this type of filtering in SAS VA for their reports.

 

Thanks,

Abhi.

Super User
Posts: 5,256

Re: Dynamic data filter with user login

What are you saying: should the user have a default filter (corresponds to his/hers interests), but are allowed to see all data, by explicitly requiring it?

Data never sleeps
Contributor
Posts: 31

Re: Dynamic data filter with user login

Yes, Thats what I am looking for.  May be its not possible , but just wanted to give it a try.

Occasional Contributor
Posts: 14

Re: Dynamic data filter with user login

Yes It is Possible . Please check the below link

 

http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

Trusted Advisor
Posts: 1,248

Re: Dynamic data filter with user login

Hi @abhilashatiwari,

 

As you have discovered row level security will subset the data visible to the user and won't meet the requirements you are after. Unfortunately there isn't a way to save a default filter value on a per user per report basis in the latest SAS Visual Analytics 7.3 release.

 

Kind Regards,

Michelle

Contributor
Posts: 31

Re: Dynamic data filter with user login

Hi,

I tried to use parameters in my url and it works fo me. I refered to the blog below:

http://blogs.sas.com/content/sgf/2015/09/16/accessing-va-reports-with-parameterized-urls/

But, it would be great if SAS had these features automated.

Regards,

Abhi

Ask a Question
Discussion stats
  • 5 replies
  • 666 views
  • 0 likes
  • 4 in conversation