Re: How to create or learn AdventureWorks Data Warehouse

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi amish,

It is 'SQL Server 2005 Analysis Services Tutorial", it assumes that
"'Adventure Works Data Warehouse" was well-developed and then to start to
create cube by AS.

What I am looking for is how to create fact/dim tables in ''Adventure Works
Data Warehouse".



"amish" <shahamishm@xxxxxxxxx> wrote in message
news:1160391925.433024.115200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

frankie lo wrote:

Would like to learn how to create Data Warehouse. "AdventureWorks Data
Warehouse" sample is great sample. but it seems like that there is no
source/book to show that how to generate it from "AdventureWorks OLTP".

I would like to want to know the "PROCESS" or 'WHY ->>>> design these
fact
or dim tables" and "Business Logic" behind.

I know that there are many sources to show the process from
'AdventureWorks
Data Warehouse " to "AdventureWorks AS or Cube", BUT there is few source
to
show the process from "AdventureWorks OLTP" database to "'AdventureWorks
Data Warehouse".

Any advices????
you can find a good start from here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/db55e226-601a-4026-8651-573195555a59.htm

Regards
Amish Shah



.

Relevant Pages

  • How to create or learn AdventureWorks Data Warehouse
    ... Would like to learn how to create Data Warehouse. ... source/book to show that how to generate it from "AdventureWorks OLTP". ... show the process from "AdventureWorks OLTP" database to "'AdventureWorks ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Dynamic FORMAT_STRING for Measure
    ... Anyone who has looked at the AdventureWorks sample cube will probably ... FORMAT_STRING can now be defined with an MDX expression (in AS2K it was ... For example, in the Adventure Works cube, if you add this calculation to ...
    (microsoft.public.sqlserver.olap)
  • Re: How to create or learn AdventureWorks Data Warehouse
    ... Warehouse" sample is great sample. ... source/book to show that how to generate it from "AdventureWorks OLTP". ... I know that there are many sources to show the process from 'AdventureWorks ...
    (microsoft.public.sqlserver.datawarehouse)