I had a quick look around and it is not easy to find. AS MS has declared 2000 as non supported getting help is going to become more and more...

Not too sure what you are asking for.

If you are asking to automate running a package then use a SQL Server Agent job to run the package every day /...

have you got excel on the server where you are trying to attach to the 2000 cubes. If you have Excel 2003 on there then I have attached how you...

I think you need to do a prototype. Even if you do it on paper to get the layout. I cant see someone is going to sit down and look...

PSB1 (8/18/2009)

---

Thanks for your response. I was under the impression that was true too. But I'm connecting from a 64 bit 2K5 box to a 2K cube on another server....

Books - SQL Srever Analysis Services 2005 step by step. 2008 is now available.

SSAS info website

Mosha.com - all sorts of info on MDX

[/url]

Ells.

😎

I am a complete dunce at SSRS so apologies if this is completely wrong.

OLEDB Provider for OLAP 9.0 is the provider used to access SSAS (2005) cubes not analuysis services...

People are funny old things. The most commonly requested report is the evrything report. I have seen people fill Excel spreadsheets to more columns and rows than you can possibly...

I would probably want to know what question are you really asking the cube? The reason I ask is that I am certain that someone is not coming to you...

As nobody has mentioned this so far I believe that if the company is a MS partner then depending on the number of certificates and certificated people they may be...

Mr Fox sir,

I see you are a man who likes to pull someones chain.

Ells.:cool:

As the reply is quite long I have attached a word doc. This shows the creation of a dimension same as yours, the fact table presented slightly differently. There are...

I should have added:

Having created a package to check and load this could be scheduled through SQL Server Agent to run every xx minutes.

I have to admit I like...

Get a range of books on the subject. See if there are any free conferences \ events you can go to. These are great places to meet people and you...

MS certification as it stands will never be proof of quality. this creates some backlash as people expect exactly that. Now if certification was only available to people working in...