Can we use Analysis Service 2000 Cubes in 2005 Reportin Service 1

[anumala28]

Hi

Is it possible to create report using Analysis Service 2000 cubes in BI Development Visual Studio 2005.

Thanks

 

[Catadmin]

You should be able to access the cubes just fine, the same way you can access a SQL 2000 database in SRS 2005. Everything SQL 2005 is supposed to be backwards compatible with reading SQL 2000 data.

Now, there are some tools that aren't able to be used with a 2000 database, like DBMail, but those are tools which look for specific stored procedures and values in system databases, etc. SRS is technically just looking at the data.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"