{"id":6477,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/proprietemembrecube\/"},"modified":"2021-02-26T08:04:07","modified_gmt":"2021-02-26T08:04:07","slug":"cubememberproperty","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/","title":{"rendered":"PROPRIETEMEMBRECUBE"},"content":{"rendered":"

Description de la fonction PROPRIETEMEMBRECUBE<\/h2>\n

La fonction PROPRIETEMEMBRECUBE dans Microsoft Excel permet d’extraire une propri\u00e9t\u00e9 sp\u00e9cifique d’un membre au sein d’un cube de donn\u00e9es. Elle est particuli\u00e8rement pertinente pour l’analyse de donn\u00e9es multidimensionnelles et est fr\u00e9quemment utilis\u00e9e dans le domaine de la business intelligence (BI).<\/p>\n

Syntaxe et Exemples<\/h2>\n

Voici la syntaxe de la fonction PROPRIETEMEMBRECUBE :<\/p>\n

PROPRIETEMEMBRECUBE(connexion, membre_expression, propri\u00e9t\u00e9)<\/code><\/pre>\n
D\u00e9tails des param\u00e8tres :<\/p>\n
    \n
  • connexion<\/strong> : une cha\u00eene de caract\u00e8res qui indique le nom de la connexion au cube.<\/li>\n
  • membre_expression<\/strong> : une expression renvoyant un membre ou un tuple dans le cube.<\/li>\n
  • propri\u00e9t\u00e9<\/strong> : le nom de la propri\u00e9t\u00e9 du membre dont la valeur est requise.<\/li>\n<\/ul>\n
    Exemple :<\/strong><\/p>\n
    =PROPRIETEMEMBRECUBE(\"ConnexionCube\", \"[Produits].[123]\", \"Color\")<\/code><\/pre>\n
    Cet exemple retourne la couleur du produit identifi\u00e9 par le num\u00e9ro 123 dans un cube associ\u00e9 \u00e0 la connexion \u00ab\u00a0ConnexionCube\u00a0\u00bb.<\/p>\n
    Applications Pratiques<\/h2>\n
    \u00c9tude de cas 1: Analyse des ventes par cat\u00e9gorie de produit<\/h2>\n
    Imaginez que vous souhaitez analyser les ventes par cat\u00e9gorie de produits o\u00f9 chaque produit poss\u00e8de une propri\u00e9t\u00e9 \u00ab\u00a0Cat\u00e9gorie\u00a0\u00bb. Voici comment r\u00e9cup\u00e9rer cette information pour l’utiliser dans votre analyse :<\/p>\n
    =PROPRIETEMEMBRECUBE(\"MaConnexion\", \"[Produits].[Code du produit]\", \"Cat\u00e9gorie\")<\/code><\/pre>\n
    Cette formule vous permet de segmenter vos donn\u00e9es de vente par cat\u00e9gorie de produit, facilitant l’analyse cibl\u00e9e par segments.<\/p>\n
    \u00c9tude de cas 2: Gestion des stocks et identification des fournisseurs<\/h2>\n
    Pour une gestion efficace des stocks, conna\u00eetre le fournisseur principal de chaque produit est essentiel. La fonction PROPRIETEMEMBRECUBE peut \u00eatre utilis\u00e9e pour obtenir dynamiquement le nom du fournisseur de chaque produit :<\/p>\n
    =PROPRIETEMEMBRECUBE(\"ConnexionStock\", \"[Produits].[RefProduit]\", \"Fournisseur\")<\/code><\/pre>\n
    Cela est extr\u00eamement utile pour automatiser les mises \u00e0 jour des tableaux de bord de gestion des stocks en extrayant les informations directement de la base de donn\u00e9es du cube.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR d\u2019une pRopRi\u00e9t\u00e9 de membRe du cube Utilisez cette fonction pouR valideR l\u2019existence d\u2019un nom de membRe dans le cube et pouR RenvoyeR la pRopRi\u00e9t\u00e9 sp\u00e9cifi\u00e9e pouR ce membRe<\/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-6477","post","type-post","status-publish","format-standard","hentry","category-cube-2"],"acf":[],"yoast_head":"\nFonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'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\/cubememberproperty\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/\" \/>\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:07+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/\",\"name\":\"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) 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:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/#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\":\"PROPRIETEMEMBRECUBE\"}]},{\"@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 CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) 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\/cubememberproperty\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/","url":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/","name":"Fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) 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:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CUBEMEMBERPROPERTY (PROPRIETEMEMBRECUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/cubememberproperty\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/cubememberproperty\/#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":"PROPRIETEMEMBRECUBE"}]},{"@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\/6477","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=6477"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6477\/revisions"}],"predecessor-version":[{"id":29489,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6477\/revisions\/29489"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}