{"id":600,"count":6,"description":"SSAS or SQL Server Analysis Services is the multidimensional database of the Microsoft SQL Server Business Intelligence suite. It allows users to create and deploy multidimensional OLAP cubes with dimensions and measures.\r\n\r\nThis section is also about <a href=\"https:\/\/expert-only.com\/en\/uncategorized\/tabular-model-error-occured-while-opening\/\">Microsoft SSAS errors<\/a>, like OLAP errors or Tabular Model ones. It provides descriptions and solutions.\r\n\r\nA tabular Model is an in-memory database to query the data in a timely manner. Mainly because the model pre-calculates the data and preload it from the database.\r\n\r\nIndeed, the Microsoft Cubes have two different options and the latest and most used is the Tabular model. The Microsoft OLAP database allow connections from the Power BI software.\r\n\r\nIndeed, Analysis Services instance allows the multidimensional or Tabular option, but not both.","link":"https:\/\/expert-only.com\/en\/ssas\/","name":"SSAS","slug":"ssas","taxonomy":"category","parent":0,"meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SSAS Archives - SQL and IT Tutorials<\/title>\n<meta name=\"description\" content=\"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Archives des SSAS\" \/>\n<meta property=\"og:description\" content=\"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssas\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"CollectionPage\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssas\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssas\\\/\",\"name\":\"SSAS Archives - SQL and IT Tutorials\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\"},\"description\":\"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSAS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"name\":\"SQL Server and Data Courses\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/expert-only.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ExpertOnlyCom\\\/\",\"https:\\\/\\\/x.com\\\/expert_only\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCMS5sR_FwAetB0FmciNvUaA\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SSAS Archives - SQL and IT Tutorials","description":"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.","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:\/\/expert-only.com\/en\/ssas\/","og_locale":"en_US","og_type":"article","og_title":"Archives des SSAS","og_description":"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.","og_url":"https:\/\/expert-only.com\/en\/ssas\/","og_site_name":"SQL and IT Tutorials","twitter_card":"summary_large_image","twitter_site":"@expert_only","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/expert-only.com\/en\/ssas\/","url":"https:\/\/expert-only.com\/en\/ssas\/","name":"SSAS Archives - SQL and IT Tutorials","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"description":"SSAS ou SQL Server Analysis Services est la base de donn\u00e9es multidimensionnelle de la suite Microsoft SQL Server Business Intelligence.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssas\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"SSAS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL Server and Data Courses","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories\/600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/taxonomies\/category"}],"wp:post_type":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts?categories=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}