Dimension Security

Hi,

I have Created Dimension Security by restricting the user to see only his information whoever login to the system by creating a new role. It is working fine by checking the cubes by changing the role through change user option but when the cube was integrate it to any Analysis services reporting tool(Excel, Proclarity) inspite of the roles mentioned it displays the records of all the user.

Can anyone please help me out in this situation?

guessing wildy...

if it can identify the user, they get a restricted view

if it cannot identify the user, they see everything

maybe you need to switch off some kind of anonymous access

maybe it cannot identify the user when they are coming in via one of these tools? is it possible to display the username somewhere so you can at least dis/prove this?

|||

Hi adolf,

Thanks for the reply.....

Hence we are getting the analysis services cubes to any of this tools by accessing the server directly and any of the processing in cube can be done only in server and the tool is used to only show the data. so i hope there is nothing to do with the reporting tool regarding security. something to be done with in the cube