2.3 deploy the Analysis Services Project

to view the Multidimensional Dataset and Dimension Data of objects in the analysis services tutorial cube of the Analysis Services Tutorial Project, you must deploy the project to a specified instance of analysis services, then process the cube and its dimensions. When you deploy an Analysis Services project, you will create a defined object in the analysis services instance. Processing objects in an analysis services instance copies data from the basic data source to a multi-dimensional dataset object. For more information, see ,

During the development process, this cube is deployed to the Analysis Services instance on the development server. When developing a business intelligence project, the Analysis Services Development wizard is usually used to deploy the project to the production server. For more information, see ,

In the following task, you will view the deployment properties of the Analysis Services Tutorial Project, and then deploy the project to the local instance of the Analysis Services.

Deploy an Analysis Services Project

2. in Solution Explorer, right-click the Analysis Services tutorial project, click "properties" .

   the Analysis Services tutorial property page dialog box is displayed, and the properties configured for the activity (development) are displayed. Multiple configurations can be defined, and each configuration can have different attributes. For example, different developers may need to deploy the same project to different development computers and have different deployment attributes, such as different database names or processing attributes. Note the value of the "output path" attribute. This attribute specifies the location where the xmla deployment script of the Project is saved when the project is generated. These scripts deploy the objects in the project to the Analysis Services instance.

3. On the "configuration properties" node in the left pane, click "deploy" .

   View the deployment properties of a project. By default, the Analysis Services Project template configures the Analysis Services Project to incrementally deploy all projects to the default Analysis Services instance on the local computer to create an analysis services database with the same name as this project, and use the default processing option to process these objects after deployment. related topics:

   if you want to deploy a project to an analysis services instance or an instance on a remote server on a local computer, change the "server" attribute to the corresponding instance name, for example, server name >\ Instance name >.

   the "Analysis Services tutorial property page" dialog box is displayed.

5. if you do not want to change the value of the "server" attribute, click "cancel" . Otherwise, click OK .

6. in Solution Explorer, right-click the Analysis Services tutorial project, click "deploy" , alternatively, click deploy Analysis Services tutorial On the Generate menu.

   business intelligence development studio generates the Analysis Services Tutorial Project and deploys it to the specified Analysis Services instance using the deployment script. The deployment progress is displayed in the "output" window and "deployment progress-Analysis Services tutorial" window. The "output" window shows the overall deployment progress. The "deployment progress-Analysis Services tutorial" window displays detailed information about each step during the deployment process. related topics: ,

8. Open the "output" window. If necessary, click"View"On the menu"Output".

   Deploy the Analysis Services Tutorial Project as shown in the following figure:"Deployment progress-Analysis Services tutorial"Window and"Output"Window.

10. View"Output"Window and"Deployment progress-Analysis Services tutorial"Window to verify whether the multi-dimensional dataset has been generated, deployed, and processed, and no error occurs.

12. In"Deployment progress-Analysis Services tutorial"Window, expand in sequence"The processing of dimension 'customer' has been completed successfully"Node,"The processing of dimension attribute 'job' has been completed successfully"Nodes and"SQL query 1"Node.

14. Double-clickSelect distinctStatement.

    This interface is used to process the query of the "job" attribute in the "customer" dimension in"View Details"The dialog box is displayed.

    To display the query that is used to process dimension attributes.

16. Click"Close".

18. Fold"The processing of dimension 'customer' has been completed successfully"And expand"The Multidimensional Dataset Analysis Services tutorial has been processed successfully"Node,"Processing of the measurement value group 'Internet sales' has been completed successfully"Node,"The partition 'internet' sales has been processed successfully"Nodes and"SQL query 1"Node.

    The query is used to process the "Internet sales" partition in the analysis services tutorial multi-dimensional dataset.

20. Click"Hide automatically"Icon to hide"Deployment progress-Analysis Services tutorial"Window.

22. Click"Hide automatically"Icon to hide"Output"Window.

You have successfully deployed the Analysis Services tutorial cube to the local instance of Analysis Services and processed the deployed cube. You are now ready to browse the actual data in the cube.