Dynamic data filter with user login

[abhilashatiwari]

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.

[LinusH]

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?

[abhilashatiwari]

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

[vivek_sas]

Yes It is Possible . Please check the below link

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

[MichelleHomes]

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

[abhilashatiwari]

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