Hi Jamie, you've got a lot of great info and I really appreciate you helping me out.  You've answered my questions and I'm sure of which route I want...

Jamie, your answer is exactly what I was looking for.  So is it my understandin also that the same amount of Hard drive space is used weather you use Rolap,...

I use Analysis Manager to connect.  Nothing out of the ordinary.

Thanks

Guys, it looks like all of your suggestions are done outside Analysis Services.  Remember I'm a little new to this so I'm not 100% sure why I can't do this...

Thank you all for your input.  I loaded sp3 and now I am all set.  I guess they were saying the server was running sp2, but they were incorrect.

Thanks again,...

P.S.

I can ping it using the servers text name.

Actually I just found out that they are using Local info, not Domain.  Does this make a difference.  When you asked if the service is running, are you speaking on...

Yes.  I am told that I am part of the domain.

Steve, I went to the site you supplied but there was no code.  All I see is the users guide.  Are you saying I should look up the filesystemobject?

Thanks for...

Steve, I am utilizing Microsoft OLE DB Provider for OLAP Services 8.0. It makes the connection, sees the cube, but when I drag and drop a field onto the...

Yes I found them. Thanks. However, how do I get these out into a line chart showing the actual movement? This part of it is very confusing...

How do I keep it from eating all my memory up?

That is expected behavior. As it caches data it will hold it to make subsequent queries faster.

Andy

http://www.sqlservercentral.com/columnists/awarren/

[/quote]

Thanks Guys. Another question. I'm looking through all my MSDN CD's and I can't find it. Does it come bundle with something that I am unaware of? ...

quote:

---

Have you tried setting them on the linked server for connections? (providing it does cause problems elsewhere!)

How would I do that? ...

Thanks Greg, that works nicely.