{"id":30270,"date":"2024-02-05T07:33:00","date_gmt":"2024-02-05T06:33:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30270"},"modified":"2024-02-29T12:35:28","modified_gmt":"2024-02-29T11:35:28","slug":"definicao-de-xml-for-analysis-xmla","status":"publish","type":"post","link":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/","title":{"rendered":"Defini\u00e7\u00e3o de XML for Analysis (XMLA)"},"content":{"rendered":"\n<p>O que \u00e9 a defini\u00e7\u00e3o de XML for Analysis ou (XMLA), linguagem abreviada como Extensible Markup Language for Analysis. \u00c9 um protocolo constru\u00eddo sobre a linguagem XML. Permite o acesso a dados de fontes de dados multidimensionais padr\u00e3o. Aplica\u00e7\u00f5es cliente acessam cubos da Microsoft e modelos tabulares usando a linguagem XMLA e o protocolo HTTP. Primeiramente, o que \u00e9 XMLA ou XML for Analysis? Microsoft Analysis Services OLAP cubes e Tabular models ambos usam XMLA. Em outras palavras, \u00e9 o protocolo \u00fanico que permite a comunica\u00e7\u00e3o com as aplica\u00e7\u00f5es de an\u00e1lise de dados do usu\u00e1rio final.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-qual-e-a-definicao-de-xml-for-analysis\">1. Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis ?<\/h2>\n\n\n\n<p>Em segundo lugar, como os desenvolvedores da Microsoft utilizam XML for Analysis? Desenvolvedores de Business Intelligence da Microsoft usam XMLA para integra\u00e7\u00e3o de aplica\u00e7\u00f5es cliente com Analysis Services. E sem depend\u00eancias do framework Microsoft .NET.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-xmla-como-um-padrao-simples\">2. XMLA como um padr\u00e3o simples<\/h2>\n\n\n\n<p>Em outras palavras, para comunicar-se do cliente para o servidor, os \u00fanicos dois componentes necess\u00e1rios s\u00e3o uma conectividade <strong>HTTP<\/strong> e a linguagem <strong>XMLA ou XML for Analysis<\/strong>. Confira este artigo tamb\u00e9m sobre Microsoft Business Intelligence, \u00e9 sobre <a href=\"https:\/\/expert-only.com\/en\/it-concepts\/mdx-stands-for-multidimensional-expressions\/\"><strong>MDX literalmente o SQL para 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>A Defini\u00e7\u00e3o de XML for Analysis: um padr\u00e3o da Microsoft para conectividade SSAS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h5 class=\"wp-block-heading\" id=\"h-o-objetivo-da-norma-xmla-e-colmatar-o-fosso-entre-as-tecnologias\">O objetivo da norma XMLA \u00e9 colmatar o fosso entre as tecnologias<\/h5>\n\n\n\n<p><strong>A principal vantagem do XMLA \u00e9 sua capacidade de interligar diferentes sistemas.<\/strong><\/p>\n\n\n\n<p>N\u00e3o importa se o cliente \u00e9 constru\u00eddo sobre tecnologia Microsoft ou n\u00e3o; desde que possa enviar solicita\u00e7\u00f5es XMLA por HTTP, pode se comunicar com os servi\u00e7os BI da Microsoft. Esta interoperabilidade \u00e9 um fator chave na ado\u00e7\u00e3o generalizada do XMLA dentro da comunidade de intelig\u00eancia empresarial.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Uso pr\u00e1tico do XML for Analysis<\/h2>\n\n\n\n<p><strong>Utilize XMLA, por exemplo, para desenvolver programaticamente um Modelo Tabular SSAS.<\/strong><\/p>\n\n\n\n<p>Ou para criar script de implanta\u00e7\u00e3o da conex\u00e3o, as tabelas &#8211; incluindo as tabelas de fatos e as dimens\u00f5es &#8211; os Pap\u00e9is de seguran\u00e7a ou o banco de dados tabular completo. Para gerar esses scripts XMLA, simplesmente conecte-se a uma inst\u00e2ncia Tabular SSAS com <strong><a href=\"https:\/\/expert-only.com\/en\/ssms\/download-sql-server-management-studio-18-ssms\/\">SSMS<\/a><\/strong>, clique com o bot\u00e3o direito e selecione Scripts do objeto. Tr\u00eas op\u00e7\u00f5es principais est\u00e3o dispon\u00edveis ao gerar scripts XMLA para um banco de dados tabular:<\/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>Confira a <a href=\"https:\/\/en.wikipedia.org\/wiki\/XML_for_Analysis\">p\u00e1gina da Wikipedia sobre XML for Analysis<\/a> padr\u00e3o. Para ir al\u00e9m e explicar os benef\u00edcios do XML em vez de outros padr\u00f5es propriet\u00e1rios, por exemplo: \u00e9 open source, \u00e9 f\u00e1cil de ler para um humano, \u00e9 um arquivo simples com tags. Significa que a estrutura est\u00e1 encapsulada no arquivo e qualquer estrutura de dados pode ser armazenada dentro de uma mensagem XML.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-1-script-xmla-para-implantar-um-modelo-tabular-ssas-in-memory\">3.1 Script XMLA para implantar um Modelo Tabular SSAS In-Memory<\/h3>\n\n\n\n<p>Para ilustrar essa defini\u00e7\u00e3o de XML for Analysis, vamos ter uma abordagem mais pr\u00e1tica deste padr\u00e3o. O script XMLA abaixo usa a palavra-chave CREATE para criar um exemplo de Modelo Tabular lendo dados de uma tabela de Vendas, chamada <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>Um simples exemplo de Modelo Tabular SSAS&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;!-- Ajuste a string de conex\u00e3o para o seu banco de dados SQL aqui -->\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;!-- Selecione o processo do Modelo Tabular aqui -->\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<h3 class=\"wp-block-heading\" id=\"h-3-2-exemplo-de-comando-execute-xmla\">3.2 Exemplo de Comando Execute XMLA<\/h3>\n\n\n\n<p>O comando <code>Execute<\/code> em XMLA \u00e9 usado para realizar opera\u00e7\u00f5es como executar consultas MDX ou Data Mining Prediction (DMX) contra uma fonte de dados anal\u00edtica. Aqui est\u00e1 um exemplo de um comando XMLA <code>Execute<\/code> que executa uma consulta MDX:<\/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-o-comando-discover-em-xml-for-analysis\">3.3 O comando Discover em XML for Analysis<\/h3>\n\n\n\n<p>O comando Discover \u00e9 utilizado para solicitar informa\u00e7\u00f5es de metadados sobre as fontes de dados dispon\u00edveis no servidor. Isso pode incluir uma lista de bancos de dados, cubos, dimens\u00f5es, medidas, etc. Aqui est\u00e1 um exemplo b\u00e1sico de um comando Discover:<\/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\">4. Pontos finais XMLA para Power BI<\/h2>\n\n\n\n<p>A conectividade do Power BI com <a href=\"https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview\/\" target=\"_blank\" rel=\"noreferrer noopener\">pontos finais XMLA<\/a> anunciada h\u00e1 alguns anos permite acessar conjuntos de dados do Power BI atrav\u00e9s do protocolo XMLA. Isso torna qualquer fonte de dados pronta para XMLA acess\u00edvel atrav\u00e9s de uma ampla variedade de ferramentas, como por exemplo:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL Server Reporting Services (SSRS)<\/li>\n\n\n\n<li>Relat\u00f3rios no 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\/\">Tabelas Din\u00e2micas do Excel<\/a><\/li>\n\n\n\n<li>Ferramentas de visualiza\u00e7\u00e3o de dados de terceiros como <a href=\"https:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tableau<\/a> ou <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-sobre-a-definicao-do-xml-for-analysis\">Sobre a defini\u00e7\u00e3o do XML for Analysis<\/h3>\n\n\n\n<p>Em conclus\u00e3o, a defini\u00e7\u00e3o de XML for Analysis (XMLA) destaca que \u00e9 um protocolo crucial que permite uma comunica\u00e7\u00e3o eficiente entre aplica\u00e7\u00f5es cliente e Microsoft Analysis Services, incluindo OLAP cubes e Tabular models. Utilizando o Extensible Markup Language (XML), XMLA garante acesso padronizado aos dados atrav\u00e9s de fontes de dados multidimensionais.<\/p>\n\n\n\n<p>Este artigo n\u00e3o s\u00f3 explora os conceitos fundamentais e usos pr\u00e1ticos do XMLA, mas tamb\u00e9m ilustra sua aplica\u00e7\u00e3o por meio de um script para implanta\u00e7\u00e3o de um modelo tabular. Ao facilitar intera\u00e7\u00f5es de dados sem problemas, XMLA desempenha um papel vital na paisagem de an\u00e1lise de dados e intelig\u00eancia empresarial, demonstrando sua import\u00e2ncia no acesso e an\u00e1lise de estruturas de dados complexas.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriais-sql-e-ti wp-block-embed-tutoriais-sql-e-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"2mGjzObCUq\"><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; Tutoriais SQL e TI\" src=\"https:\/\/expert-only.com\/en\/concepts\/mdx-or-multidimensional-expressions\/embed\/#?secret=u72QgrhBgg#?secret=2mGjzObCUq\" data-secret=\"2mGjzObCUq\" 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>O que \u00e9 a defini\u00e7\u00e3o de XML for Analysis ou (XMLA), linguagem abreviada como Extensible Markup Language for Analysis. \u00c9 um protocolo constru\u00eddo sobre a linguagem XML. Permite o acesso a dados de fontes de dados multidimensionais padr\u00e3o. Aplica\u00e7\u00f5es <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\" title=\"Defini\u00e7\u00e3o de XML for Analysis (XMLA)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10825,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[],"class_list":{"0":"post-30270","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-conceitos"},"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>Defini\u00e7\u00e3o de XML for Analysis (XMLA) - Conceitos de TI<\/title>\n<meta name=\"description\" content=\"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.\" \/>\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\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Defini\u00e7\u00e3o de XML for Analysis (XMLA)\" \/>\n<meta property=\"og:description\" content=\"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriais SQL e TI\" \/>\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-02-29T11:35:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-1024x576.jpg\" \/>\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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Defini\u00e7\u00e3o de XML for Analysis (XMLA)\",\"datePublished\":\"2024-02-05T06:33:00+00:00\",\"dateModified\":\"2024-02-29T11:35:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\"},\"wordCount\":844,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg\",\"articleSection\":[\"Conceitos de TI\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\",\"name\":\"Defini\u00e7\u00e3o de XML for Analysis (XMLA) - Conceitos de TI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg\",\"datePublished\":\"2024-02-05T06:33:00+00:00\",\"dateModified\":\"2024-02-29T11:35:28+00:00\",\"description\":\"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"pt\",\"item\":\"https:\/\/expert-only.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Defini\u00e7\u00e3o de XML for Analysis (XMLA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"name\":\"Tutoriais SQL e TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/#\/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\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/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":"Defini\u00e7\u00e3o de XML for Analysis (XMLA) - Conceitos de TI","description":"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.","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\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/","og_locale":"pt_PT","og_type":"article","og_title":"Defini\u00e7\u00e3o de XML for Analysis (XMLA)","og_description":"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.","og_url":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/","og_site_name":"Tutoriais SQL e TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-05T06:33:00+00:00","article_modified_time":"2024-02-29T11:35:28+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/code-1839406_1920x1080-1024x576.jpg","type":"","width":"","height":""}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tempo estimado de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Defini\u00e7\u00e3o de XML for Analysis (XMLA)","datePublished":"2024-02-05T06:33:00+00:00","dateModified":"2024-02-29T11:35:28+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/"},"wordCount":844,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","articleSection":["Conceitos de TI"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/","url":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/","name":"Defini\u00e7\u00e3o de XML for Analysis (XMLA) - Conceitos de TI","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","datePublished":"2024-02-05T06:33:00+00:00","dateModified":"2024-02-29T11:35:28+00:00","description":"Qual \u00e9 a defini\u00e7\u00e3o de XML for Analysis or XMLA? Norma da Microsoft baseia-se em XML para a conetividade do Analysis Services.","breadcrumb":{"@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/pt-pt\/conceitos\/definicao-de-xml-for-analysis-xmla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"pt","item":"https:\/\/expert-only.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Defini\u00e7\u00e3o de XML for Analysis (XMLA)"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/pt-pt\/#website","url":"https:\/\/expert-only.com\/pt-pt\/","name":"Tutoriais SQL e TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/pt-pt\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/pt-pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/#\/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\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/wp-json\/wp\/v2\/posts\/30270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=30270"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/30270\/revisions"}],"predecessor-version":[{"id":30281,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/30270\/revisions\/30281"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media\/10825"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=30270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=30270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=30270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}