topic Filtering drill downs in SAS Web Report Studio

Filtering drill downs

Mzee — Mon, 18 Oct 2010 23:45:46 GMT

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

Re: Filtering drill downs

AngelaHall — Tue, 19 Oct 2010 13:05:38 GMT

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

Re: Filtering drill downs

Mzee — Wed, 20 Oct 2010 03:02:36 GMT

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