Deploying an Analysis Services project.
To view the cube and
dimension data for the objects in the Analysis Services Tutorial cube in the
Analysis Services Tutorial project, you must deploy the project to a specified
instance of Analysis Services and then process the cube and its dimensions. Deploying an Analysis Services project creates
the defined objects in an instance of Analysis Services. Processing the objects in an instance of Analysis
Services copies the data from the underlying data sources into the cube
objects.
At this point in the
development process, you generally deploy the cube to an instance of Analysis
Services on a development server. Once you have finished developing your
business intelligence project, you will generally use the Analysis Services
Deployment Wizard to deploy your project from the development server to a
production server.
1.
In Solution Explorer, right-click the Analysis Services
Tutorial project, and
then clickProperties.
The Analysis Services Tutorial Property Pages dialog box appears and displays the
properties of the Active(Development) configuration. You can define multiple
configurations, each with different properties. For example, a developer might
want to configure the same project to deploy to different development computers
and with different deployment properties, such as database names or processing
properties. Notice the value for the Output Path property.
This property specifies the location in which the XMLA deployment scripts for
the project are saved when a project is built. These are the scripts that are
used to deploy the objects in the project to an instance of Analysis Services.
2.
In the Configuration Properties node in the left pane, click Deployment.
Review the deployment properties for the project. By default,
the Analysis Services Project template configures an Analysis Services project
to incrementally deploy all projects to the default instance of Analysis
Services on the local computer, to create an Analysis Services database with
the same name as the project, and to process the objects after deployment by
using the default processing option.
3.
Click OK.
4.
In Solution Explorer, right-click the Analysis Services
Tutorial project, and
then clickDeploy. You might need to wait.
5.
SQL Server Data Tools (SSDT) builds and then deploys
the Analysis Services Tutorial project to the specified instance of Analysis
Services by using a deployment script. The progress of the deployment is
displayed in two windows: the Output window
and theDeployment Progress – Analysis Services Tutorial window.
6.
Open the Output window, if necessary, by clicking Output on the View menu. TheOutput window displays the overall progress
of the deployment. The Deployment Progress – Analysis Services Tutorial window displays the detail about each
step taken during deployment.
7.
Review the contents of the Output window and the Deployment
Progress – Analysis Services Tutorial window to verify that the cube was
built, deployed, and processed without errors.
8.
To hide the Deployment Progress - Analysis Services Tutorial window, click the Auto Hide icon (it looks like a pushpin) on the
toolbar of the window.
9.
To hide the Output window,
click the Auto
Hide icon on the
toolbar of the window.
You have successfully deployed the Analysis Services
Tutorial cube to your local instance of Analysis Services, and then processed
the deployed cube.
No comments:
Post a Comment