Can I use Reporting Services 2005 against a Analysis Services 2000 OLAP cube? -- sql server reporting services

sql server reporting services : Can I use Reporting Services 2005 against a Analysis Services 2000 OLAP cube?

Kaisa M. Lindahl
11/30/2005 11:21:29 AM

Is it possible to create reports in SQL Server 2005 Reporting Services
against OLAP cubes based on Analysis Services 2000? Any limitations?
Any things I should know about?

I've tried to upload a report made in the SQL Server 2005 Business
Intelligence Management Studio to a 2000 edition Reporting Services,
and that didn't work out. (No surprise there, I just wanted to try it
out to see what happened. ) But would there be any problems using a
2000 OLAP cube as datasource?

All comments appreciated.

Kaisa M. Lindahl

Teo Lachev [MVP]
12/1/2005 8:18:47 AM

[quoted text, click to view]

Yes and there are known limitations. See
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp.

--
HTH,
----------------------------------------------
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
[quoted text, click to view]

Kaisa M. Lindahl
12/1/2005 12:55:23 PM

Are you thinking about the last bit ("Moving Towards SQL Server 2005"),
or using Reporting Services against OLAP cubes in general? I've already
made a few set of reports in RS 2000 based on AS 2000, so I've figured
out the limitations there. I just want to know if there are any
problems developing reports in the 2005 designer against a 200
datasource.

Sincerely,
Kaisa M. Lindahl

Teo Lachev [MVP]
12/1/2005 9:47:18 PM

What I was eluding to is:
RS 2005 & AS 2000 = RS 2000 & AS 2000

I am not aware of any aditional limitations.

--
HTH,
----------------------------------------------
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/

-------------------------------------------------
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn