|
|
Sample for Article: KPIs in Analysis Services
File Details
| Downloads: |
114 |
File Size: |
7.2kB |
| Posted By: |
Gogula G. Aryalingam |
Views: |
194 |
| Date Added: |
Mon, May 12 2008 |
|
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'.
|
|
|