Skip to content

Commit e3c50cd

Browse files
author
Owen Duncan
committed
Removing scripting topic and all See also sections from PowerShell reference topics. These referenec topics will be redirected soon.
1 parent 79de118 commit e3c50cd

54 files changed

Lines changed: 314 additions & 554 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎.openpublishing.redirection.json‎

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1829,6 +1829,11 @@
18291829
"source_path":"docs/sql-server/sql-server-documentation-offline-access.md",
18301830
"redirect_url":"/sql/release-notes/sql-server-help-installation",
18311831
"redirect_document_id":false
1832+
},
1833+
{
1834+
"source_path": "docs/analysis-services/instances/script-administrative-tasks-in-analysis-services.md",
1835+
"redirect_url": "/sql/analysis-services/analysis-services",
1836+
"redirect_document_id": false
18321837
}
18331838

18341839
]

‎docs/analysis-services/analysis-services-developer-documentation.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,7 @@ Analysis Services provides many ways to customize a solution through code, but m
4444

4545
- Multidimensional models and Tabular models at compatibility levels 1050-1103 use Analysis Services Scripting Language (ASSL), which is the Analysis Services extension of the XMLA open standard.
4646

47-
- You can generate ASSL or TMSL script in Management Studio. You can also use **View Code** in SQL Server Data Tools to view the model definition in ASSL or TMSL. See [Script Administrative Tasks in Analysis Services](../analysis-services/instances/script-administrative-tasks-in-analysis-services.md) for more information.
47+
- You can generate ASSL or TMSL script in Management Studio. You can also use **View Code** in SQL Server Data Tools to view the model definition in ASSL or TMSL.
4848

4949
- Although it is possible to build a solution based on the open standards of XMLA and MDX, it's quite rare to do so. There is no documentation other than XMLA and MDX reference to help you, and most community and forum support draws from experiences with .NET or native (MSOLAP) technologies.
5050

‎docs/analysis-services/data-mining/data-mining-stored-procedures-analysis-services-data-mining.md‎

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -39,9 +39,6 @@ manager: "erikre"
3939

4040
- [SystemGetClusterAccuracyResults (Analysis Services - Data Mining)](../../analysis-services/data-mining/systemgetclusteraccuracyresults-analysis-services-data-mining.md)
4141

