{"id":6902,"date":"2022-03-22T06:35:00","date_gmt":"2022-03-22T05:35:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6902"},"modified":"2022-12-01T15:27:56","modified_gmt":"2022-12-01T14:27:56","slug":"mdx-multidimensional-expressions","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/","title":{"rendered":"MDX ou Multidimensional Expressions"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Pr\u00e9sentation du langage MDX ou Multidimensional Expressions.<\/em><\/strong><\/h4>\n\n\n\n<p>Il est appel\u00e9 MDX ou Multidimensional Expressions, ou encore Expressions Multidimensionnelles en Fran\u00e7ais. C&rsquo;est un langage de programmation de base de donn\u00e9es permettant d&rsquo;interroger et de cr\u00e9er des calculs et des mesures dans les cubes Microsoft. C&rsquo;est \u00e0 dire les bases multidimensionnelles.<\/p>\n\n\n\n<p>En effet, c&rsquo;est un langage utilis\u00e9 par les bases de donn\u00e9es d\u00e9di\u00e9es \u00e0 l&rsquo;analyse, appel\u00e9es OLAP. Pour aller plus loin, consid\u00e9rons les deux types de bases de donn\u00e9es Microsoft, les multidimensionnelles et les transactionnelles. Dans cet article, nous traiterons du premier type de base de donn\u00e9es : les bases de donn\u00e9es multidimensionnelles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-definition-du-langage-mdx-ou-multidimensional-expressions\">D\u00e9finition du langage MDX ou MultiDimensional Expressions <\/h2>\n\n\n\n<p>En effet, ce langage est l&rsquo;\u00e9quivalent de SQL mais pour les cubes au lieu des bases de donn\u00e9es. Les applications de Business Intelligence l&rsquo;utilisent largement pour permettre aux utilisateurs finaux d&rsquo;analyser les donn\u00e9es financi\u00e8res ou de production d&rsquo;une entreprise donn\u00e9e.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Les requ\u00eates MDX<\/h2>\n\n\n\n<p>Les <a href=\"https:\/\/expert-only.com\/ssas\/masquer-organiser-indicateurs-ssas\/\">requ\u00eates MDX<\/a> sont donc des outils indispensables sur les projets SSAS complexes. Pour obtenir plus d&rsquo;informations sur ce langage, consultez l&rsquo;article de Wikip\u00e9dia sur <a href=\"https:\/\/en.wikipedia.org\/wiki\/MultiDimensional_eXpressions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX<\/a>.<\/p>\n\n\n\n<p>Pour conclure, concernant les mod\u00e8les ou <strong>cubes tabulaires SSAS<\/strong>, de l&rsquo;Anglais <strong>Tabular Model<\/strong>. Mais aussi les outils d&rsquo;analyse plus r\u00e9cents de Microsoft comme <strong>Power BI<\/strong> par exemple, le langage \u00e9quivalent est <a href=\"https:\/\/expert-only.com\/concepts\/dax-signifie-data-analysis-expressions\/\">DAX pour Data Analysis Expressions<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Pr\u00e9sentation du langage MDX ou Multidimensional Expressions. Il est appel\u00e9 MDX ou Multidimensional Expressions, ou encore Expressions Multidimensionnelles en Fran\u00e7ais. C&rsquo;est un langage de programmation de base de donn\u00e9es permettant d&rsquo;interroger et de cr\u00e9er des calculs et des mesures <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\" title=\"MDX ou Multidimensional Expressions\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10862,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":{"0":"post-6902","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-concepts"},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/6902","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=6902"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/6902\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10862"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=6902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=6902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=6902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}