problem with analysis manager (sql server 2000)

[zulqernain]

hi
i am using sql server 2000 analysis manger to create a cube. after i create a data cube and start processing ,in the middle of processing of cube it gives me error of "processing failed" saying "unable to connect to analysis server". i tried many a times but i get the same error again and again . Can any on etell what may be the probelm ,why it disconnect from the server?
thanks

[manju_ambare]

Sorry i m not aware of any cube that u r trying to create will u pls explain wht it is so that i'll also have some knowledge of it!

[mmetzger]

First, make sure you're running SP4 for both SQL and Analysis services. There are some assorted issues in both that SP4 helps fix. As for creating the cube, take a look at the Application event logs in the Event Viewer. Typically it will tell you something about what happened / why. Also, make sure you haven't changed the name of the SQL Server since you installed it. Sometimes the commands are not run properly as SQL uses the NetBIOS name for some internal references for security.

manju_ambare, the cube being referred to is part of the OLAP component of SQL Server called Analysis Services. It's too much of a topic to go into depth here, but effectively what you're doing is generating a set of pre-cached queries based on time (not always, but easiest way I can explain it.) Think of a table being two dimensional with rows and columns. A cube is three dimensional with tables as partitioned by time. It allows for very fast analysis of large quantities of data. The trick is that the cube must be processed (aka, the pre-cached queries must be run) often enough to keep the pertinent data available. You can install it on a SQL Server from the CD.

[zulqernain]

thanks for your reply
the server name is correct ...i rechecked by using "select @@servername " query. i am not sure about SP$ ..can you tell me ,how i can check if my sql serevre and analysis manager is with sp4 or not ?
thanks

[mmetzger]

Reference the following....

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

[zulqernain]

thanks for your response
my version is RTM developer edition...so should i download sp4 from internet?

[manju_ambare]

Will u pls explain me with example i mean how will be the query......

[mmetzger]

The later SP's fixed many issues. I'm not sure if it will fix the one you're having, but it can't really hurt.

As for an example, it's a bit much to go into in a post. Take a look at the SQL Books Online for Analysis Services.