42-
## Reference
43-
[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)
44-
4542
## See Also
4643
[Cross-Validation (Analysis Services - Data Mining)](../../analysis-services/data-mining/cross-validation-analysis-services-data-mining.md)
4744
[Cross-Validation Tab (Mining Accuracy Chart View)](http://msdn.microsoft.com/library/bd215a68-1ad7-4046-9c44-ec8e2be13a64)

‎docs/analysis-services/instances/TOC.md‎

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,6 @@
3030
### [Use Analysis Services Templates in SQL Server Management Studio](use-analysis-services-templates-in-sql-server-management-studio.md)
3131
### [Use the Analysis Services Scripts Project in Management Studio](analysis-services-scripts-project-in-sql-server-management-studio.md)
3232
## [Schedule Administrative Tasks with SQL Server Agent](schedule-ssas-administrative-tasks-with-sql-server-agent.md)
33-
## [PowerShell Scripting in Analysis Services](powershell-scripting-in-analysis-services.md)
3433
## [Automate Administrative Tasks with SSIS](automate-analysis-services-administrative-tasks-with-ssis.md)
3534
# [High Availability and Scalability](high-availability-and-scalability-in-analysis-services.md)
3635
# [Logging in Analysis Services](log-operations-in-analysis-services.md)

‎docs/analysis-services/instances/analysis-services-instance-management.md‎

Lines changed: 21 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -1,24 +1,24 @@
1-
---
2-
title: "Analysis Services Instance Management | Microsoft Docs"
3-
ms.custom:
4-
- "SQL2016_New_Updated"
5-
ms.date: "03/14/2017"
6-
ms.prod: "sql-server-2016"
7-
ms.reviewer: ""
8-
ms.suite: ""
9-
ms.technology:
10-
- "analysis-services"
11-
- "analysis-services/multidimensional-tabular"
12-
- "analysis-services/data-mining"
13-
ms.tgt_pltfrm: ""
14-
ms.topic: "article"
15-
ms.assetid: 0455fa4f-b92d-4a8b-a8f0-f2a268a5c84e
16-
caps.latest.revision: 25
17-
author: "Minewiskan"
18-
ms.author: "owend"
19-
manager: "erikre"
20-
---
21-
# Analysis Services Instance Management
1+
---
2+
title: "Analysis Services Instance Management | Microsoft Docs"
3+
ms.custom:
4+
- "SQL2016_New_Updated"
5+
ms.date: "03/14/2017"
6+
ms.prod: "sql-server-2016"
7+
ms.reviewer: ""
8+
ms.suite: ""
9+
ms.technology:
10+
- "analysis-services"
11+
- "analysis-services/multidimensional-tabular"
12+
- "analysis-services/data-mining"
13+
ms.tgt_pltfrm: ""
14+
ms.topic: "article"
15+
ms.assetid: 0455fa4f-b92d-4a8b-a8f0-f2a268a5c84e
16+
caps.latest.revision: 25
17+
author: "Minewiskan"
18+
ms.author: "owend"
19+
manager: "erikre"
20+
---
21+
# Analysis Services Instance Management
2222
An instance of Analysis Services is a copy of the **msmdsrv.exe** executable that runs as an operating system service. Each instance is fully independent of other instances on the same server, having its own configuration settings, permissions, ports, startup accounts, file storage, and server mode properties.
2323

2424
Each instance of [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] runs as Windows service, Msmdsrv.exe, in the security context of a defined logon account.
@@ -50,7 +50,6 @@ manager: "erikre"
5050
|[Post-install Configuration (Analysis Services)](../../analysis-services/instances/post-install-configuration-analysis-services.md)|Describes the required and optional tasks that complete or modify an installation of Analysis.|
5151
|[Connect to Analysis Services](../../analysis-services/instances/connect-to-analysis-services.md)|Describes connection string properties, client libraries, authentication methodologies, and steps for establishing or clearing connections.|
5252
|[Monitor an Analysis Services Instance](../../analysis-services/instances/monitor-an-analysis-services-instance.md)|Describes tools and techniques for monitoring a server instance, including how to use Performance Monitor and SQL Server Profiler.|
53-
|[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)|Explains how to automate many administrative tasks, including processing.|
5453
|[High availability and Scalability](../../analysis-services/instances/high-availability-and-scalability-in-analysis-services.md)|Describes the most commonly used techniques for making Analysis Services databases high available and scalable. |
5554
|[Globalization scenarios for Analysis Services](../../analysis-services/globalization-scenarios-for-analysis-services.md)|Explains language and collation support, steps for changing both properties, and tips for setting and testing language and collation behaviors.|
5655
|[Log operations in Analysis Services](../../analysis-services/instances/log-operations-in-analysis-services.md)|Describes the logs and explains how to configure them.|

‎docs/analysis-services/instances/analysis-services-scripts-project-in-sql-server-management-studio.md‎

Lines changed: 28 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -1,30 +1,30 @@
1-
---
2-
title: "Analysis Services Scripts Project in SQL Server Management Studio | Microsoft Docs"
3-
ms.custom: ""
4-
ms.date: "03/14/2017"
5-
ms.prod: "sql-server-2016"
6-
ms.reviewer: ""
7-
ms.suite: ""
8-
ms.technology:
9-
- "analysis-services"
10-
- "analysis-services/multidimensional-tabular"
11-
- "analysis-services/data-mining"
12-
ms.tgt_pltfrm: ""
13-
ms.topic: "article"
14-
helpviewer_keywords:
15-
- "scripts [Analysis Services]"
16-
- "scripts [Analysis Services], projects"
17-
- "projects [Analysis Services], Analysis Server Scripts project"
18-
- "projects [Analysis Services], creating"
19-
- "Analysis Server Scripts project"
20-
- "items [Analysis Services]"
21-
ms.assetid: c4f5a06b-e2e4-4660-a3a8-6fd356742c02
22-
caps.latest.revision: 38
23-
author: "Minewiskan"
24-
ms.author: "owend"
25-
manager: "erikre"
26-
---
27-
# Analysis Services Scripts Project in SQL Server Management Studio
1+
---
2+
title: "Analysis Services Scripts Project in SQL Server Management Studio | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/14/2017"
5+
ms.prod: "sql-server-2016"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
- "analysis-services/multidimensional-tabular"
11+
- "analysis-services/data-mining"
12+
ms.tgt_pltfrm: ""
13+
ms.topic: "article"
14+
helpviewer_keywords:
15+
- "scripts [Analysis Services]"
16+
- "scripts [Analysis Services], projects"
17+
- "projects [Analysis Services], Analysis Server Scripts project"
18+
- "projects [Analysis Services], creating"
19+
- "Analysis Server Scripts project"
20+
- "items [Analysis Services]"
21+
ms.assetid: c4f5a06b-e2e4-4660-a3a8-6fd356742c02
22+
caps.latest.revision: 38
23+
author: "Minewiskan"
24+
ms.author: "owend"
25+
manager: "erikre"
26+
---
27+
# Analysis Services Scripts Project in SQL Server Management Studio
2828
In [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)], you can create an Analysis Server Scripts project in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] to group related scripts together for development, management, and source control purposes. If no solution is currently loaded in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)], 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.
2929

