Role based Attribute Hierarchy Visible

Hi,

Is it possible with SQL Server 2005 Standard Edition to set the Attribute Hierarchy Visible property based on a SSAS role? For example the role finance can see some Attribute Hierarchies and the role Sales can't see those hierarchies.

Thanks,

Marc

You can create pespectives. There you can choose what you want to have in any Role based Dimension.

|||

Ok, but that is only an Enterprise edition feature. We use standard edition.

Thanks.