Wednesday, March 7, 2012

Can I use Reporting Services 2005 against a Analysis Services 2000 OLAP cube?

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> 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?
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/
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:1133378489.639395.34470@.g44g2000cwa.googlegroups.com...
> 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
>|||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|||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/
---
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:1133470523.084460.320180@.g47g2000cwa.googlegroups.com...
> 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
>

No comments:

Post a Comment