| title | Creating Multidimensional Models Using SQL Server Data Tools (SSDT) | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| ms.custom | ||||||
| ms.date | 06/13/2017 | |||||
| ms.prod | sql-server-2014 | |||||
| ms.reviewer | ||||||
| ms.technology | analysis-services | |||||
| ms.topic | conceptual | |||||
| helpviewer_keywords |
|
|||||
| ms.assetid | 132ed779-3ec8-4734-9698-802116d1b017 | |||||
| author | minewiskan | |||||
| ms.author | owend | |||||
| manager | craigg |
[!INCLUDEmsCoName] [!INCLUDEssNoVersion] provides two different environments for building, deploying, and managing [!INCLUDEssASnoversion] solutions: [!INCLUDEssBIDevStudioFull] and [!INCLUDEssManStudioFull]. Both of these environments implement a project system. For more information about Visual Studio projects, see Projects as Containers in the MSDN Library.
-
[!INCLUDEssBIDevStudioFull] is a development environment, based on [!INCLUDEmsCoName] Visual Studio 2010, used for creating and modifying business intelligence solutions. With [!INCLUDEssBIDevStudioFull], you create [!INCLUDEssASnoversion] projects that contain definitions of [!INCLUDEssASnoversion] objects (cubes, dimensions, and so on), which are stored in XML files that contain [!INCLUDEssASnoversion] Scripting Language (ASSL) elements. These projects are contained in solutions that can also contain projects from other [!INCLUDEssNoVersion] components, including [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] and [!INCLUDEssNoVersion] [!INCLUDEssRSnoversion]. In [!INCLUDEssBIDevStudioFull], you can develop [!INCLUDEssASnoversion] projects as part of a solution that is independent of any particular [!INCLUDEssASnoversion] instance. You can deploy the objects to an instance on a test server for testing during development, and then use the same [!INCLUDEssASnoversion] project to deploy your objects to instances on one or more staging or production servers. The projects and items in a solution that includes [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion] can be integrated with source code control, such as [!INCLUDEmsCoName] Visual SourceSafe. For more information about creating an [!INCLUDEssASnoversion] project in [!INCLUDEssBIDevStudioFull] using [!INCLUDEssASnoversion], see Create an Analysis Services Project (SSDT). You can also use [!INCLUDEssBIDevStudioFull] to connect directly to an existing [!INCLUDEssASnoversion] instance to create and modify [!INCLUDEssASnoversion] objects, without working with a project and without storing object definitions in XML files. For more information, see Multidimensional Model Databases (SSAS), and Connect in Online Mode to an Analysis Services Database.
-
[!INCLUDEssManStudioFull] is a management and administration environment, used primarily to administer instances of [!INCLUDEssASnoversion], [!INCLUDEssNoVersion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion]. With [!INCLUDEssManStudioFull], you can manage [!INCLUDEssASnoversion] objects (perform back-ups, processing, and so on), and you can also create new objects directly on an existing [!INCLUDEssASnoversion] instance by using XMLA scripts. [!INCLUDEssManStudioFull] provides an Analysis Server Scripts project in which you can develop and save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). Usually, Analysis Server Scripts projects are used for performing management tasks or re-creating objects, such as databases and cubes, on [!INCLUDEssASnoversion] instances. Such projects can be saved as part of a solution and integrated with source code control. For more information about creating an Analysis Server Scripts project in [!INCLUDEssManStudioFull] using [!INCLUDEssASnoversion], see Analysis Services Scripts Project in SQL Server Management Studio.
Both [!INCLUDEssBIDevStudioFull] and [!INCLUDEssManStudioFull] provide projects, which are organized into solutions. A solution can contain multiple projects, and a project typically contains multiple items. A new solution is automatically generated when you create a project, and you can add additional projects as needed to an existing solution. The objects that a project contains depend on the type of the project. The items in each project container are saved as files in project folders in the file system.
[!INCLUDEssBIDevStudioFull] contains the following projects under the Business Intelligence Projects project type.
| Project | Description |
|---|---|
| [!INCLUDEssASnoversion] Project | Contains the object definitions for a single [!INCLUDEssASnoversion] database. For more information about how to create an [!INCLUDEssASnoversion] project, see Create an Analysis Services Project (SSDT). |
| Import [!INCLUDEssASnoversion] 2008 Database | Provides a wizard that you can use to create a new [!INCLUDEssASnoversion] project by importing object definitions from an existing [!INCLUDEssASnoversion] database. |
| [!INCLUDEssISnoversion] Project | Contains the object definitions for a set of [!INCLUDEssISnoversion] packages. For more information, see SQL Server Integration Services. |
| Report Project Wizard | Provides a wizard that guides you through the process of creating a Report project using [!INCLUDEssRSnoversion]. For more information, see Reporting Services (SSRS). |
| Report Model Project | Contains the object definitions for a [!INCLUDEssRSnoversion] report model. For more information, see Reporting Services (SSRS). |
| Report Server Project | Contains the object definitions for one or more [!INCLUDEssRSnoversion] reports. For more information, see Reporting Services (SSRS). |
[!INCLUDEssManStudioFull] also contains several project types that focus on various queries or scripts, as shown in the following table.
| Project | Description |
|---|---|
| [!INCLUDEssASnoversion] Scripts | Contains DMX, MDX, and XMLA scripts for [!INCLUDEssASnoversion], as well as connections to [!INCLUDEssASnoversion] instances against which these scripts can be executed. For more information, see Analysis Services Scripts Project in SQL Server Management Studio. |
| SQL Server Compact Scripts | Contains SQL scripts for SQL Server Compact, as well as connections to SQL Server Compact instances against which these scripts can be executed. |
| SQL Server Scripts | Contains [!INCLUDEtsql] and XQuery scripts for a [!INCLUDEssDEnoversion] instance, as well as connections to [!INCLUDEssDEnoversion] instances against which these scripts can be executed. For more information, see SQL Server Database Engine. |
For more information about solutions and projects, see "Managing Solutions, Projects, and Files," either in the [!INCLUDEmsCoName] [!INCLUDEvsprvs] .NET documentation or in the MSDN Library.
[!INCLUDEssManStudioFull] is designed for administering and configuring existing objects in [!INCLUDEssDEnoversion], [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion]. [!INCLUDEssBIDevStudioFull] is designed for developing business intelligence solutions that include functionality from [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion].
The following are some of the differences between [!INCLUDEssManStudioFull] from [!INCLUDEssBIDevStudioFull].
-
[!INCLUDEssManStudioFull] provides an integrated environment for connecting to instances of [!INCLUDEssASnoversion], [!INCLUDEssNoVersion], and [!INCLUDEssRSnoversion] to configure, manage, and administer objects within an instance of [!INCLUDEssASnoversion]. Through the use of scripts, you can also use [!INCLUDEssManStudioFull] to create or modify [!INCLUDEssASnoversion] objects themselves, but [!INCLUDEssManStudioFull] does not provide a graphical interface for object design and definition.
-
[!INCLUDEssBIDevStudioFull] provides an integrated development environment for developing business intelligence solutions. You can use [!INCLUDEssBIDevStudioFull] in project mode, which uses XML-based definitions of [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion] objects contained in projects and solutions. Using [!INCLUDEssBIDevStudioFull] in project mode means that changes to [!INCLUDEssASnoversion] objects in [!INCLUDEssBIDevStudioFull] are made to these XML-based object definitions and not applied directly to an object on an [!INCLUDEssASnoversion] instance until the solution is deployed. You can also use [!INCLUDEssBIDevStudioFull] in online mode, which means connecting directly to an [!INCLUDEssASnoversion] instance and working with objects in an existing database.
[!INCLUDEssBIDevStudioFull] enhances the development of business intelligence applications because you can work on [!INCLUDEssASnoversion] projects in a source-controlled, multi-user environment without requiring an active connection to an [!INCLUDEssASnoversion] instance. [!INCLUDEssManStudioFull] provides direct access to existing objects for querying and testing, and can be used to more quickly implement previously scripted [!INCLUDEssASnoversion] databases. However, once a project has been deployed into the production environment, care must be taken when working with an [!INCLUDEssASnoversion] database and its objects with [!INCLUDEssManStudioFull] and [!INCLUDEssBIDevStudioFull]. This is to avoid overwriting changes made to objects directly in an existing database, and changes made to the [!INCLUDEssASnoversion] project that originally generated the deployed solution. For more information, see Working with Analysis Services Projects and Databases During the Development Phase, and Working with Analysis Services Projects and Databases in a Production Environment.
-
Working with Analysis Services Projects and Databases During the Development Phase
-
Working with Analysis Services Projects and Databases in a Production Environment
Create an Analysis Services Project (SSDT)
Analysis Services Scripts Project in SQL Server Management Studio
Multidimensional Model Databases (SSAS)