{"id":20897,"date":"2017-10-02T11:00:10","date_gmt":"2017-10-02T18:00:10","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=20897"},"modified":"2024-01-22T22:51:03","modified_gmt":"2024-01-23T06:51:03","slug":"analysis-services-innovations-in-sql-server-2017","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/","title":{"rendered":"Analysis Services Innovations in SQL Server 2017"},"content":{"rendered":"<p><em>This post was authored by Christian Wade, Senior Program Manager, Microsoft<\/em><\/p>\n<p>Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server\u2019s BI offerings. SSAS 2017 brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights.<\/p>\n<p>SSAS 2017 introduces the 1400 <a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/tabular-models\/compatibility-level-for-tabular-models-in-analysis-services\" rel=\"noopener\">compatibility level<\/a>. Here are just some highlights of the new features:<\/p>\n<ul>\n<li>New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This enables support for a range of additional data sources, and data transformation and mashup capabilities.<\/li>\n<li>Support for BI tools such as Microsoft Excel enables drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.<\/li>\n<li>Object-level security to secure table and column names in addition to the data within them.<\/li>\n<li>Enhanced support for ragged hierarchies such as organizational charts and chart of accounts.<\/li>\n<li>Various other improvements for performance, monitoring, and consistency with the Power BI modeling experience.<\/li>\n<\/ul>\n<p>To benefit from the new features for models at the 1400 compatibility level, you\u2019ll need to download and install SQL Server Data Tools (SSDT) 17.0 from <a target=\"_blank\" href=\"https:\/\/msdn.microsoft.com\/library\/mt204009.aspx\" rel=\"noopener\">documentation<\/a>.<\/p>\n<p>In SSDT, you can select the new 1400 compatibility level when creating new tabular model projects. Alternatively, you can upgrade an existing tabular model by selecting the Model.bim file in Solution Explorer and setting the Compatibility Level to 1400 in the Properties window. Models at the 1400 compatibility level cannot be downgraded to lower compatibility levels.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"344\" class=\"aligncenter size-full wp-image-20905\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\" srcset=\"\"><\/a><\/p>\n<h2>New infrastructure for data connectivity<\/h2>\n<p>1400 models introduce a new infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This is based on the similar Power Query functionality in Power BI Desktop and Microsoft Excel 2016. For more information, please refer to the <a target=\"_blank\" href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2016\/12\/16\/introducing-a-modern-get-data-experience-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services\/\" rel=\"noopener\">Analysis Services Team blog<\/a>.<\/p>\n<h2>Detail Rows<\/h2>\n<p>A much-requested feature for tabular models is the ability to define a custom row set contributing to a measure value. Multidimensional models achieve this by using drillthrough and rowset actions. This allows end-users to view information in more detail than the aggregated level.<\/p>\n<p>For example, the following PivotTable shows Internet Total Sales by year from the Adventure Works sample tabular model. Users can right-click the cell for 2010 and then select the Show Details menu option to view the detail rows.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/detail-rows-403x350.png\"><img loading=\"lazy\" decoding=\"async\" width=\"403\" height=\"350\" class=\"aligncenter size-mediumlarge wp-image-20915\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/detail-rows-403x350.png\" srcset=\"\"><\/a><\/p>\n<p>By default, all the columns in the Internet Sales table are displayed. This behavior is often not meaningful for the user because too many columns may be shown, and the table may not have the necessary columns to show useful information such as customer name and order information.<\/p>\n<h3><em>Detail Rows Expression Property for Measures<\/em><\/h3>\n<p>1400 models introduce the Detail Rows Expression property for measures. It allows the modeler to customize the columns and rows returned to the end user. The following example uses the DAX Editor in SSDT to define the columns to be returned for the Internet Total Sales measure.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/dax-editor-451x350.png\"><img loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"350\" class=\"aligncenter size-mediumlarge wp-image-20916\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/dax-editor-451x350.png\" srcset=\"\"><\/a><\/p>\n<p>With the property defined and the model deployed, the custom row set is returned when the user selects Show Details. It automatically honors the filter context of the cell that was selected. In this example, only the rows for 2010 value are displayed.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/detail-rows-2-500x150.png\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"150\" class=\"aligncenter size-mediumlarge wp-image-20926\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/detail-rows-2-500x150.png\" srcset=\"\"><\/a><\/p>\n<p>Further information on Detail Rows is available our blog post,\u00a0<em><a target=\"_blank\" href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2016\/12\/16\/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services\/\" rel=\"noopener\">What\u2019s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services<\/a>.<\/em><\/p>\n<h2>Object-Level Security<\/h2>\n<p>Roles in tabular models support a granular list of permissions, and row-level filters to help protect sensitive data. 1400 models introduce table- and column-level security allowing sensitive table and column names to be protected in addition to the data within them. Collectively these features are referred to as object-level security (OLS).<\/p>\n<p>The following example uses the Role Manager in SSDT to protect sensitive employee information. Unauthorized users cannot access the selected columns using client tools like Power BI and Excel Pivot Tables. Additionally, such users cannot query the columns using DAX or MDX, or measures that refer to them.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/role-manager-416x350.png\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"350\" class=\"aligncenter size-mediumlarge wp-image-20935\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/role-manager-416x350.png\" srcset=\"\"><\/a><\/p>\n<p>Further information on OLS is available in a recent post, titled,\u00a0<em><a target=\"_blank\" href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/04\/19\/whats-new-in-sql-server-2017-ctp-2-0-for-analysis-services\/\" rel=\"noopener\">What\u2019s new in SQL Server 2017 CTP 2.0 for Analysis Services<\/a>.<\/em><\/p>\n<h2>Ragged Hierarchies<\/h2>\n<p>Tabular models with previous compatibility levels can be used to model parent-child hierarchies. Hierarchies with a differing number of levels are referred to as <em>ragged hierarchies<\/em>. An example of a ragged hierarchy is an organizational chart. By default, ragged hierarchies are displayed with blanks for levels below the lowest child. This can look untidy to users, as shown by this organizational chart in Adventure Works:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/row-labels.png\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"310\" class=\"aligncenter size-full wp-image-20956\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/row-labels.png\" srcset=\"\"><\/a><\/p>\n<p>1400 models introduce the Hide Members property to correct this. Simply set the Hide Members property to Hide blank members.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/hide-members.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"295\" class=\"aligncenter size-full wp-image-20947\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/hide-members.png\" srcset=\"\"><\/a><\/p>\n<p>With the property set and the model deployed, the more presentable version of the hierarchy is displayed.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/sql-500x299.png\"><img loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"200\" class=\"aligncenter wp-image-20965\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/sql-500x299.png\" srcset=\"\"><\/a><\/p>\n<h2>Other Features<\/h2>\n<p>Various other features such as the following are introduced with the 1400 compatibility level. For more information, please refer to the Analysis Services Team blogs,\u00a0<a target=\"_blank\" href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2016\/12\/16\/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services\/\" rel=\"noopener\"><em>What\u2019s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services<\/em><\/a> and <a target=\"_blank\" href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2017\/04\/19\/whats-new-in-sql-server-2017-ctp-2-0-for-analysis-services\/\" rel=\"noopener\"><em>What\u2019s new in SQL Server 2017 CTP 2.0 for Analysis Services<\/em><\/a>.<\/p>\n<ul>\n<li>Transaction-performance improvements for a more responsive developer experience.<\/li>\n<li>Dynamic Management View improvements enabling dependency analysis and reporting.<\/li>\n<li>Date relationships to easily create relationships to date dimensions based on date columns.<\/li>\n<li>DAX enhancements to make DAX more accessible and powerful. These include the IN operator, and table and row constructors.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server\u2019s BI offerings. SSAS 2017 brings a host of new<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2406,2412],"content-type":[2424,2448],"topic":[2454],"coauthors":[2487],"class_list":["post-20897","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","product-sql-server-bi","content-type-best-practices","content-type-updates","topic-business-intelligence"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server\u2019s BI offerings. SSAS 2017 brings a host of new\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-02T18:00:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Analysis Services Innovations in SQL Server 2017\",\"datePublished\":\"2017-10-02T18:00:10+00:00\",\"dateModified\":\"2024-01-23T06:51:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\"},\"wordCount\":902,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\",\"name\":\"Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\",\"datePublished\":\"2017-10-02T18:00:10+00:00\",\"dateModified\":\"2024-01-23T06:51:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analysis Services Innovations in SQL Server 2017\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/","og_locale":"en_US","og_type":"article","og_title":"Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog","og_description":"This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server\u2019s BI offerings. SSAS 2017 brings a host of new","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-10-02T18:00:10+00:00","article_modified_time":"2024-01-23T06:51:03+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Analysis Services Innovations in SQL Server 2017","datePublished":"2017-10-02T18:00:10+00:00","dateModified":"2024-01-23T06:51:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/"},"wordCount":902,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/","name":"Analysis Services Innovations in SQL Server 2017 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png","datePublished":"2017-10-02T18:00:10+00:00","dateModified":"2024-01-23T06:51:03+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/09\/solution-explorer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/10\/02\/analysis-services-innovations-in-sql-server-2017\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Analysis Services Innovations in SQL Server 2017"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20897"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=20897"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20897\/revisions"}],"predecessor-version":[{"id":50495,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/20897\/revisions\/50495"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=20897"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=20897"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=20897"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=20897"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=20897"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=20897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}