⚠️ This page has been archived

✅ New page with updated info: ssw.com.au

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