topic How do i filter a report based on the ID logging into WRS in SAS Web Report Studio

How do i filter a report based on the ID logging into WRS

jb9977 — Thu, 27 Jul 2017 20:44:07 GMT

I have created a report ( data for my report comes from OLAP cube to information maps and to WRS). I want to apply a filter or row level securtity so that when a employee logins into web report he can only see the repost based on his information.

Thanks,

Jay

Re: How do i filter a report based on the ID logging into WRS

Madelyn_SAS — Thu, 27 Jul 2017 20:55:16 GMT

You would need to use MDX expressions to secure the cube. See "Securing Cubes" in the SAS OLAP Server User's Guide:

http://support.sas.com/documentation/cdl/en/olapug/69844/HTML/default/viewer.htm#p0o4012mg42akan1snunw1wkjymj.htm

The row-level permissions that you can set up in SAS Information Map Studio apply only to relational data.