Email : info@epmstrategy.com | Call Us Now : 479-373-1374
:: Home :: Sitemap ::
Follow Us

Project Server 2010 OLAP Cube Permission Errors

BY:  Ali Salih

 

Just a quick note for a strange error we got while trying to get an OLAP cube to work in Project Server 2010.  The problem seems to be that we were using a non-default directory for Analysis Services.  Every time that we ran the cube we got the following error message:

===== Initiating OLAP database build process =====

[12/17/2012 8:37 AM] Cube build request message has been added to the Project Server queue

===== Verifying and running pre-build server event handler =====

[12/17/2012 8:37 AM] Verifying and running pre-build server event handler

===== Determining database and OLAP database structure =====

[12/17/2012 8:37 AM] Cube build initialization started

[12/17/2012 8:37 AM] OLAP database and cube structure was determined successfully

===== Building database and cubes =====

[12/17/2012 8:37 AM] Cube build session started

[12/17/2012 8:37 AM] Analysis Services server failed to build OLAP database. Error: Error Adding DataSource ‘Project Reporting data source’ to database ‘Proj10Cube’. Error: Errors in the metadata manager. Either the database with the ID of ‘Proj10Cube’ does not exist in the server with the ID of ‘xxxxx’, or the user does not have permissions to access the object.

===== Process Completed =====

[12/17/2012 8:37 AM] Failed to build the OLAP cubes. Error: Error Adding DataSource ‘Project Reporting data source’ to database ‘Proj10Cube’. Error: Errors in the metadata manager. Either the database with the ID of ‘Proj10Cube’ does not exist in the server with the ID of ‘xxxxx’, or the user does not have permissions to access the object.

This error might be due to NTFS permissions on the data directory for OLAPDATA. A permission addition might be needed.  Since we were using a non default directory, the normal settings weren’t automatically set.

  • Add the SQLServerMSASUser${SERVERNAMEHERE}$MSSQLSERVER local security group to the data directory for Analysis Services.

You can check the data directory from properties on Analysis Server, Right Click and go to Properties.

 

 

Comments

 

Leave a Reply

You must be logged in to post a comment.