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

Description de la Fonction<\/h2>\n

La fonction VALEURCUBE<\/code> dans MS Excel et Google Sheets est une fonction avanc\u00e9e con\u00e7ue pour l’analyse et l’agr\u00e9gation de donn\u00e9es dans les environnements de business intelligence. Utilis\u00e9e avec des cubes OLAP (Online Analytical Processing), elle permet de r\u00e9cup\u00e9rer des valeurs agr\u00e9g\u00e9es bas\u00e9es sur diff\u00e9rentes dimensions d’une source de donn\u00e9es.<\/p>\n

Syntaxe:<\/strong><\/p>\n

VALEURCUBE(connexion, [membre_expression1], [membre_expression2], ...)<\/code><\/pre>\n
    \n
  • connexion<\/strong> : Cha\u00eene de caract\u00e8res repr\u00e9sentant une connexion valide \u00e0 un cube OLAP.<\/li>\n
  • membre_expression<\/strong> : Expressions d\u00e9signant les membres ou \u00e9l\u00e9ments sp\u00e9cifiques dans le cube. Au moins une expression doit \u00eatre sp\u00e9cifi\u00e9e pour obtenir un r\u00e9sultat.<\/li>\n<\/ul>\n
    Exemples d’Utilisation<\/h2>\n
    Consid\u00e9rons un cube OLAP contenant des donn\u00e9es de ventes sur plusieurs ann\u00e9es.<\/p>\n\n\n\n\n
    Expression<\/th>\nDescription<\/th>\n<\/tr>\n
    VALEURCUBE(\"ConnexionCube\", \"[Ventes].[Total des Ventes]\")<\/code><\/td>\nCette formule calcule le total des ventes \u00e0 travers toutes les r\u00e9gions et tous les produits.<\/td>\n<\/tr>\n
    VALEURCUBE(\"ConnexionCube\", \"[Ventes].[Par R\u00e9gion].[Europe]\")<\/code><\/td>\nCalcule les ventes totales pour la r\u00e9gion Europe uniquement.<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9nario Pratique 1: Analyse des Ventes Annuelles<\/h2>\n
    Probl\u00e8me:<\/strong> Vous souhaitez conna\u00eetre le total des ventes par ann\u00e9e.<\/p>\n
    Solution:<\/strong> Utilisez la fonction VALEURCUBE<\/code> pour agr\u00e9ger les donn\u00e9es de ventes annuelles ainsi :<\/p>\n
     =VALEURCUBE(\"ConnexionCube\", \"[Temps].[Ann\u00e9e].[2023]\")<\/code> <\/pre>\n
    Cette formule vous affiche les ventes pour l’ann\u00e9e 2023. Modifiez 2023<\/code> avec une autre ann\u00e9e pour examiner d’autres p\u00e9riodes.<\/p>\n
    Sc\u00e9nario Pratique 2: Comparaison des Ventes par Cat\u00e9gorie de Produits<\/h2>\n
    Probl\u00e8me:<\/strong> Vous voulez comparer les ventes entre diff\u00e9rentes cat\u00e9gories de produits pour l’ann\u00e9e en cours.<\/p>\n
    Solution:<\/strong> Exploitez la fonction VALEURCUBE<\/code> pour r\u00e9cup\u00e9rer les ventes par cat\u00e9gorie comme suit :<\/p>\n
     =VALEURCUBE(\"ConnexionCube\", \"[Produits].[Cat\u00e9gorie].[\u00c9lectronique]\")<\/code> =VALEURCUBE(\"ConnexionCube\", \"[Produits].[Cat\u00e9gorie].[Livres]\")<\/code> =VALEURCUBE(\"ConnexionCube\", \"[Produits].[Cat\u00e9gorie].[V\u00eatements]\")<\/code> <\/pre>\n
    Ces formules fournissent un aper\u00e7u des ventes pour les cat\u00e9gories d’\u00c9lectronique, de Livres, et de V\u00eatements, facilitant ainsi une analyse comparative d\u00e9taill\u00e9e des performances de vente.<\/p>\n
     This revised version maintains the original content’s integrity while enhancing its professional tone and coherence, and correcting any language-specific issues.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie une valeuR d\u2019agR\u00e9gation issue d\u2019un cube<\/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-6481","post","type-post","status-publish","format-standard","hentry","category-cube-2"],"acf":[],"yoast_head":"\nFonction CUBEVALUE (VALEURCUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) 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\/cubevalue\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CUBEVALUE (VALEURCUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/cubevalue\/\" \/>\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:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CUBEVALUE (VALEURCUBE) 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\/cubevalue\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/cubevalue\/\",\"name\":\"Fonction CUBEVALUE (VALEURCUBE) 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:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubevalue\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/cubevalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cubevalue\/#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\":\"VALEURCUBE\"}]},{\"@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 CUBEVALUE (VALEURCUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) 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\/cubevalue\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CUBEVALUE (VALEURCUBE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/cubevalue\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CUBEVALUE (VALEURCUBE) 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\/cubevalue\/","url":"https:\/\/functiontranslator.com\/fr\/cubevalue\/","name":"Fonction CUBEVALUE (VALEURCUBE) 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:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CUBEVALUE (VALEURCUBE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/cubevalue\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/cubevalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/cubevalue\/#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":"VALEURCUBE"}]},{"@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\/6481","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=6481"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6481\/revisions"}],"predecessor-version":[{"id":29493,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6481\/revisions\/29493"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}