3030
You use the following basic steps to create an Analysis Server Scripts project in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)]:
@@ -37,7 +37,7 @@ manager: "erikre"
3737

3838
This folder contains connection strings to [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] 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.
3939

40-
3. 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](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md).
40+
3. 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.
4141

4242
4. 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 [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)].
4343

‎docs/analysis-services/instances/automate-analysis-services-administrative-tasks-with-ssis.md‎

Lines changed: 23 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -1,26 +1,26 @@
1-
---
2-
title: "Automate Analysis Services Administrative Tasks with SSIS | Microsoft Docs"
3-
ms.custom: ""
4-
ms.date: "03/14/2017"
5-
ms.prod: "sql-server-2016"
6-
ms.reviewer: ""
7-
ms.suite: ""
8-
ms.technology:
9-
- "analysis-services"
10-
- "analysis-services/multidimensional-tabular"
11-
- "analysis-services/data-mining"
12-
ms.tgt_pltfrm: ""
13-
ms.topic: "article"
14-
helpviewer_keywords:
15-
- "Execute DDL Task [Analysis Services]"
16-
- "Analysis Services Processing task"
17-
ms.assetid: e960a9a2-80b4-45da-9369-bc560ecdccac
18-
caps.latest.revision: 29
19-
author: "Minewiskan"
20-
ms.author: "owend"
21-
manager: "erikre"
22-
---
23-
# Automate Analysis Services Administrative Tasks with SSIS
1+
---
2+
title: "Automate Analysis Services Administrative Tasks with SSIS | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/14/2017"
5+
ms.prod: "sql-server-2016"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
- "analysis-services/multidimensional-tabular"
11+
- "analysis-services/data-mining"
12+
ms.tgt_pltfrm: ""
13+
ms.topic: "article"
14+
helpviewer_keywords:
15+
- "Execute DDL Task [Analysis Services]"
16+
- "Analysis Services Processing task"
17+
ms.assetid: e960a9a2-80b4-45da-9369-bc560ecdccac
18+
caps.latest.revision: 29
19+
author: "Minewiskan"
20+
ms.author: "owend"
21+
manager: "erikre"
22+
---
23+
# Automate Analysis Services Administrative Tasks with SSIS
2424
[!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] enables you to automate execution of DDL scripts, cube and mining model processing tasks, and data mining query tasks. [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] can be thought of as a collection of control flow and maintenance tasks, which can be linked to form sequential and parallel data processing jobs.
2525

