Thursday, December 30, 2010

The cube should be active to make a call on this method

Hi All!

Recently came across an error "The cube should be active to make a call on this method" while using SQL Server Analysis Services (SSAS). I have set up the analysis services database and process it using visual studio. Everything was fine. Data was also available in the tables. But still unable to see the reports.

Here is the fix for the error:
Go to SQL Server Analysis services
Right Click on the Analysis Server and open Properties
Go to Security Tab. There you will find Users and Groups.
Click on Add and select ASPNET, IUSR, NETWORKSERVICE, NETWORK and Everyone and save.

Now you wil be able to see the reports.

Tags: SSAS, SQL Server Analysis Services, The cube should be active to make a call on this method, SSAS Reports, Cube Error, Cube Authentication Error

1 comment:

SQL training said...

SQL learning here: http://www.sqlsteps.com