Analysis Services: Query could not be processed Error

Analysis Services: Query could not be processed Error

Post by S3VydCBQZX » Sat, 01 Sep 2007 22:18:07


Hi,

I have a MSProject Server 20007 running with SQL 2005 SP2. I was able to
configure the cube building process and generated the cube data.

I then tried to create a data analysis view. However, this will only work if
I do this on the virtual mchine itself. Opening the view also only works when
opened on the machine itself. Trying to open or define the view from a remote
machine does not work. When opening the view I get the error: 'Query could
not be processed, Server Too busy or not started' in the pivottable grid.
When trying to define the view from a remote machine it seems that the
connection with the data analysis server can not be established.

I've read a couple of threads which describe problems very similar to what
I'm experiencing. However none of these threads seem to provide me with a
suitable answer. Hope I am lucky this time.
 
 
 

Analysis Services: Query could not be processed Error

Post by Gary L. Ch » Sat, 01 Sep 2007 22:53:42

Kurt:

You need to setup your client to connect to Analysis Services 2005. Here are
the steps:

Set IE Security to allow access to data across domains
Download and isntall XML 6.0 upgrade (Vista installs with this)
Download and install the Analysis Services 9.0 OLE DB Provider

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.yqcomputer.com/
For Project Server FAQS: http://www.yqcomputer.com/

 
 
 

Analysis Services: Query could not be processed Error

Post by S3VydCBQZX » Sat, 01 Sep 2007 23:04:01

Hi Gary,

I already had performed the three steps you listed. Sorry... Thanks for the
effort anyway. Perhaps you have some other suggestions?

Kurt
 
 
 

Analysis Services: Query could not be processed Error

Post by Gary L. Ch » Sun, 02 Sep 2007 00:57:02

Port restrictions in your environment
Permissions

The next likely possibilities.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.yqcomputer.com/
For Project Server FAQS: http://www.yqcomputer.com/