Wednesday, March 7, 2012

How to implement OLAP

Hi,
I have an SQL Server 7 transaction Database for which I want to implement
OLAP.
I had a play around with OLAP using SQl server 7 but I now wish to give it a
go using an SQL server 2000 platform.
I can't find any mention of OLAP under SQl server 2000.
Questions.
1) Assuming it exists, can a SQL server 2000 OLAP form its cube from a
Server 7 transaction database?
2) If so, where is the installation? I had a look at SQL Server 2000 install
and advanced server install but couldn't find it.
Thanks
Bob
on the CD Rom, there is a folder with the OLAP server on it, search in the
root folders
but, normally, the auto startup application (when you insert you CD Rom)
provide a direct link to install analysis services.
"Bob" <bob@.nowhere.com> a crit dans le message de news:
eOtn%23i3mEHA.3896@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an SQL Server 7 transaction Database for which I want to implement
> OLAP.
> I had a play around with OLAP using SQl server 7 but I now wish to give it
> a
> go using an SQL server 2000 platform.
> I can't find any mention of OLAP under SQl server 2000.
> Questions.
> 1) Assuming it exists, can a SQL server 2000 OLAP form its cube from a
> Server 7 transaction database?
> 2) If so, where is the installation? I had a look at SQL Server 2000
> install
> and advanced server install but couldn't find it.
> Thanks
> Bob
>

No comments:

Post a Comment