Traditional web-based reporting with SAS BI tools

Filtering drill downs

Reply
New Contributor
Posts: 3

Filtering drill downs

Hi All,
This might be simple; I am trying to filter OLAP cubes so that the people viewing the reports can drill through some levels and not others. Is there a way I can do this as I am new to OLAP cubes.
Thanks
SAS Employee
Posts: 238

Re: Filtering drill downs

It sounds like you're interested in setting a filter based on the group the user is in.
An example - the Sales team would only see Sales data, where the Executives could see everything.

Check out the SAS 9.2 documentation summarizing Cube Security:
http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212372.htm

There are several different ways to do this, however you might find the first to be the easiest to implement. (Permissions on Cube Dimensions)

~ Angela
http://sas-bi.blogspot.com
New Contributor
Posts: 3

Re: Filtering drill downs

Angela,

Thanks for the link. I think the versions of OLAP studio and Management Console I am using dont have most of the selection items.

Mzee
Ask a Question
Discussion stats
  • 2 replies
  • 178 views
  • 0 likes
  • 2 in conversation