I have an instance of Analysis Services set up with my cube and am attempting to access it through MS Excel.
This works for one of my accounts but not for another. My goal is to get the second account to be able to access the cube just like the first. However, I am not sure what permissions I am missing for the second.
I have added the second user as an administrator on Analysis services and even on the SQL Server instance and yet can't get past the below error.
How does my second account need to be set up to access the cube?
The server name looks like: https://[server]/OLAP/msmdpump.dll