{"id":30268,"date":"2024-02-05T07:33:00","date_gmt":"2024-02-05T06:33:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30268"},"modified":"2024-03-06T12:39:33","modified_gmt":"2024-03-06T11:39:33","slug":"definition-de-xml-for-analysis-xmla","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/","title":{"rendered":"D\u00e9finition de XML for Analysis (XMLA)"},"content":{"rendered":"\n<p>Quelle est la d\u00e9finition de XML for Analysis ou (XMLA), langage abr\u00e9g\u00e9 en Extensible Markup Language for Analysis. C&rsquo;est un protocole construit sur le langage XML. Il permet l&rsquo;acc\u00e8s aux donn\u00e9es depuis des sources de donn\u00e9es multidimensionnelles standards. Les applications clientes acc\u00e8dent aux cubes Microsoft et aux mod\u00e8les tabulaires en utilisant le langage XMLA et le protocole HTTP.<\/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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#1-quelle-definition-pour-xml-for-analysis\" >1. Quelle d\u00e9finition pour 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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#2-xmla-comme-un-standard-simple\" >2. XMLA comme un standard simple<\/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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#3-utilisation-pratique-de-xmla\" >3. Utilisation pratique de XMLA<\/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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#4-points-de-terminaison-xmla-pour-power-bi\" >4. Points de terminaison XMLA pour Power BI<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-quelle-definition-pour-xml-for-analysis\"><span class=\"ez-toc-section\" id=\"1-quelle-definition-pour-xml-for-analysis\"><\/span>1. Quelle d\u00e9finition pour XML for Analysis ?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8rement, qu&rsquo;est-ce que XMLA ou XML for Analysis ? Les cubes OLAP de Microsoft Analysis Services et les mod\u00e8les Tabulaires utilisent tous deux XMLA. En d&rsquo;autres termes, c&rsquo;est le protocole unique permettant la communication avec les applications d&rsquo;analyse de donn\u00e9es des utilisateurs finaux.<\/p>\n\n\n\n<p>Deuxi\u00e8mement, comment les d\u00e9veloppeurs Microsoft utilisent-ils XML for Analysis ? Les d\u00e9veloppeurs de Business Intelligence Microsoft utilisent XMLA pour l&rsquo;int\u00e9gration des applications clientes avec Analysis Services, et cela sans d\u00e9pendances au framework Microsoft .NET.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-xmla-comme-un-standard-simple\"><span class=\"ez-toc-section\" id=\"2-xmla-comme-un-standard-simple\"><\/span>2. XMLA comme un standard simple<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En d&rsquo;autres termes, pour communiquer du client au serveur, les deux seuls composants n\u00e9cessaires sont une connectivit\u00e9 <strong>HTTP<\/strong> et le langage <strong>XMLA ou XML for Analysis<\/strong>. Consultez \u00e9galement cet article sur Microsoft Business Intelligence, il concerne <a href=\"https:\/\/expert-only.com\/en\/it-concepts\/mdx-stands-for-multidimensional-expressions\/\"><strong>MDX litt\u00e9ralement le SQL pour les Cubes OLAP<\/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=\"La d\u00e9finition de XML for Analysis : un standard Microsoft pour la connectivit\u00e9 SSAS\" 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>La d\u00e9finition de XML for Analysis : un standard Microsoft pour la connectivit\u00e9 SSAS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h5 class=\"wp-block-heading\" id=\"h-l-objectif-du-standard-xmla-est-de-combler-le-fosse-entre-les-technologies\">L&rsquo;objectif du standard XMLA est de combler le foss\u00e9 entre les technologies<\/h5>\n\n\n\n<p><strong>L&rsquo;avantage principal de XMLA est sa capacit\u00e9 \u00e0 relier diff\u00e9rents syst\u00e8mes.<\/strong><\/p>\n\n\n\n<p>Peu importe que le client soit construit sur la technologie Microsoft ou non ; tant qu&rsquo;il peut envoyer des requ\u00eates XMLA via HTTP, il peut communiquer avec les services BI de Microsoft. Cette interop\u00e9rabilit\u00e9 est un facteur cl\u00e9 dans l&rsquo;adoption g\u00e9n\u00e9ralis\u00e9e de XMLA au sein de la communaut\u00e9 de l&rsquo;intelligence d&rsquo;affaires.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-utilisation-pratique-de-xmla\"><\/span>3. Utilisation pratique de XMLA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Utilisez XMLA par exemple pour d\u00e9velopper un mod\u00e8le tabulaire SSAS de mani\u00e8re programmatique.<\/strong><\/p>\n\n\n\n<p>Ou pour cr\u00e9er un script de d\u00e9ploiement de la connexion, des tables &#8211; y compris les tables de fait et les dimensions &#8211; les r\u00f4les de s\u00e9curit\u00e9 ou la base de donn\u00e9es tabulaire compl\u00e8te. Pour g\u00e9n\u00e9rer ces scripts XMLA, connectez-vous simplement \u00e0 une instance Tabulaire SSAS avec <strong><a href=\"https:\/\/expert-only.com\/en\/ssms\/download-sql-server-management-studio-18-ssms\/\">SSMS<\/a><\/strong>, puis cliquez avec le bouton droit et s\u00e9lectionnez Scripts l&rsquo;objet. Trois options principales sont disponibles lors de la g\u00e9n\u00e9ration de scripts XMLA pour une base de donn\u00e9es tabulaire :<\/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>Consultez la <a href=\"https:\/\/en.wikipedia.org\/wiki\/XML_for_Analysis\">page Wikipedia sur XML for Analysis<\/a> pour approfondir et expliquer les avantages de XML par rapport \u00e0 d&rsquo;autres normes propri\u00e9taires par exemple : c&rsquo;est open source, c&rsquo;est facile \u00e0 lire pour un humain, c&rsquo;est un fichier simple avec des balises. Cela signifie que la structure est encapsul\u00e9e dans le fichier et toute structure de donn\u00e9es peut \u00eatre stock\u00e9e \u00e0 l&rsquo;int\u00e9rieur d&rsquo;un message XML.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-1-script-xmla-pour-deployer-un-modele-tabulaire-ssas-in-memory\">3.1 Script XMLA pour d\u00e9ployer un mod\u00e8le tabulaire SSAS (In-Memory)<\/h3>\n\n\n\n<p>Pour illustrer cette d\u00e9finition de XML for Analysis, adoptons une approche plus pratique de cette norme. Le script XMLA ci-dessous utilise le mot-cl\u00e9 CREATE pour cr\u00e9er un exemple de mod\u00e8le tabulaire lisant les donn\u00e9es d&rsquo;une table de ventes, appel\u00e9e <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>Un simple exemple de mod\u00e8le tabulaire 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;!-- AjusteR ici la cha\u00eene de connexion \u00e0 votre base de donn\u00e9es SQL -->\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;!-- S\u00e9lectionneR ici le type de traitement (Process) du Mod\u00e8le Tabulaire -->\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>Les principales \u00e9tapes utilis\u00e9es dans la d\u00e9finition du mod\u00e8le tabulaire, \u00e9crites en XML for Analysis, pour la cr\u00e9ation de la base de donn\u00e9es sont les suivantes :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Cr\u00e9er la base de donn\u00e9es SSAS<\/strong> : Le script XML for Analysis commence par un \u00e9l\u00e9ment <strong>Batch<\/strong>, pour indiquer une collection de commandes XMLA. La commande <strong>Create<\/strong> est utilis\u00e9e pour initier la cr\u00e9ation de la nouvelle base de donn\u00e9es nomm\u00e9e <em>Tabular_Model_Sales<\/em>.<\/li>\n\n\n\n<li><strong>D\u00e9finir la base de donn\u00e9es<\/strong> : Dans <strong>ObjectDefinition<\/strong>, les d\u00e9tails de la base de donn\u00e9es sont sp\u00e9cifi\u00e9s, incluant son <strong>ID<\/strong>, <strong>Nom<\/strong>, et <strong>CompatibilityLevel<\/strong>. Cette section assure son fonctionnement fluide dans l&rsquo;environnement Analysis Services, y compris la version SQL Server.<\/li>\n\n\n\n<li><strong>Configurer la source de donn\u00e9es<\/strong> : La section <strong>DataSources<\/strong> d\u00e9finit la source de donn\u00e9es pour la base de donn\u00e9es, en sp\u00e9cifiant un \u00e9l\u00e9ment <strong>DataSource<\/strong> avec un attribut de type indiquant qu&rsquo;il s&rsquo;agit d&rsquo;une base de donn\u00e9es relationnelle. La <strong>ConnectionString<\/strong> est fournie pour se connecter \u00e0 la source de donn\u00e9es sous-jacente o\u00f9 r\u00e9sident les donn\u00e9es r\u00e9elles.<\/li>\n\n\n\n<li><strong>Cr\u00e9er le mod\u00e8le<\/strong> : Dans la section <strong>Model<\/strong>, les <strong>Tables<\/strong> sont d\u00e9finies. Une seule table nomm\u00e9e <em>SalesData<\/em> est cr\u00e9\u00e9e avec un type de source <strong>QueryBinding<\/strong>, qui inclut une requ\u00eate SQL pour s\u00e9lectionner des donn\u00e9es de la base de donn\u00e9es source.<\/li>\n\n\n\n<li><strong>D\u00e9finir les colonnes<\/strong> : \u00c0 l&rsquo;int\u00e9rieur de l&rsquo;\u00e9l\u00e9ment <strong>Table<\/strong>, les <strong>Colonnes<\/strong> sont d\u00e9finies, sp\u00e9cifiant l&rsquo;<strong>ID<\/strong>, le <strong>Nom<\/strong>, le <strong>Type de donn\u00e9es<\/strong>, et la <strong>SourceColumn<\/strong> pour chaque colonne de la table. Cela mappe les colonnes de la requ\u00eate source aux colonnes dans le mod\u00e8le tabulaire.<\/li>\n\n\n\n<li><strong>Traiter la base de donn\u00e9es<\/strong> : Enfin, une commande <strong>Process<\/strong> est incluse \u00e0 la fin du script XML for Analysis pour la d\u00e9finition du processus de la base de donn\u00e9es, ici l&rsquo;option est <em>Full<\/em>. Cette \u00e9tape charge les donn\u00e9es dans le mod\u00e8le en utilisant la technologie In-Memory, rendant les donn\u00e9es disponibles pour l&rsquo;analyse aux utilisateurs finaux. Les utilisateurs peuvent se connecter au mod\u00e8le tabulaire en utilisant des tableaux crois\u00e9s dynamiques Excel, Power BI ou Reporting Services.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-2-exemple-de-commande-execute-xmla\">3.2 Exemple de commande Execute XMLA<\/h3>\n\n\n\n<p>La commande <code>Execute<\/code> dans XMLA est utilis\u00e9e pour effectuer des op\u00e9rations telles que l&rsquo;ex\u00e9cution de requ\u00eates MDX ou de pr\u00e9dictions de Data Mining (DMX) contre une source de donn\u00e9es analytique. Voici un exemple d&rsquo;une commande <code>Execute<\/code> XMLA qui ex\u00e9cute une requ\u00eate 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-la-commande-discover-xmla\">3.3 La commande Discover XMLA<\/h3>\n\n\n\n<p>La commande Discover est utilis\u00e9e pour demander des informations de m\u00e9tadonn\u00e9es sur les sources de donn\u00e9es disponibles sur le serveur. Cela pourrait inclure une liste de bases de donn\u00e9es, de cubes, de dimensions, de mesures, etc. Voici un exemple basique d&rsquo;une commande 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\"><span class=\"ez-toc-section\" id=\"4-points-de-terminaison-xmla-pour-power-bi\"><\/span>4. Points de terminaison XMLA pour Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La connectivit\u00e9 de Power BI avec <a href=\"https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview\/\" target=\"_blank\" rel=\"noreferrer noopener\">points de terminaison XMLA<\/a> annonc\u00e9e il y a quelques ann\u00e9es permet d&rsquo;acc\u00e9der aux jeux de donn\u00e9es Power BI via le protocole XMLA. Cela rend toutes les sources de donn\u00e9es pr\u00eates pour XMLA accessibles via une grande vari\u00e9t\u00e9 d&rsquo;outils, comme par exemple :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL Server Reporting Services (SSRS)<\/li>\n\n\n\n<li>Rapports dans 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\/\">Tableaux crois\u00e9s dynamiques Excel<\/a><\/li>\n\n\n\n<li>Outils de visualisation de donn\u00e9es tiers comme <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-a-propos-du-protocole-xml-for-analysis\">\u00c0 propos du protocole XML for Analysis<\/h3>\n\n\n\n<p>En conclusion, la d\u00e9finition de XML for Analysis (XMLA) souligne qu&rsquo;il s&rsquo;agit d&rsquo;un protocole crucial qui permet une communication efficace entre les applications clientes et Microsoft Analysis Services, y compris les cubes OLAP et les mod\u00e8les Tabulaires. Utilisant le Extensible Markup Language (XML), XMLA assure un acc\u00e8s standardis\u00e9 aux sources de donn\u00e9es multidimensionnelles.<\/p>\n\n\n\n<p>Cet article explore non seulement les concepts fondamentaux et les utilisations pratiques de XMLA, mais illustre \u00e9galement son application \u00e0 travers un script pour d\u00e9ployer un mod\u00e8le tabulaire.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"QfGCioSYfk\"><a href=\"https:\/\/expert-only.com\/fr\/power-bi\/valeur-annee-dernier-avec-power-bi\/\">Calculer la valeur de l&rsquo;ann\u00e9e derni\u00e8re avec Power BI et DAX<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Calculer la valeur de l&rsquo;ann\u00e9e derni\u00e8re avec Power BI et DAX\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/power-bi\/valeur-annee-dernier-avec-power-bi\/embed\/#?secret=Y7fKoQ6k4q#?secret=QfGCioSYfk\" data-secret=\"QfGCioSYfk\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Quelle est la d\u00e9finition de XML for Analysis ou (XMLA), langage abr\u00e9g\u00e9 en Extensible Markup Language for Analysis. C&rsquo;est un protocole construit sur le langage XML. Il permet l&rsquo;acc\u00e8s aux donn\u00e9es depuis des sources de donn\u00e9es multidimensionnelles standards. Les <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\" title=\"D\u00e9finition de XML for Analysis (XMLA)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10822,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":{"0":"post-30268","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>D\u00e9finition de XML for Analysis (XMLA) - Concepts IT<\/title>\n<meta name=\"description\" content=\"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes 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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9finition de XML for Analysis (XMLA)\" \/>\n<meta property=\"og:description\" content=\"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes Analysis Services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\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:39:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.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=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"D\u00e9finition de XML for Analysis (XMLA)\",\"datePublished\":\"2024-02-05T06:33:00+00:00\",\"dateModified\":\"2024-03-06T11:39:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\"},\"wordCount\":1248,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg\",\"articleSection\":[\"Concepts IT\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\",\"url\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\",\"name\":\"D\u00e9finition de XML for Analysis (XMLA) - Concepts IT\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-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-03-06T11:39:33+00:00\",\"description\":\"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes Analysis Services.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/definition-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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9finition de XML for Analysis (XMLA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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":"D\u00e9finition de XML for Analysis (XMLA) - Concepts IT","description":"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes 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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9finition de XML for Analysis (XMLA)","og_description":"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes Analysis Services.","og_url":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-05T06:33:00+00:00","article_modified_time":"2024-03-06T11:39:33+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"D\u00e9finition de XML for Analysis (XMLA)","datePublished":"2024-02-05T06:33:00+00:00","dateModified":"2024-03-06T11:39:33+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/"},"wordCount":1248,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-5570360_1920x1080.jpg","articleSection":["Concepts IT"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/","url":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/","name":"D\u00e9finition de XML for Analysis (XMLA) - Concepts IT","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-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-03-06T11:39:33+00:00","description":"Quelle est la d\u00e9finition de XML for Analysis ou XMLA ? Standard Microsoft bas\u00e9 sur XML pour la connectivit\u00e9 aux cubes Analysis Services.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/concepts\/definition-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\/fr\/concepts\/definition-de-xml-for-analysis-xmla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9finition de XML for Analysis (XMLA)"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/wp-json\/wp\/v2\/posts\/30268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=30268"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30268\/revisions"}],"predecessor-version":[{"id":30272,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30268\/revisions\/30272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10822"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=30268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=30268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=30268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}