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