We are using Excel 2007 to connect to SSAS cubes. We have many roles for a user and all having different permission including different VISUAL TOTAL setting. We want to restrict the user so that he cannot see anything if he is not using the ROLES property
in the excel connection string.
At the run time I want to know if the user who is using excel has used ROLES property or not.
Any help will be appreciated
View Complete Post