Filtering drill downs

[Mzee]

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

[AngelaHall]

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

[Mzee]

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