{"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

Pr\u00e9sentation du langage MDX ou Multidimensional Expressions.<\/em><\/strong><\/h4>\n\n\n\n

Il est appel\u00e9 MDX ou Multidimensional Expressions, ou encore Expressions Multidimensionnelles en Fran\u00e7ais. C’est un langage de programmation de base de donn\u00e9es permettant d’interroger et de cr\u00e9er des calculs et des mesures dans les cubes Microsoft. C’est \u00e0 dire les bases multidimensionnelles.<\/p>\n\n\n\n

En effet, c’est un langage utilis\u00e9 par les bases de donn\u00e9es d\u00e9di\u00e9es \u00e0 l’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

D\u00e9finition du langage MDX ou MultiDimensional Expressions <\/h2>\n\n\n\n

En effet, ce langage est l’\u00e9quivalent de SQL mais pour les cubes au lieu des bases de donn\u00e9es. Les applications de Business Intelligence l’utilisent largement pour permettre aux utilisateurs finaux d’analyser les donn\u00e9es financi\u00e8res ou de production d’une entreprise donn\u00e9e.<\/p>\n\n\n\n

Les requ\u00eates MDX<\/h2>\n\n\n\n

Les requ\u00eates MDX<\/a> sont donc des outils indispensables sur les projets SSAS complexes. Pour obtenir plus d’informations sur ce langage, consultez l’article de Wikip\u00e9dia sur MDX<\/a>.<\/p>\n\n\n\n

Pour conclure, concernant les mod\u00e8les ou cubes tabulaires SSAS<\/strong>, de l’Anglais Tabular Model<\/strong>. Mais aussi les outils d’analyse plus r\u00e9cents de Microsoft comme Power BI<\/strong> par exemple, le langage \u00e9quivalent est DAX pour Data Analysis Expressions<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Pr\u00e9sentation du langage MDX ou Multidimensional Expressions. Il est appel\u00e9 MDX ou Multidimensional Expressions, ou encore Expressions Multidimensionnelles en Fran\u00e7ais. C’est un langage de programmation de base de donn\u00e9es permettant d’interroger et de cr\u00e9er des calculs et des mesures …<\/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"},"yoast_head":"\nMDX ou Multidimensional Expressions - Concepts<\/title>\n<meta name=\"description\" content=\"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.\" \/>\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\/mdx-multidimensional-expressions\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MDX ou Multidimensional Expressions\" \/>\n<meta property=\"og:description\" content=\"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\" \/>\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=\"2022-03-22T05:35:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T14:27:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_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=\"2 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\/mdx-multidimensional-expressions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"MDX ou Multidimensional Expressions\",\"datePublished\":\"2022-03-22T05:35:00+00:00\",\"dateModified\":\"2022-12-01T14:27:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\"},\"wordCount\":249,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"articleSection\":[\"Concepts IT\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\",\"url\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\",\"name\":\"MDX ou Multidimensional Expressions - Concepts\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"datePublished\":\"2022-03-22T05:35:00+00:00\",\"dateModified\":\"2022-12-01T14:27:56+00:00\",\"description\":\"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MDX ou Multidimensional Expressions\"}]},{\"@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":"MDX ou Multidimensional Expressions - Concepts","description":"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.","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\/mdx-multidimensional-expressions\/","og_locale":"fr_FR","og_type":"article","og_title":"MDX ou Multidimensional Expressions","og_description":"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.","og_url":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-03-22T05:35:00+00:00","article_modified_time":"2022-12-01T14:27:56+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"MDX ou Multidimensional Expressions","datePublished":"2022-03-22T05:35:00+00:00","dateModified":"2022-12-01T14:27:56+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/"},"wordCount":249,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","articleSection":["Concepts IT"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/","url":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/","name":"MDX ou Multidimensional Expressions - Concepts","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","datePublished":"2022-03-22T05:35:00+00:00","dateModified":"2022-12-01T14:27:56+00:00","description":"D\u00e9finition du langage MDX ou Multidimensional Expressions qui est un langage pour interroger et g\u00e9rer les cubes multidimensionnels SSAS.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/concepts\/mdx-multidimensional-expressions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"MDX ou Multidimensional Expressions"}]},{"@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\/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}]}}