{"id":6937,"date":"2024-02-05T07:33:00","date_gmt":"2024-02-05T06:33:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6937"},"modified":"2024-03-06T12:38:36","modified_gmt":"2024-03-06T11:38:36","slug":"xml-for-analysis-definition-xmla","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/","title":{"rendered":"XML for Analysis Definition (XMLA)"},"content":{"rendered":"\n<p>What is the definition of XML for Analysis or (XMLA), language abbreviated as Extensible Markup Language for Analysis. It&#8217;s a protocol built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses Microsoft cubes and tabular models using the XMLA language and the HTTP protocol. First, what is XMLA or XML for Analysis? Microsoft Analysis Services OLAP cubes and Tabular models both uses XMLA. In other words, it&#8217;s the unique protocol that allows communication with end-user&#8217;s data analytics applications.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#1-what-definition-for-xml-for-analysis\" >1. What definition for XML for Analysis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#2-xmla-as-a-simple-standard\" >2. XMLA as a simple standard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#3-xmla-practical-usage\" >3. XMLA practical usage<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#4-xml-for-analysis-power-bi-endpoints\" >4. XML for Analysis Power BI Endpoints<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-what-definition-for-xml-for-analysis\"><span class=\"ez-toc-section\" id=\"1-what-definition-for-xml-for-analysis\"><\/span>1. What definition for XML for Analysis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Secondly, how does Microsoft developers use XML for Analysis? Microsoft Business Intelligence developers use XMLA for client applications integration with Analysis Services. And without dependencies to the Microsoft .NET framework.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-xmla-as-a-simple-standard\"><span class=\"ez-toc-section\" id=\"2-xmla-as-a-simple-standard\"><\/span>2. XMLA as a simple standard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In other words, to communicate from the client to the server, the only two necessary components are an <strong>HTTP <\/strong>connectivity and the <strong>XMLA or XML for Analysis<\/strong> language. Check this article also on Microsoft Business Intelligence, it&#8217;s about <a href=\"https:\/\/expert-only.com\/en\/concepts\/mdx-or-multidimensional-expressions\/\"><strong>the MDX language, literally the SQL for OLAP cubes<\/strong><\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-1024x576.jpg\" alt=\"The XML for Analysis Definition : a Microsoft standard for SSAS connectivity \" class=\"wp-image-10504\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-1024x576.jpg 1024w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-300x169.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-768x432.jpg 768w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-1536x864.jpg 1536w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-678x381.jpg 678w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>The XML for Analysis Definition : a Microsoft standard for SSAS connectivity <\/em><\/figcaption><\/figure><\/div>\n\n\n<h5 class=\"wp-block-heading\" id=\"h-bridging-the-gap-with-xmla\">Bridging the Gap with XMLA<\/h5>\n\n\n\n<p><strong>The primary advantage of XMLA is its ability to bridge different systems.<\/strong><\/p>\n\n\n\n<p>It does not matter whether the client is built on Microsoft technology or not; as long as it can send XMLA requests over HTTP, it can communicate with Microsoft BI services. This interoperability is a key factor in the widespread adoption of XMLA within the business intelligence community.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-xmla-practical-usage\"><\/span>3. XMLA practical usage<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Use XMLA for example to develop an SSAS Tabular Model programmatically.<\/strong><\/p>\n\n\n\n<p>Or to create deployment script of the connection, the tables &#8211; including the fact tables and the dimensions &#8211; the security Roles or the full tabular database. To generate these XMLA scripts, simply connect to an SSAS Tabular instance with <strong><a href=\"https:\/\/expert-only.com\/en\/ssms\/download-sql-server-management-studio-18-ssms\/\">SSMS<\/a><\/strong>, then right click and select Scripts the object. Three main options are available when generating XMLA scripts for a tabular database: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CREATE<\/strong><\/li>\n\n\n\n<li><strong>CREATE OR REPLACE<\/strong><\/li>\n\n\n\n<li><strong>DELETE<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Check the <a href=\"https:\/\/en.wikipedia.org\/wiki\/XML_for_Analysis\">Wikipedia pa<\/a><a href=\"https:\/\/en.wikipedia.org\/wiki\/XML_for_Analysis\" target=\"_blank\" rel=\"noreferrer noopener\">g<\/a><a href=\"https:\/\/en.wikipedia.org\/wiki\/XML_for_Analysis\">e on XML for Analysis<\/a> standard. To go further and explain the benefits of XML instead of other proprietary standards for example: it&#8217;s open source, it&#8217;s easy to read for a human, it&#8217;s a simple file with tags. It means the structure is encapsulated in the file and any data structure can be stored inside an XML message.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-1-xmla-script-to-deploy-an-ssas-in-memory-tabular-model\">3.1 XMLA script to deploy an SSAS In-Memory Tabular Model<\/h3>\n\n\n\n<p>To illustrate this XML for Analysis definition, let&#8217;s have a more practical approach of this standard. The XMLA script below uses the CREATE keyword to create an example Tabular Model reading data from a Sales table, called <em>Tabular_Model_Sales<\/em>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;Batch xmlns=\"http:\/\/schemas.microsoft.com\/analysisservices\/2003\/engine\">\n  &lt;Create>\n    &lt;ObjectDefinition>\n      &lt;Database>\n        &lt;ID>Tabular_Model_Sales&lt;\/ID>\n        &lt;Name>Tabular_Model_Sales&lt;\/Name>\n        &lt;Description>A simple SSAS Tabular Model Example&lt;\/Description>\n        &lt;CompatibilityLevel>1500&lt;\/CompatibilityLevel>\n        &lt;DataSources>\n          &lt;DataSource xsi:type=\"RelationalDataSource\">\n            &lt;ID>DataSource&lt;\/ID>\n            &lt;Name>DataSource&lt;\/Name>\n            &lt;!-- Adjust connection string to your SQL database here -->\n            &lt;ConnectionString>Data Source=localhost;Initial Catalog=YourDatabase;Integrated Security=SSPI;&lt;\/ConnectionString>\n          &lt;\/DataSource>\n        &lt;\/DataSources>\n        &lt;Model>\n          &lt;Tables>\n            &lt;Table>\n              &lt;ID>SalesData&lt;\/ID>\n              &lt;Name>SalesData&lt;\/Name>\n              &lt;DataAccessOptions>Transactional&lt;\/DataAccessOptions>\n              &lt;Source xsi:type=\"QueryBinding\">\n                &lt;DataSourceID>DataSource&lt;\/DataSourceID>\n                &lt;Query>SELECT [Date], [Sales], [Quantity] FROM [Sales]&lt;\/Query>\n              &lt;\/Source>\n              &lt;Columns>\n                &lt;Column>\n                  &lt;ID>Date&lt;\/ID>\n                  &lt;Name>Date&lt;\/Name>\n                  &lt;DataType>DateTime&lt;\/DataType>\n                  &lt;SourceColumn>Date&lt;\/SourceColumn>\n                &lt;\/Column>\n                &lt;Column>\n                  &lt;ID>Sales&lt;\/ID>\n                  &lt;Name>Sales&lt;\/Name>\n                  &lt;DataType>Double&lt;\/DataType>\n                  &lt;SourceColumn>Sales&lt;\/SourceColumn>\n                &lt;\/Column>\n                &lt;Column>\n                  &lt;ID>Quantity&lt;\/ID>\n                  &lt;Name>Quantity&lt;\/Name>\n                  &lt;DataType>Int64&lt;\/DataType>\n                  &lt;SourceColumn>Quantity&lt;\/SourceColumn>\n                &lt;\/Column>\n              &lt;\/Columns>\n            &lt;\/Table>\n          &lt;\/Tables>\n        &lt;\/Model>\n      &lt;\/Database>\n    &lt;\/ObjectDefinition>\n  &lt;\/Create>\n  &lt;!-- Select the Tabulat Model process here -->\n  &lt;Process>\n    &lt;Type>ProcessFull&lt;\/Type>\n    &lt;Object>\n      &lt;DatabaseID>Tabular_Model_Sales&lt;\/DatabaseID>\n    &lt;\/Object>\n  &lt;\/Process>\n&lt;\/Batch>\n<\/pre>\n\n\n\n<p>The main steps used in the tabular model definition, written in XML for Analysis, for the creation of the database are the following ones:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create the SSAS database<\/strong>: The  XML for Analysis script starts with a <strong>Batch<\/strong> element, to indicate a collection of XMLA commands. The <strong>Create<\/strong> command is used to initiate the creation of the new database named <em>Tabular_Model_Sales<\/em>.<\/li>\n\n\n\n<li><strong>Define Database<\/strong>: Within <strong>ObjectDefinition<\/strong>, the database details are specified, including its <strong>ID<\/strong>, <strong>Name<\/strong>, and <strong>CompatibilityLevel<\/strong>. This section ensure it operates smoothly within the Analysis Services environment, including the SQL Server version.<\/li>\n\n\n\n<li><strong>Set Up Data Source<\/strong>: The <strong>DataSources<\/strong> section defines the data source for the database, specifying a <strong>DataSource<\/strong> element with a type attribute indicating it&#8217;s a relational database. The <strong>ConnectionString<\/strong> is provided to connect to the underlying data source where the actual data resides.<\/li>\n\n\n\n<li><strong>Create Model<\/strong>: Within the <strong>Model<\/strong> section, the <strong>Tables<\/strong> are defined. A single table named <em>SalesData<\/em> is created with a <strong>QueryBinding<\/strong> source type, which includes a SQL query to select data from the source database.<\/li>\n\n\n\n<li><strong>Define Columns<\/strong>: Inside the <strong>Table<\/strong> element, <strong>Columns<\/strong> are defined, specifying the <strong>ID<\/strong>, <strong>Name<\/strong>, <strong>DataType<\/strong>, and <strong>SourceColumn<\/strong> for each column in the table. This maps the columns from the source query to the columns in the tabular model.<\/li>\n\n\n\n<li><strong>Process Database<\/strong>: Finally, a <strong>Process<\/strong> command is included at the end of the XML for Analysis script for the definition of the database process, here the option is <em>Full<\/em>. This step loads the data into the model using In-Memory technology, making the data available for analysis to the end users. Users can connect to the Tabular model using Excel Pivot tables, Power BI or Reporting Services.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-2-xmla-execute-command-example\">3.2 XMLA Execute Command example<\/h3>\n\n\n\n<p>The <code>Execute<\/code> command in XMLA is used to perform operations such as running MDX or Data Mining Prediction (DMX) queries against an analytical data source. Here&#8217;s an example of an XMLA <code>Execute<\/code> command that runs an MDX query:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\">\n     &lt;Command>\n         &lt;Statement>\n             SELECT [Measures].[Sales Amount] ON COLUMNS\n             FROM [Sales Cube]\n         &lt;\/Statement>\n     &lt;\/Command>\n     &lt;Properties>\n         &lt;PropertyList>\n             &lt;Catalog>AdventureWorksDW&lt;\/Catalog>\n             &lt;Format>Multidimensional&lt;\/Format>\n         &lt;\/PropertyList>\n     &lt;\/Properties>\n&lt;\/Execute><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-3-the-xmla-discover-command\">3.3 The XMLA Discover Command<\/h3>\n\n\n\n<p>The Discover command is utilized to request metadata information about the data sources available on the server. This could include a list of databases, cubes, dimensions, measures, and so forth. Here is a basic example of a Discover command:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> &lt;Discover xmlns=\"urn:schemas-microsoft-com:xml-analysis\">\n     &lt;RequestType>DISCOVER_DATASOURCES&lt;\/RequestType>\n     &lt;Restrictions\/>\n     &lt;Properties\/>\n &lt;\/Discover><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-xml-for-analysis-power-bi-endpoints\"><\/span>4. XML for Analysis Power BI Endpoints<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The Power BI connectivity with <a href=\"https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview\/\" target=\"_blank\" rel=\"noreferrer noopener\">XMLA endpoints<\/a> announced a couple of years ago allows to access Power BI datasets through the XMLA protocol. It makes any XMLA ready data sources accessible through a wide variety of tools, like for example: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL Server Reporting Services (SSRS)<\/li>\n\n\n\n<li>Reports in Power BI Premium, Power BI Report Server<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/excel-tips\/create-a-pivot-table-with-excel\/\">Excel PivotTables<\/a><\/li>\n\n\n\n<li>Third party data-visualization tools like <a href=\"https:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tableau<\/a> or <a href=\"https:\/\/www.qlik.com\/us\/products\/qlikview\" target=\"_blank\" rel=\"noreferrer noopener\">QlikView<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssms\/download-ssms-18\/\">SQL Server Management Studio (SSMS)<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-about-the-xml-for-analysis-protocol\">About the  XML for Analysis protocol<\/h3>\n\n\n\n<p>In conclusion, the definition of XML for Analysis (XMLA) highlights that it is a crucial protocol that enables efficient communication between client applications and Microsoft Analysis Services, including OLAP cubes and Tabular models. Utilizing the Extensible Markup Language (XML), XMLA ensures standardized data access across multidimensional data sources.<\/p>\n\n\n\n<p>This article not only explores XMLA&#8217;s fundamental concepts and practical uses but also illustrates its application through a script for deploying a tabular model. By facilitating seamless data interactions, XMLA plays a vital role in the data analytics and business intelligence landscape, demonstrating its importance in accessing and analysing complex data structures.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Rv5zeqbA9Y\"><a href=\"https:\/\/expert-only.com\/en\/concepts\/mdx-or-multidimensional-expressions\/\">MDX or Multidimensional Expressions<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;MDX or Multidimensional Expressions&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/concepts\/mdx-or-multidimensional-expressions\/embed\/#?secret=NGqeD6N9On#?secret=Rv5zeqbA9Y\" data-secret=\"Rv5zeqbA9Y\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>What is the definition of XML for Analysis or (XMLA), language abbreviated as Extensible Markup Language for Analysis. It&#8217;s a protocol built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\" title=\"XML for Analysis Definition (XMLA)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[499],"tags":[],"class_list":{"0":"post-6937","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-concepts"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>XML for Analysis Definition (XMLA) - IT Concepts<\/title>\n<meta name=\"description\" content=\"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.\" \/>\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\/concepts\/xml-for-analysis-definition-xmla\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"XML for Analysis Definition (XMLA)\" \/>\n<meta property=\"og:description\" content=\"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-05T06:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T11:38:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"XML for Analysis Definition (XMLA)\",\"datePublished\":\"2024-02-05T06:33:00+00:00\",\"dateModified\":\"2024-03-06T11:38:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\"},\"wordCount\":1002,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg\",\"articleSection\":[\"IT Concepts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\",\"url\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\",\"name\":\"XML for Analysis Definition (XMLA) - IT Concepts\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg\",\"datePublished\":\"2024-02-05T06:33:00+00:00\",\"dateModified\":\"2024-03-06T11:38:36+00:00\",\"description\":\"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"XML for Analysis Definition (XMLA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"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\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"XML for Analysis Definition (XMLA) - IT Concepts","description":"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.","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\/concepts\/xml-for-analysis-definition-xmla\/","og_locale":"en_US","og_type":"article","og_title":"XML for Analysis Definition (XMLA)","og_description":"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.","og_url":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-05T06:33:00+00:00","article_modified_time":"2024-03-06T11:38:36+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"XML for Analysis Definition (XMLA)","datePublished":"2024-02-05T06:33:00+00:00","dateModified":"2024-03-06T11:38:36+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/"},"wordCount":1002,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg","articleSection":["IT Concepts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/","url":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/","name":"XML for Analysis Definition (XMLA) - IT Concepts","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg","datePublished":"2024-02-05T06:33:00+00:00","dateModified":"2024-03-06T11:38:36+00:00","description":"What is the definition of XML for Analysis or XMLA ? This Microsoft standard is based on XML and used for Analysis Services connectivity.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/01\/planning-5570360_1920.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/concepts\/xml-for-analysis-definition-xmla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"XML for Analysis Definition (XMLA)"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","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"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=6937"}],"version-history":[{"count":14,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6937\/revisions"}],"predecessor-version":[{"id":30277,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6937\/revisions\/30277"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6108"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=6937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=6937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=6937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}