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
>

Can I replicate SBS SQL to a full install of SQL

I am running SBS 2000. I use SQL (in SBS) as the transactional database for
Great Plains and Sales Logix. I want to set up an OLAP environment for data
mining, but I want to put the OLAP stuff on another server. My plan is 1)
buy a new server, 2) buy/install Win2003 Server and SQL Server 2003 on the
new server and 3) replicate the SQL from SBS to the new server for OLAP
access. Someone told me that SQL within SBS can not be replicated to a
full-blown SQL installation, but searching the Web and newsgroups, I haven't
found anything that supports or denies that fact. Does anyone know of a
reason that I can't replicate my SBS SQL out to a SQL 2000 or SQL 2003 box?
If I can't. is there another migration path?
Thanks!
I know of no such reason.
"Toltar" <Toltar@.discussions.microsoft.com> wrote in message
news:D532AFDB-61C2-4EA3-AF7E-3400C3E48031@.microsoft.com...
>I am running SBS 2000. I use SQL (in SBS) as the transactional database
>for
> Great Plains and Sales Logix. I want to set up an OLAP environment for
> data
> mining, but I want to put the OLAP stuff on another server. My plan is 1)
> buy a new server, 2) buy/install Win2003 Server and SQL Server 2003 on the
> new server and 3) replicate the SQL from SBS to the new server for OLAP
> access. Someone told me that SQL within SBS can not be replicated to a
> full-blown SQL installation, but searching the Web and newsgroups, I
> haven't
> found anything that supports or denies that fact. Does anyone know of a
> reason that I can't replicate my SBS SQL out to a SQL 2000 or SQL 2003
> box?
> If I can't. is there another migration path?
> Thanks!