| title | Analysis Services Scripts Project in SQL Server Management Studio | Microsoft Docs | ||||||
|---|---|---|---|---|---|---|---|
| ms.custom | |||||||
| ms.date | 03/06/2017 | ||||||
| ms.prod | sql-server-2014 | ||||||
| ms.reviewer | |||||||
| ms.technology | analysis-services | ||||||
| ms.topic | conceptual | ||||||
| helpviewer_keywords |
|
||||||
| ms.assetid | c4f5a06b-e2e4-4660-a3a8-6fd356742c02 | ||||||
| author | minewiskan | ||||||
| ms.author | owend | ||||||
| manager | craigg |
In [!INCLUDEssASnoversion], you can create an Analysis Server Scripts project in [!INCLUDEssManStudioFull] to group related scripts together for development, management, and source control purposes. If no solution is currently loaded in [!INCLUDEssManStudioFull], creating a new Analysis Server Scripts project automatically creates a new solution. Otherwise, the new Analysis Server Scripts project can be added to the existing solution or created in a new solution.
You use the following basic steps to create an Analysis Server Scripts project in [!INCLUDEssManStudioFull]:
-
On the File menu, point to New, and then click Project.
Select Analysis Server Scripts project template and then specify a name and location for the new project.
-
Right-click Connections to create a new connection in the Connections folder of the Analysis Server Scripts project in Solution Explorer.
This folder contains connection strings to [!INCLUDEssASnoversion] instances, against which the scripts contained by the Analysis Server Scripts project can be executed. You can have multiple connections in an Analysis Server Scripts project, and you can choose a connection against which to run a script contained by the project at the time of execution.
-
Right-click Queries to create Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA) scripts in the Scripts folder of the Analysis Server Scripts project in Solution Explorer. For more information, see Script Administrative Tasks in Analysis Services.
-
Right-click on the project, point to Add, and then select Existing Item to add miscellaneous files, such as text files that contain notes on the project, in the Miscellaneous folder of the Analysis Server Scripts project in Solution Explorer. These files are ignored by [!INCLUDEssManStudioFull].
A [!INCLUDEssManStudioFull] solution can contain several file types, depending on what projects you included in the solution and what items you included in each project for that solution. For more information about file types for solutions in [!INCLUDEssManStudioFull], see Files That Manage Solutions and Projects. Typically, the files for each project in a [!INCLUDEssManStudioFull] solution are stored in the solution folder, in a separate folder for each project.
The project folder for an Analysis Server Scripts project can contain the file types listed in the following table.
| File type | Description |
|---|---|
| Analysis Server Scripts project definition file (.ssmsasproj) | Contains metadata about the folders shown in Solution Explorer, as well as information that indicates which folders should display files included in the project. The project definition file also contains the metadata for [!INCLUDEssASnoversion] connections contained in the project, as well as metadata that associates connections with script files included in the project. |
| DMX script file (.dmx) | Contains a DMX script included in the project. |
| MDX script file (.mdx) | Contains an MDX script included in the project. |
| XMLA script file (.xmla) | Contains an XMLA script included in the project. |
When adding new MDX, DMX, or XMLA scripts to an Analysis Server Scripts project, you have the option of using Template Explorer to locate [!INCLUDEssASnoversion] templates, which are a collection of predefined scripts or statements that demonstrate how to perform a specified action. Template Explorer is available on the View menu and includes templates for [!INCLUDEssNoVersion], [!INCLUDEssASnoversion], and [!INCLUDEssEW]. For more information, see Use Analysis Services Templates in SQL Server Management Studio.
Creating Multidimensional Models Using SQL Server Data Tools (SSDT)
Multidimensional Expressions (MDX) Reference
Data Mining Extensions (DMX) Reference
Analysis Services Scripting Language (ASSL) Reference
Analysis Services Scripting Language (ASSL) Reference