Home > Archive > MS SQL Server OLAP > March 2006 > use foodmart 2000 with sql server 7.0









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author use foodmart 2000 with sql server 7.0
OLAP 7.0 User

2006-03-17, 1:24 pm

I am using SQL Server 7.0 OLAP services, as SQL Server 2000 has issues with
Windows XP. However I want to use the Foodmart 2000 datawarehouse with SQL
Server 7.0. Is it possible to import the entire repository along with all the
cubes and dimensions, etc. into SQL OLAP Server?

Please tell me how to do it, if it is possible.

Thanks in advance.


Darren Gosbell

2006-03-17, 8:24 pm

No, you can't import 2000 cubes back into Olap Services. However Olap
Services 7.0 did come with its own Foodmart sample database.

What issues were you having with SQL Server 2000? I am running the
developer edition on my Win XP laptop and it works fine.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <2FEEDADC-6D94-4911-A155- D12A0EAD488C@microso
ft.com>, =?Utf-
8?B? T0xBUCA3LjAgVXNlcg==
?= <OLAP 7.0 User@discussions.microsoft.com>
says...
> I am using SQL Server 7.0 OLAP services, as SQL Server 2000 has issues with
> Windows XP. However I want to use the Foodmart 2000 datawarehouse with SQL
> Server 7.0. Is it possible to import the entire repository along with all the
> cubes and dimensions, etc. into SQL OLAP Server?
>
> Please tell me how to do it, if it is possible.
>
> Thanks in advance.
>
>
>


OLAP 7.0 User

2006-03-30, 1:30 pm

Thanks a lot for answering..... actually now I have been able to successfully
instal OLAP services of MS SQL 2000 on my computer. The problem was that I
did not install the service packs od sql server and sql server analysis
services. Installing them corrected the various issues...

Thanks and Regards
OLAP User

"Darren Gosbell" wrote:

> No, you can't import 2000 cubes back into Olap Services. However Olap
> Services 7.0 did come with its own Foodmart sample database.
>
> What issues were you having with SQL Server 2000? I am running the
> developer edition on my Win XP laptop and it works fine.
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <2FEEDADC-6D94-4911-A155- D12A0EAD488C@microso
ft.com>, =?Utf-
> 8?B? T0xBUCA3LjAgVXNlcg==
?= <OLAP 7.0 User@discussions.microsoft.com>
> says...
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com