Sample for Article: KPIs in Analysis Services

Gogula G. Aryalingam — Mon, 12 May 2008 00:46:59 GMT

The attached file is to be used as the sample for the article KPIs in Analysis Services by Gogula G. Aryalingam. The file includes a sample cube. Download the file, extract it to your hard disk and follow below instructions to setup the sample cube.

Copy the included file 'KPISample.asdatabase' to a preferred folder.
Start the Analysis Services Deployment Wizard:

Start -> Programs -> SQL Server 2005 -> Analysis Services -> Deployment Wizard

In the Deployment Wizard:

Click on 'Next' on the Welcome screen.
In the 'Specify Source Analysis Services Database' page, click on the ellipsis (...) button, navigate to and open the KPISample.asdatabase file.
Click on 'Next'.
In the 'Installation Target' page, specify your Analysis Server. Leave the Database name as it is.
Click on 'Next'.
In the 'Specify Options for Partitions and Roles' page, just click on 'Next'.
In the 'Specify Configuration Properties' page, select the 'AdventureWorks' property under 'Data Source Connection Strings'.
Click on the ellipsis (...) button of the property.
In the 'Connection Manager' dialog that appears, setup a connection to the AdventureWorks database of your SQL Server instance.
Test the connection and click on 'OK'.
Click on 'Next'.
In the 'Select Processing Options' page, select the 'Full Processing' radio button.
Click on 'Next'.
In the 'Confirm Deployment' page, just click on 'Next'.
The wizard will now process and deploy the cube to your Analysis Server instance.
Click on 'Next' and 'Finish'.

20080612_01_KPIs_In_Analysis_Services

Sample for Article: KPIs in Analysis Services