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. For more
information, see Deploying
Analysis Services Projects, Configuring Analysis Services Project Properties
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. For more
information, see Planning an
Analysis Services Deployment, Using the Analysis Services Deployment Wizard
In the following task, you review the deployment
properties of the Analysis Services Tutorial project and then deploy the
project to your local instance of Analysis Services.
To deploy the
Analysis Services project
1.
In Solution Explorer, right-click the Analysis
Services Tutorial
project, and then click Properties.
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. Related topic: Configuring
Analysis Services Project Properties
3.
Click OK.
4.
In Solution Explorer, right-click the Analysis
Services Tutorial
project, and then click Deploy.
Business Intelligence Development Studio 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 the Deployment Progress - Analysis Services Tutorial window. Open the Output
window, if necessary, by clicking Output on the View menu. The Output window displays the overall progress of the deployment. The Deployment Progress - Analysis Services Tutorial window displays the
detail about each step taken during deployment. Related topics: Building Analysis
Services Projects,
Deploying
Analysis Services Projects
5.
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.
6.
Hide the Deployment Progress - Analysis
Services Tutorial
window by clicking the Auto Hide icon on the toolbar of
the window.
7.
Hide the Output window by clicking 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.
Browsing the Cube
After you deploy a cube, the cube data is
viewable on the Browser tab
in Cube Designer, and the dimension data is viewable on the Browser tab in Dimension Designer.
To browse the
deployed cube
1.
Switch to Dimension Designer for the Product dimension
in Business Intelligence Development Studio. To do this, double-click the Product dimension in the Dimensions node of Solution
Explorer.
2.
Click the Browser tab to display the All
member of the Product Key attribute hierarchy. In lesson three, you
will define a user hierarchy for the Product dimension that will let you browse
the dimension.
3.
Switch to Cube Designer in Business
Intelligence Development Studio. To do this, double-click the Analysis Services Tutorial cube in the Cubes node of Solution Explorer.
4.
Select the Browser tab, and then click the
reconnect icon on the toolbar of the designer.
The left pane of the designer shows the objects
in the Analysis Services Tutorial cube. On the right side of the Browser tab there are two panes: the upper pane is the Filter pane, and the lower pane is the Data pane. In an upcoming
lesson, you will use the cube browser to do analysis.
|
|
Mr. Ravi Krishna
- Senior Software Engineer
|
|
I am a Mocrosoft ASP.net Developer and MCP Certified professional. I have overall 5 years of experience in IT Industry,in that 3 years experience in Microsoft BI(SSAS,SSIS,SSRS). I have experience on various business domains like Automation and Chemical.
|
|
|
|
https://sites.google.com/site/rkkumardotnet/
|
Read more
|
|
|
|