Cant connect to analysis services via excel

sql-server olap business-intelligence ssas
AJM picture AJM · Jan 8, 2010 · Viewed 10.7k times · Source

I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end.

When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database"

Obviously the first user has the correct permissions, but how do I set up analysis services to allow other users to join the party?

Answer

Raj More picture Raj More · Jan 8, 2010

Login to the machine with an account that is an administrator (Domain\CubeAdmin) on the cube. Connect to the cube in BIDS (run devenv.exe and open Analysis Services Database).

Under Roles, create a reader role and in the Membership tab, add the user account (Domain\NewUser).

All this will only work if the SSAS Server Administrator gives the Domain\NewUser access to the server.

Related questions

SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio. I create one project of Business Intelligence Project I create a Data Source Of Adventure Work 2008 DW and then i create one Data Source View and then i …

Read More
What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. …

Read More