This is my first time trying to grant access to one of my users to view a specific analysis cube via PowerPivot in Excel.
We are working with Excel 2010, I've created a local user on the server itself and add it to analysis from the SQL management studio.
I've created a role for this user and set a read permission only for a specific cube.
I've open Excel on my local computer > selected Data > From Other Source > From Analysis Services
Entered the server address and login details. Then I had 3 problems:
1. It shows me ALL the cubes and all databases that are available on the analysis server,
WHY DOES IT HAVE A PERMISSION TO SELECT THEM?
2. After choosing the cube that I want I got this error: "An Error was encountered in the Transport layer", but when I clicked OK I got a "Multidimentional Connection 11.0" window that asked me for my login details again,
and after I entered them it gave me access.
HOW CAN I AVOIDE THIS ERROR?
3. After connecting to the cube and starting the work process, WHAT IS MY INDICATOR FOR KNOWING ON WHICH CUBE I'M WORKING ON?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.