Home
>
Archive
>
SSW Standards
>
Rules
>
SSW Rules to Better Business Intelligence - Setting up Resources
Attaching the AdventureWorks2000DW Data Warehouse Database
In Enterprise Manager, right click
Databases
->
New Database
...
Create a database with the name "AdventureWorks2000DW".
Refresh the Enterprise Manager view so that the new database is
displayed. Right click the AdventureWorks2000DW database that you just
created, and select
All Tasks
->
Restore Database
...
In the
Restore
radio button group select "From Device", click
Select Device
. Click
Add
and select the file that you downloaded (and uncompressed) to restore
the database.
Note: you will need to make sure there are no current connections to
the database.
Bring in the AdventureWorks2000 Cube
In Analysis Manager, right click server -> Restore Database. Select
the .cab file to create the Reseller Sales cube.
You might need to change the data source for the new cube, if you used
an a different database name in the above steps. In the data source
dialog reselect the appropriate table and configure any security
information.
You might want to fix some of the properties of the cube. Check out
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterBusinessIntelligence.aspx
for some rules that we think are important.
Acknowledgements
Andrew Weaver
Adam Cogan
Grant Paisley