2626
[!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] is designed to perform data cleaning operations during data processing tasks, and to bring together data from different data sources. When working with cubes and mining models, [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] can transform non-numeric data to numeric data, and can ensure that data values fall within expected bounds, thus creating clean data from which to populate fact tables and dimensions.
@@ -42,6 +42,5 @@ manager: "erikre"
4242
[Dimension Processing Destination](../../integration-services/data-flow/dimension-processing-destination.md)
4343
[Data Mining Query Transformation](../../integration-services/data-flow/transformations/data-mining-query-transformation.md)
4444
[Processing a multidimensional model (Analysis Services)](../../analysis-services/multidimensional-models/processing-a-multidimensional-model-analysis-services.md)
45-
[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)
4645

4746

‎docs/analysis-services/instances/clear-the-analysis-services-caches.md‎

Lines changed: 20 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1,23 +1,23 @@
1-
---
2-
title: "Clear the Analysis Services Caches | Microsoft Docs"
3-
ms.custom: ""
4-
ms.date: "03/01/2017"
5-
ms.prod: "sql-server-2016"
6-
ms.reviewer: ""
7-
ms.suite: ""
8-
ms.technology:
9-
- "analysis-services"
10-
- "analysis-services/multidimensional-tabular"
11-
- "analysis-services/data-mining"
12-
ms.tgt_pltfrm: ""
13-
ms.topic: "article"
14-
ms.assetid: 6bf66fdd-6a03-4cea-b7e2-eb676ff276ff
15-
caps.latest.revision: 11
16-
author: "Minewiskan"
17-
ms.author: "owend"
18-
manager: "erikre"
19-
---
20-
# Clear the Analysis Services Caches
1+
---
2+
title: "Clear the Analysis Services Caches | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/01/2017"
5+
ms.prod: "sql-server-2016"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
- "analysis-services/multidimensional-tabular"
11+
- "analysis-services/data-mining"
12+
ms.tgt_pltfrm: ""
13+
ms.topic: "article"
14+
ms.assetid: 6bf66fdd-6a03-4cea-b7e2-eb676ff276ff
15+
caps.latest.revision: 11
16+
author: "Minewiskan"
17+
ms.author: "owend"
18+
manager: "erikre"
19+
---
20+
# Clear the Analysis Services Caches
2121
Analysis Services caches data to boost query performance. This topic provides recommendations for using the XMLA ClearCache command to clear caches that were created in response to an MDX query. The effects of running ClearCache vary depending on whether you are using a tabular or multidimensional model.
2222

