"Design Storage and Process the Cube" issue

[misscrf]

To anyone who can help,

I am reviewing the processes in the Analysis Manager, and I am going through the sample exercises offered by SQL Server's Analysis Manager Help.

So far, every step has been successful, but now I am running into a problem. If you have the Analysis Manager installed, you should be able to follow this directory to see the instructions I am following.

C:\Program Files\Microsoft Analysis Services\Help80\Tutorial\design_stor_proc.htm

When I attempt to process the design storage to set the aggregations, it is failing. I get the following error for why the process has failed:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified;IM002; Time:8/26/2004 5:25:00 PM

If you understand why this is happening, I would appreciate any tips. If I go to redo the process it does show that I already have aggregates for the cube. Does that mean it actually worked, or am I correct in my assumption that the error is pointing to a problem that I need to resolve. Thanks for any information!

Courtney

ps, the cube editor shows the tables, and you can browse the data. This part really confuses me. Where did I go wrong?

 

[misscrf]

OK now I got the cube to process, but when I go to view the data it says unable to to display the cube until it has been processed. (unspecified error) OK, I processed the cube. It processed successfully. What does this mean?
Thanks

 

[misscrf]

well, here is the thing. I am following the analysis service's getting started tutorials. I just don't get it. I set up the Tutorial connection and such, the cubes, dimensions, everything. But the cube just wont process. It does when I change the source to FoodMart 2000, but then the HR cube wont process. It should work under the Tutorial source anyway. I want to see this whole process work so that I can feel confident in my use of SQL Server. Any suggestions in why this process is not working?
Thanks.

misscrf

Management is doing things right, leadership is doing the right things

 

[misscrf]

never mind. I started over again from the beginning after installing sp3 and now it seems to be going good.

misscrf

Management is doing things right, leadership is doing the right things