Hi All,

I am creating a web application and I want to activate the roles of analysis
server as per the user connected with the site.

I cant achieve the purpose. I have used the connection string as follows.

Provider=msolap;Data Source=pratibha;Integrated Security=SSPI;Initial
Catalog=NewACDM;Persist Security Info=false;roles=Role1

Still it lets me access the cube dimenstions. How to activate roles with
connection string. Or there is some other thing I have to do?
..
Thanks in advance.
If any information is lacking, please ask.

Ruju