Skip to content

Latest commit

 

History

History
62 lines (38 loc) · 6.95 KB

lesson-2-5-deploying-an-analysis-services-project.md

File metadata and controls

62 lines (38 loc) · 6.95 KB
Raw
title description ms.date ms.service ms.custom ms.topic ms.author ms.reviewer author
Deploying an Analysis Services Project | Microsoft Docs
Learn how to deploy the cube of an Analysis Services project.
04/20/2022
analysis-services
multidimensional-models
tutorial
kfollis
kfollis
kfollis

Lesson 2-5 - Deploying an Analysis Services Project

[!INCLUDEappliesto-sqlas]

To view the cube and dimension data for the objects in the [!INCLUDEssASnoversion] Tutorial cube in the [!INCLUDEssASnoversion] Tutorial project, you must deploy the project to a specified instance of [!INCLUDEssASnoversion] and then process the cube and its dimensions. Deploying an [!INCLUDEssASnoversion] project creates the defined objects in an instance of [!INCLUDEssASnoversion]. Processing the objects in an instance of [!INCLUDEssASnoversion] copies the data from the underlying data sources into the cube objects. For more information, see Deploy Analysis Services Projects (SSDT) and Configure Analysis Services Project Properties (SSDT).

At this point in the development process, you generally deploy the cube to an instance of [!INCLUDEssASnoversion] on a development server. Once you have finished developing your business intelligence project, you will generally use the [!INCLUDEssASnoversion] Deployment Wizard to deploy your project from the development server to a production server. For more information, see Multidimensional Model Solution Deployment and Deploy model solutions by using the Deployment Wizard.

In the following task, you review the deployment properties of the [!INCLUDEssASnoversion] Tutorial project and then deploy the project to your local instance of [!INCLUDEssASnoversion].

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 [!INCLUDEssASnoversion].

  2. In the Configuration Properties node in the left pane, click Deployment.

    Review the deployment properties for the project. By default, the [!INCLUDEssASnoversion] Project template configures an [!INCLUDEssASnoversion] project to incrementally deploy all projects to the default instance of [!INCLUDEssASnoversion] on the local computer, to create an [!INCLUDEssASnoversion] database with the same name as the project, and to process the objects after deployment by using the default processing option. For more information, see Configure Analysis Services Project Properties (SSDT).

    [!NOTE]
    If you want to deploy the project to a named instance of [!INCLUDEssASnoversion] on the local computer, or to an instance on a remote server, change the Server property to the appropriate instance name, such as <ServerName*>\<InstanceName>*.

  3. Click OK.

  4. In Solution Explorer, right-click the Analysis Services Tutorial project, and then click Deploy. You might need to wait.

    [!NOTE]
    If you get errors during deployment, use SQL Server Management Studio to check the database permissions. The account you specified for the data source connection must have a login on the SQL Server instance. Double-click the login to view User Mapping properties. The account must have db_datareader permissions on the AdventureWorksDW2019 database.

    [!INCLUDEssBIDevStudioFull] builds and then deploys the [!INCLUDEssASnoversion] Tutorial project to the specified instance of [!INCLUDEssASnoversion] 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. For more information, see Build Analysis Services Projects (SSDT) and Deploy Analysis Services Projects (SSDT).

  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. 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.

  7. To hide the Output window, click the Auto Hide icon on the toolbar of the window.

You have successfully deployed the [!INCLUDEssASnoversion] Tutorial cube to your local instance of [!INCLUDEssASnoversion], and then processed the deployed cube.

Next Task in Lesson

Browsing the Cube

See Also

Deploy Analysis Services Projects (SSDT)
Configure Analysis Services Project Properties (SSDT)