Skip to content

Commit b350c12

Browse files
v-anpasiv-anpasi
committed
Bringing even with master.
2 parents 9b9fe61 + ccdedfd commit b350c12

19 files changed

Lines changed: 1203 additions & 1446 deletions

‎.openpublishing.redirection.json‎

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1835,6 +1835,11 @@
18351835
"redirect_url": "/sql/analysis-services/analysis-services",
18361836
"redirect_document_id": false
18371837
},
1838+
{
1839+
"source_path": "docs/analysis-services/powershell/amo-powershell-example.md",
1840+
"redirect_url": "/sql/analysis-services/analysis-services",
1841+
"redirect_document_id": false
1842+
},
18381843
{
18391844
"source_path":"docs/tools/sql-server-profiler/run-sql-server-profiler.md",
18401845
"redirect_url":"/sql/tools/sql-server-profiler/start-sql-server-profiler",

‎docs/analysis-services/analysis-services-samples.md‎

Lines changed: 7 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: "Analysis Services samples | Microsoft Docs"
33
ms.custom:
44
- "SQL2016_New_Updated"
5-
ms.date: "03/29/2017"
5+
ms.date: "06/28/2017"
66
ms.prod: "sql-server-2016"
77
ms.reviewer: ""
88
ms.suite: ""
@@ -22,6 +22,11 @@ manager: "erikre"
2222

2323
Use the information here to find sample databases and projects to help you learn about and test your Analysis Services solutions.
2424

25+
26+
## Samples on GitHub
27+
28+
[Git repo for Analysis Services](https://github.com/Microsoft/Analysis-Services) includes code samples and community projects.
29+
2530
## Sample solutions and databases
2631

2732
While no longer officially supported or updated, Adventure Works remains one of the most inclusive and robust sample datasets for learning about and testing Analysis Services. Analysis Services sample projects and databases, as well as examples in documenation, blog posts, and presentations use the Adventure Works 2014 sample data.
@@ -30,12 +35,9 @@ While no longer officially supported or updated, Adventure Works remains one of
3035

3136
A new collection of sample data, Wide World Importers, was introduced for SQL Server 2016. You can use Wide World Importers sample data to learn about and test Analysis Services; however, no tutorials, examples, or documentation are provided. The Wide World Importers dataset and schema do not support many of the features in Analysis Services. To learn more, see [Wide World Importers](https://msdn.microsoft.com/library/mt734199).
3237

33-
## Other samples
34-
[AMO code sample for creating tabular models programmatically](http://go.microsoft.com/fwlink/?linkID=221036).
3538

36-
[Whitepaper and Code Sample for Automated Partition Management](https://blogs.msdn.microsoft.com/analysisservices/2017/01/17/whitepaper-and-code-sample-for-automated-partition-management/)
3739

38-
## See Also
40+
## See also
3941
* [Analysis Services tutorials](../analysis-services/analysis-services-tutorials-ssas.md)
4042

4143

‎docs/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas.md‎

Lines changed: 31 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -49,34 +49,36 @@ manager: "erikre"
4949
## <a name="bkmk_models"></a> Model Features
5050
The following table summarizes feature availability at the model level. Review this list to ensure that the feature you want to use is available in the type of model you plan to build.
5151

52-
|||||
53-
|-|-|-|-|
54-
||Multidimensional|Tabular|Power Pivot|
55-
|Actions|Yes|No|No|
56-
|Aggregations|Yes|No|No|
57-
|Calculated Column|No|Yes|Yes|
58-
|Calculated Measures|Yes|Yes|Yes|
59-
|Calculated Tables|No|Yes <sup>1</sup>|No|
60-
|Custom Assemblies|Yes|No|No|
61-
|Custom Rollups|Yes|No|No|
62-
|Default Member|Yes|No|No|
63-
|Display folders|Yes|Yes <sup>1</sup>|No|
64-
|Distinct Count|Yes|Yes (via DAX)|Yes (via DAX)|
65-
|Drillthrough|Yes|Yes (detail opens in separate worksheet)|Yes|
66-
|Hierarchies|Yes|Yes|Yes|
67-
|KPIs|Yes|Yes|Yes|
68-
|Linked objects|Yes|Yes (linked tables)|No|
69-
|Many-to-many relationships|Yes|No (but there is [bi-directional cross filters](../analysis-services/tabular-models/bi-directional-cross-filters-tabular-models-analysis-services.md) at 1200 and higher compatibility levels)|No|
70-
|Named sets|Yes|No|No|
71-
|Ragged Hierarchies|Yes|Yes|No|
72-
|Parent-child Hierarchies|Yes|Yes (via DAX)|Yes (via DAX)|
73-
|Partitions|Yes|Yes|Yes|
74-
|Perspectives|Yes|Yes|Yes|
75-
|Row-level Security|Yes|Yes|No|
76-
|Semi-additive Measures|Yes|Yes|Yes|
77-
|Translations|[Yes](../analysis-services/multidimensional-models/translations-in-multidimensional-models-analysis-services.md)|Yes|[Yes](../analysis-services/tabular-models/translations-in-tabular-models-analysis-services.md)|
78-
|User-defined Hierarchies|Yes|Yes|Yes|
79-
|Writeback|Yes|No|No|
52+
||||
53+
|-|-|-|
54+
||Multidimensional|Tabular|
55+
|Actions|Yes|No|
56+
|Aggregations|Yes|No|
57+
|Calculated Column|No|Yes|
58+
|Calculated Measures|Yes|Yes|
59+
|Calculated Tables|No|Yes<sup>1</sup>|
60+
|Custom Assemblies|Yes|No|
61+
|Custom Rollups|Yes|No|
62+
|Default Member|Yes|No|
63+
|Display folders|Yes|Yes<sup>1</sup>|
64+
|Distinct Count|Yes|Yes (via DAX)|
65+
|Drillthrough|Yes|Yes (depends on client application)|
66+
|Hierarchies|Yes|Yes|
67+
|KPIs|Yes|Yes|
68+
|Linked objects|Yes|Yes (linked tables)|
69+
|M expressions|No|Yes<sup>1</sup>|
70+
|Many-to-many relationships|Yes|No (but there is [bi-directional cross filters](../analysis-services/tabular-models/bi-directional-cross-filters-tabular-models-analysis-services.md) at 1200 and higher compatibility levels)|
71+
|Named sets|Yes|No|
72+
|Ragged Hierarchies|Yes|Yes<sup>1</sup>|
73+
|Parent-child Hierarchies|Yes|Yes (via DAX)|
74+
|Partitions|Yes|Yes|
75+
|Perspectives|Yes|Yes|
76+
|Row-level Security|Yes|Yes|
77+
|Object-level Security|Yes|Yes<sup>1</sup>|
78+
|Semi-additive Measures|Yes|Yes|
79+
|Translations|[Yes](../analysis-services/multidimensional-models/translations-in-multidimensional-models-analysis-services.md)|Yes|
80+
|User-defined Hierarchies|Yes|Yes|
81+
|Writeback|Yes|No|
8082

8183
<sup>1</sup> See [Compatibility Level for Tabular models in Analysis Services](../analysis-services/tabular-models/compatibility-level-for-tabular-models-in-analysis-services.md) for information about functional differences between compatibility levels.
8284

@@ -107,7 +109,7 @@ manager: "erikre"
107109

108110
**Supported Data Sources**
109111

110-
Tabular models can import data from relational data sources, data feeds, and some document formats. You can also use OLE DB for ODBC providers with tabular models. Tabular models at the 1400 compatibility level offer a signifcant increase in the variety of data sources from which you can import from. This is due to the introduction of the modern Get Data data query and import features in SSDT.
112+
Tabular models can import data from relational data sources, data feeds, and some document formats. You can also use OLE DB for ODBC providers with tabular models. Tabular models at the 1400 compatibility level offer a significant increase in the variety of data sources from which you can import from. This is due to the introduction of the modern Get Data data query and import features in SSDT utilizing the M formula query language.
111113

112114
Multidimensional solutions can import data from relational data sources using OLE DB native and managed providers.
113115

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

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -13,7 +13,6 @@
1313
## [New-RestoreLocation cmdlet](new-restorelocation-cmdlet.md)
1414
## [Remove-RoleMember cmdlet](remove-rolemember-cmdlet.md)
1515
## [Restore-ASDatabase cmdlet](restore-asdatabase-cmdlet.md)
16-
## [AMO PowerShell Example](amo-powershell-example.md)
1716
# [PowerShell Reference for Power Pivot for SharePoint](powershell-reference-for-power-pivot-for-sharepoint.md)
1817
## [Get-PowerPivotServiceApplication cmdlet](get-powerpivotserviceapplication-cmdlet.md)
1918
## [Get-PowerPivotSystemServiceInstance cmdlet](get-powerpivotsystemserviceinstance-cmdlet.md)

0 commit comments

Comments
 (0)