dbTalk Databases Forums  

How to load AdventureWorksDW into Analysis Server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to load AdventureWorksDW into Analysis Server in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oded Dror
 
Posts: n/a

Default How to load AdventureWorksDW into Analysis Server - 07-16-2006 , 10:01 PM






Hi there,

I'm using SQL server 2005 and my question is
Ho to loads the AdventureWorksDW from SQL Server Database Engine into
Analysis Server database? with all the cubes dimensions etc...
like FoodsMart2000.cab file that we use to restore

Thanks,
Oded Dror





Reply With Quote
  #2  
Old   
Stijn Verrept
 
Posts: n/a

Default Re: How to load AdventureWorksDW into Analysis Server - 07-17-2006 , 06:19 PM






Oded Dror wrote:

Quote:
Hi there,

I'm using SQL server 2005 and my question is
Ho to loads the AdventureWorksDW from SQL Server Database Engine into
Analysis Server database? with all the cubes dimensions etc...
like FoodsMart2000.cab file that we use to restore
It is integrated in the setup file. Go to Add/remove programs, choose
SQL Server 2005, then choose Workstation components => Sample database
=> AdventureWorksDW.


--
HTH,

Stijn Verrept.


Reply With Quote
  #3  
Old   
Oded Dror
 
Posts: n/a

Default Re: How to load AdventureWorksDW into Analysis Server - 07-17-2006 , 09:04 PM



I do have the samples installed, All I want is to install the
AdventureWorksDW on the Analysis server

Thanks,
Oded Dror

"Stijn Verrept" <TURN_moc.tfosyrtne@njits_AROUND> wrote

Quote:
Oded Dror wrote:

Hi there,

I'm using SQL server 2005 and my question is
Ho to loads the AdventureWorksDW from SQL Server Database Engine into
Analysis Server database? with all the cubes dimensions etc...
like FoodsMart2000.cab file that we use to restore

It is integrated in the setup file. Go to Add/remove programs, choose
SQL Server 2005, then choose Workstation components => Sample database
=> AdventureWorksDW.


--
HTH,

Stijn Verrept.



Reply With Quote
  #4  
Old   
Stijn Verrept
 
Posts: n/a

Default Re: How to load AdventureWorksDW into Analysis Server - 07-18-2006 , 04:36 AM



Oded Dror wrote:

Quote:
I do have the samples installed, All I want is to install the
AdventureWorksDW on the Analysis server
Ok, then check this directory:

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks
Analysis Services Project\

It contains the solution, open it and deploy it.

--
HTH,

Stijn Verrept.


Reply With Quote
  #5  
Old   
Oded Dror
 
Posts: n/a

Default Re: How to load AdventureWorksDW into Analysis Server - 07-18-2006 , 08:20 AM



Thanks, It works
"Stijn Verrept" <TURN_moc.tfosyrtne@njits_AROUND> wrote

Quote:
Oded Dror wrote:

I do have the samples installed, All I want is to install the
AdventureWorksDW on the Analysis server

Ok, then check this directory:

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks
Analysis Services Project\

It contains the solution, open it and deploy it.

--
HTH,

Stijn Verrept.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.