2323
**When to clear the cache for multidimensional models**
@@ -88,7 +88,6 @@ manager: "erikre"
8888
```
8989
9090
## See Also
91-
[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)
9291
[Monitor an Analysis Services Instance](../../analysis-services/instances/monitor-an-analysis-services-instance.md)
9392
9493

‎docs/analysis-services/instances/connect-to-analysis-services.md‎

Lines changed: 22 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -1,25 +1,25 @@
1-
---
2-
title: "Connect to Analysis Services | Microsoft Docs"
3-
ms.custom: ""
4-
ms.date: "03/07/2017"
5-
ms.prod: "sql-server-2016"
6-
ms.reviewer: ""
7-
ms.suite: ""
8-
ms.technology:
9-
- "analysis-services"
10-
- "analysis-services/multidimensional-tabular"
11-
- "analysis-services/data-mining"
12-
ms.tgt_pltfrm: ""
13-
ms.topic: "article"
14-
helpviewer_keywords:
15-
- "instances of Analysis Services, connections"
16-
ms.assetid: 73ee8171-3379-4384-bfc8-071b3eebbc8f
17-
caps.latest.revision: 46
18-
author: "Minewiskan"
19-
ms.author: "owend"
20-
manager: "erikre"
21-
---
22-
# Connect to Analysis Services
1+
---
2+
title: "Connect to Analysis Services | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/07/2017"
5+
ms.prod: "sql-server-2016"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
- "analysis-services/multidimensional-tabular"
11+
- "analysis-services/data-mining"
12+
ms.tgt_pltfrm: ""
13+
ms.topic: "article"
14+
helpviewer_keywords:
15+
- "instances of Analysis Services, connections"
16+
ms.assetid: 73ee8171-3379-4384-bfc8-071b3eebbc8f
17+
caps.latest.revision: 46
18+
author: "Minewiskan"
19+
ms.author: "owend"
20+
manager: "erikre"
21+
---
22+
# Connect to Analysis Services
2323
Use the information in this section to learn about connection string properties, client libraries used for connections, which authentication methods are supported by Analysis Services, and how to set up or clear connections before taking a server offline.
2424

2525
## Analysis Services connections
@@ -43,6 +43,5 @@ manager: "erikre"
4343
## See Also
4444
[Post-install Configuration (Analysis Services)](../../analysis-services/instances/post-install-configuration-analysis-services.md)
4545
[Server Properties in Analysis Services](../../analysis-services/server-properties/server-properties-in-analysis-services.md)
46-
[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)
4746

4847

‎docs/analysis-services/instances/create-analysis-services-scripts-in-management-studio.md‎

Lines changed: 24 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -1,27 +1,27 @@
1-
---
2-
title: "Create Analysis Services Scripts in Management Studio | Microsoft Docs"
3-
ms.custom: ""
4-
ms.date: "03/06/2017"
5-
ms.prod: "sql-server-2016"
6-
ms.reviewer: ""
7-
ms.suite: ""
8-
ms.technology:
9-
- "analysis-services"
10-
- "analysis-services/multidimensional-tabular"
11-
- "analysis-services/data-mining"
12-
ms.tgt_pltfrm: ""
13-
ms.topic: "article"
14-
helpviewer_keywords:
15-
- "Analysis Services objects, scripts"
16-
- "objects [Analysis Services], scripts"
17-
- "scripts [Analysis Services], objects"
18-
ms.assetid: 4f1b965c-9ca6-427b-8f4d-0ce1eea7c0fe
19-
caps.latest.revision: 36
20-
author: "Minewiskan"
21-
ms.author: "owend"
22-
manager: "erikre"
23-
---
24-
# Create Analysis Services Scripts in Management Studio
1+
---
2+
title: "Create Analysis Services Scripts in Management Studio | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/06/2017"
5+
ms.prod: "sql-server-2016"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
- "analysis-services/multidimensional-tabular"
11+
- "analysis-services/data-mining"
12+
ms.tgt_pltfrm: ""
13+
ms.topic: "article"
14+
helpviewer_keywords:
15+
- "Analysis Services objects, scripts"
16+
- "objects [Analysis Services], scripts"
17+
- "scripts [Analysis Services], objects"
18+
ms.assetid: 4f1b965c-9ca6-427b-8f4d-0ce1eea7c0fe
19+
caps.latest.revision: 36
20+
author: "Minewiskan"
21+
ms.author: "owend"
22+
manager: "erikre"
23+
---
24+
# Create Analysis Services Scripts in Management Studio
2525
[!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] includes script generation features, templates, and editors that you can use to script Analysis Services objects and tasks.
2626

2727
## Script Analysis Services Tasks in Management Studio
@@ -65,7 +65,6 @@ manager: "erikre"
6565
> Typically, you would select **File** if you want to create multiple different versions of the file.
6666
6767
## See Also
68-
[Script Administrative Tasks in Analysis Services](../../analysis-services/instances/script-administrative-tasks-in-analysis-services.md)
6968
[XMLA Query Editor (Analysis Services - Multidimensional Data)](http://msdn.microsoft.com/library/14623019-7839-4038-9d12-2f8953d2ec04)
7069

7170

0 commit comments

Comments
 (0)