cmcharly


We are incorporating some OLAP cubes into our secure website and what to restrict the cubes information base on the person or client logged in. We are using Dundas OLAP as the front end for displaying the cubes. The Roles approach is not a viable solution since it is impossible for us to gather and keep track of our client*s windows usernames.

 

Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members




Re: Dynamic Dimension Security using something else than ROLES

Mosha Pasumansky


> Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members

Yes, there is a connection string property called "Roles", where you can specify which Roles should be used.







Re: Dynamic Dimension Security using something else than ROLES

cmcharly

I did a little bit of digging on connection string properties and came across this in one of your blogs.

There is a new MDX function for SSAS 2005 called ※CustomData§.

http://sqljunkies.com/WebLog/mosha/archive/2005/10/11/mdx_functions_as2005.aspx

I am using the ※Roles§ and ※CustomData§ properties of the connection string to achieve my purpose.

Thanks Mosha