Adventure Works DW Overview

Business Scorecard Manager - AdventureWorks DW Workspaces

These samples will get you up and running with Microsoft Office Business Scorecard Manager 2005 utilizing the sample OLAP database provided with SQL Server™ and Analysis Services 2005 called AdventureWorks DW. The purpose of the AdventureWorks DW database is to provide a sample database for exploring the possibilities of OLAP. We have provided 5 samples scorecards to get you up and running quickly utilizing Analysis Services 2005 and Business Scorecard Manager.

The samples cover many of the measures and dimensions found within the AdventureWorks DW sample provided with SQL Server 2005. The perspectives include:

· Channel Sales

· Direct Sales

· Finance

· Sales Summary

· Sales Targets

Prerequisites

Please visit the Business Scorecard Manager (http://microsoft.com/office/bsm) for installation prerequisites and installation instructions.

SQL Server 2005 Analysis Services with the AdventureWorks DW samples installed. You can install the sample OLAP database by running the add/remove programs for SQL Server 2005 and entering the components and selecting setup to install the sample OLAP database.

Setup

Analysis Services Server:

All the Scorecard samples use a data source that points to LOCALHOST. If your OLAP database samples are located on another machine, you will need to edit the data source to point to your Analysis Services server.

Unzip Samples:

1. Unzip the samples to your computer. A good place to install them is with the other samples provided with Business Scorecard Manager. You can extract the files to C:\Program Files\Microsoft Office Business Scorecard Manager 2005\Builder\Samples.

Loading Samples Files:

1. Start Business Scorecard Manager

2. Click the FOLDER icon More… to open a sample project file.

3. Browse to the location where you stored the sample scorecard workspaces and double-click a sample file.

Publishing Scorecards:

Load the scorecards into Business Scorecard Manager and use the following steps to quickly publish the sample scorecards.

1. Load a sample Adventure Works DW scorecard sample workspace.

2. Click the PUBLISH ALL button located on the Business Scorecard Manager toolbar.

3. Click on the menu item Tools/Deploy Scorecard/To SharePoint.

4. Click the Specify Scorecard on Server Button.

5. Browse to Samples/Adventure Works DW/[scorecard name] and click OK and then click Next button.

6. Select the Default View and click Next button.

7. Enter a page name for the SharePoint page that will be published and click the Next button.

8. Enter the SharePoint URL. (i.e. http://[servername])

9. Use the default Document Library and click the Finish button.

Additional Information

Speed up your BSM deployments!

There is nothing better than great documentation to help you deploy BSM faster. The following documents were created with your collaboration and are now customer ready! Do a CONTROL+CLICK to browse the following links.

· Scorecarding 101: deployment considerations

· BSM installation: click by click instructions

· Migrating from BSA to BSM: what’s in it for your customers

· BSM technical training: 8 free and customer ready web training sessions

Training Kit

· Introduction

· BSM Builder Fundamentals

· BSM Builder Advanced

· Report Views

· Scorecard Views