{"id":6475,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/membrekpicube\/"},"modified":"2021-02-26T08:04:00","modified_gmt":"2021-02-26T08:04:00","slug":"cubekpimember","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/","title":{"rendered":"MEMBREKPICUBE"},"content":{"rendered":"<h2>Description de la Fonction<\/h2>\n<p>La fonction <strong>CUBEKPIMEMBER<\/strong> de Microsoft Excel est con\u00e7ue pour extraire un membre de KPI (Indicateur Cl\u00e9 de Performance) \u00e0 partir d&rsquo;une source de donn\u00e9es OLAP (Traitement Analytique en Ligne). Cette fonction est essentielle pour les rapports d&rsquo;Intelligence d&rsquo;Affaires (BI), permettant d&rsquo;analyser en profondeur les performances cl\u00e9s au sein des cubes OLAP.<\/p>\n<h2>Syntaxe de la fonction<\/h2>\n<p>Voici la syntaxe de la fonction <code>CUBEKPIMEMBER<\/code>:<\/p>\n<pre><code>CUBEKPIMEMBER(connection, nom_cube_kpi, type_membre_kpi, )<\/code><\/pre>\n<ul>\n<li><strong>connection<\/strong> : Une cha\u00eene de caract\u00e8res repr\u00e9sentant le nom de la connexion au cube OLAP.<\/li>\n<li><strong>nom_cube_kpi<\/strong> : Une cha\u00eene indiquant le nom du KPI dont vous souhaitez r\u00e9cup\u00e9rer le membre.<\/li>\n<li><strong>type_membre_kpi<\/strong> : Une cha\u00eene sp\u00e9cifiant le type de membre KPI \u00e0 obtenir (par exemple, \u00ab\u00a0Valeur\u00a0\u00bb, \u00ab\u00a0Cible\u00a0\u00bb, \u00ab\u00a0Statut\u00a0\u00bb ou \u00ab\u00a0Tendance\u00a0\u00bb).<\/li>\n<li><strong>caption<\/strong> (optionnel) : Une cha\u00eene permettant de sp\u00e9cifier un libell\u00e9 personnalis\u00e9 pour le membre renvoy\u00e9.<\/li>\n<\/ul>\n<h2>Exemples d&rsquo;utilisation<\/h2>\n<p>Exemple simple de la fonction <code>CUBEKPIMEMBER<\/code> :<\/p>\n<pre><code>=CUBEKPIMEMBER(\"ThisWorkbookDataModel\", \"[KPIs].[Chiffre d'affaires]\", \"Valeur\")<\/code><\/pre>\n<p>Cette formule renvoie la valeur actuelle du KPI \u00ab\u00a0Chiffre d&rsquo;affaires\u00a0\u00bb du mod\u00e8le de donn\u00e9es du classeur actuel.<\/p>\n<h2>Application pratique : analyse des performances de vente<\/h2>\n<p>Pour analyser les performances de vente de votre entreprise, vous pouvez examiner plusieurs aspects d&rsquo;un KPI nomm\u00e9 \u00ab\u00a0Ventes Totales\u00a0\u00bb.<\/p>\n<table>\n<tr>\n<th>Type de Membre KPI<\/th>\n<th>Formule Excel<\/th>\n<\/tr>\n<tr>\n<td>Valeur Actuelle<\/td>\n<td><code>=CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[Ventes Totales]\", \"Valeur\")<\/code><\/td>\n<\/tr>\n<tr>\n<td>Cible<\/td>\n<td><code>=CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[Ventes Totales]\", \"Cible\")<\/code><\/td>\n<\/tr>\n<tr>\n<td>Statut<\/td>\n<td><code>=CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[Ventes Totales]\", \"Statut\")<\/code><\/td>\n<\/tr>\n<tr>\n<td>Tendance<\/td>\n<td><code>=CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[Ventes Totales]\", \"Tendance\")<\/code><\/td>\n<\/tr>\n<\/table>\n<h2>Sc\u00e9nario de budget et pr\u00e9visions<\/h2>\n<p>Dans le cadre de la pr\u00e9paration budg\u00e9taire pour l&rsquo;ann\u00e9e suivante, utilisez les KPI de l&rsquo;ann\u00e9e en cours pour mesurer les performances comparativement aux objectifs fix\u00e9s.<\/p>\n<pre><code>=CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[D\u00e9penses Op\u00e9rationnelles]\", \"Valeur\") =CUBEKPIMEMBER(\"DataConnection\", \"[KPIs].[D\u00e9penses Op\u00e9rationnelles]\", \"Cible\")<\/code><\/pre>\n<p>Ces formules fournissent un aper\u00e7u direct des d\u00e9penses op\u00e9rationnelles actuelles par rapport aux objectifs, facilitant ainsi les discussions et les d\u00e9cisions budg\u00e9taires.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie un nom, une pRopRi\u00e9t\u00e9 et une mesuRe d\u2019indicateuR de peRfoRmance cl\u00e9 et affiche le nom et la pRopRi\u00e9t\u00e9 dans la cellule Un indicateuR de peRfoRmance cl\u00e9 est une mesuRe quantifiable, telle que la maRge b\u00e9n\u00e9ficiaiRe bRute mensuelle ou la Rotation tRimestRielle du peRsonnel, utilis\u00e9e pouR \u00e9valueR les peRfoRmances d\u2019une entRepRise<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[],"class_list":["post-6475","post","type-post","status-publish","format-standard","hentry","category-cube-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:04:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/\",\"name\":\"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:04:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubekpimember\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cube\",\"item\":\"https:\/\/functiontranslator.com\/fr\/cube-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MEMBREKPICUBE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/cubekpimember\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/","url":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/","name":"Fonction CUBEKPIMEMBER (MEMBREKPICUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:04:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CUBEKPIMEMBER (MEMBREKPICUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/cubekpimember\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/cubekpimember\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cube","item":"https:\/\/functiontranslator.com\/fr\/cube-2\/"},{"@type":"ListItem","position":3,"name":"MEMBREKPICUBE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6475"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6475\/revisions"}],"predecessor-version":[{"id":29487,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6475\/revisions\/29487"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}