{"id":119,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/cubekpimember\/"},"modified":"2021-02-13T11:33:24","modified_gmt":"2021-02-13T11:33:24","slug":"cubekpimember","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/cubekpimember\/","title":{"rendered":"CUBEKPIMEMBER"},"content":{"rendered":"

The CUBEKPIMEMBER function in Microsoft Excel and Google Sheets is designed to retrieve the value of a Key Performance Indicator (KPI) for a specified measure in a data cube. Specifically, it fetches the KPI assessment for a chosen measure from an Analysis Services cube.<\/p>\n

How the CUBEKPIMEMBER Function Operates<\/h2>\n

The syntax for the CUBEKPIMEMBER function is:<\/p>\n

CUBEKPIMEMBER(connection, kpi_name[, KPI_property][, caption_flag])<\/code><\/pre>\n
    \n
  • connection:<\/strong> A text string that identifies the OLAP cube, which can be located either in the current workbook or on a server.<\/li>\n
  • kpi_name:<\/strong> A text string that names the Key Performance Indicator.<\/li>\n
  • KPI_property (optional):<\/strong> An integer specifying which property to retrieve. By default, it returns the KPI’s current value. Typical properties include 0 for the current value, 1 for the goal, 2 for the status, 3 for the trend, and 4 for the weight.<\/li>\n
  • caption_flag (optional):<\/strong> A boolean value determining whether the caption of the KPI is returned.<\/li>\n<\/ul>\n
    Examples of Using the CUBEKPIMEMBER Function<\/h2>\n
    For instance, consider an OLAP cube with a KPI named “Revenue” from which we wish to extract the current value and the goal:<\/p>\n\n\n\n\n
    Formula<\/th>\nDescription<\/th>\n<\/tr>\n
    =CUBEKPIMEMBER(\"OLAPCube\",\"Revenue\",0)<\/code><\/td>\nThis formula retrieves the current value of the “Revenue” KPI.<\/td>\n<\/tr>\n
    =CUBEKPIMEMBER(\"OLAPCube\",\"Revenue\",1)<\/code><\/td>\nThis formula fetches the goal value of the “Revenue” KPI.<\/td>\n<\/tr>\n<\/table>\n
    Another example involves obtaining the status and trend of a KPI:<\/p>\n\n\n\n\n
    Formula<\/th>\nDescription<\/th>\n<\/tr>\n
    =CUBEKPIMEMBER(\"OLAPCube\",\"Revenue\",2)<\/code><\/td>\nThis formula retrieves the status of the “Revenue” KPI.<\/td>\n<\/tr>\n
    =CUBEKPIMEMBER(\"OLAPCube\",\"Revenue\",3)<\/code><\/td>\nThis formula fetches the trend of the “Revenue” KPI.<\/td>\n<\/tr>\n<\/table>\n
    By using the CUBEKPIMEMBER function, you can effectively extract and analyze key performance indicator data from OLAP cubes, enhancing your ability to conduct thorough analysis and reporting within your Excel or Google Sheets environments.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization’s performance<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[208],"tags":[],"class_list":["post-119","post","type-post","status-publish","format-standard","hentry","category-cube"],"acf":[],"yoast_head":"\nExcel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.\" \/>\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\/en\/cubekpimember\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/cubekpimember\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:33:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\/en\/cubekpimember\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/cubekpimember\/\",\"name\":\"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:33:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/cubekpimember\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/cubekpimember\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/cubekpimember\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cube\",\"item\":\"https:\/\/functiontranslator.com\/en\/cube\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUBEKPIMEMBER\"}]},{\"@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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.","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\/en\/cubekpimember\/","og_locale":"en_US","og_type":"article","og_title":"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/cubekpimember\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:33:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/cubekpimember\/","url":"https:\/\/functiontranslator.com\/en\/cubekpimember\/","name":"Excel CUBEKPIMEMBER Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:33:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel CUBEKPIMEMBER function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/cubekpimember\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/cubekpimember\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/cubekpimember\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Cube","item":"https:\/\/functiontranslator.com\/en\/cube\/"},{"@type":"ListItem","position":3,"name":"CUBEKPIMEMBER"}]},{"@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":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=119"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/119\/revisions"}],"predecessor-version":[{"id":3010,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/119\/revisions\/3010"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}