Traditional web-based reporting with SAS BI tools

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

Reply
Occasional Contributor
Posts: 8

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

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

SAS Super FREQ
Posts: 435

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

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#p0o4012mg42akan1snu...

 

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

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 185 views
  • 0 likes
  • 2 in conversation