title: How can I give access to a specific cube in PowerPivot?
body: <p>This is my first time trying to grant access to one of my users to view a specific analysis cube via PowerPivot in Excel.</p>
  
  <p>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.</p>
  
  <p>I've created a role for this user and set a read permission only for a specific cube.</p>
  
  <p>I've open Excel on my local computer > selected Data > From Other Source > From Analysis Services</p>
  
  <p>Entered the server address and login details. Then I had 3 problems:</p>
  
  <ol>
  <li><p>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?</p></li>
  <li><p>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?</p></li>
  <li><p>After connecting to the cube and starting the work process, WHAT IS MY INDICATOR FOR KNOWING ON WHICH CUBE I'M WORKING ON?</p></li>
  </ol>
  
  <p>Thank you so much!</p>