{"id":121,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/cubememberproperty\/"},"modified":"2021-02-13T11:33:27","modified_gmt":"2021-02-13T11:33:27","slug":"cubememberproperty","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/","title":{"rendered":"CUBEMEMBERPROPERTY"},"content":{"rendered":"<p>Welcome to the guide on using the CUBEMEMBERPROPERTY function in Microsoft Excel and Google Sheets. This function is essential for retrieving properties of specific members within Online Analytical Processing (OLAP) cubes. Through this guide, you will learn how to use the CUBEMEMBERPROPERTY function, explore typical use cases, and understand how to effectively employ this function in practical situations.<\/p>\n<h2>Overview<\/h2>\n<p>The CUBEMEMBERPROPERTY function extracts properties from a cube member or tuple. It requires the following arguments:<\/p>\n<ul>\n<li><strong>Member_expression:<\/strong> Identifies the cube member or tuple whose property you want to extract.<\/li>\n<li><strong>Property:<\/strong> Specifies the property of the member to retrieve, such as MEMBER_CAPTION, MEMBER_KEY, MEMBER_NAME, etc.<\/li>\n<li><strong>Cube_name:<\/strong> The name of the cube within the cube database. This argument is optional in certain contexts.<\/li>\n<\/ul>\n<h2>Examples<\/h2>\n<p>Below are examples demonstrating different use cases for the CUBEMEMBERPROPERTY function.<\/p>\n<h3>Example 1: Retrieve the Member Name<\/h3>\n<p>This example shows how to obtain the name of a specific member within a cube. Here\u2019s the function syntax:<\/p>\n<pre><code>=CUBEMEMBERPROPERTY(Member_expression, \"MEMBER_NAME\")<\/code><\/pre>\n<p>To apply this in a practical scenario:<\/p>\n<table>\n<tr>\n<th>Member<\/th>\n<th>Name<\/th>\n<\/tr>\n<tr>\n<td>[Product].[Category].&#038;[1]<\/td>\n<td>=CUBEMEMBERPROPERTY(&#8220;[Product].[Category].&#038;[1]&#8221;, &#8220;MEMBER_NAME&#8221;)<\/td>\n<\/tr>\n<\/table>\n<h3>Example 2: Retrieve the Member Caption<\/h3>\n<p>In this example, the goal is to retrieve the caption for a particular member in a cube. Use the following syntax:<\/p>\n<pre><code>=CUBEMEMBERPROPERTY(Member_expression, \"MEMBER_CAPTION\")<\/code><\/pre>\n<p>Here is how you might use this:<\/p>\n<table>\n<tr>\n<th>Member<\/th>\n<th>Caption<\/th>\n<\/tr>\n<tr>\n<td>[Date].[2019].[Q1]<\/td>\n<td>=CUBEMEMBERPROPERTY(&#8220;[Date].[2019].[Q1]&#8221;, &#8220;MEMBER_CAPTION&#8221;)<\/td>\n<\/tr>\n<\/table>\n<h2>Implementation<\/h2>\n<p>To implement the CUBEMEMBERPROPERTY function in Excel or Google Sheets, follow these steps:<\/p>\n<ol>\n<li>Select the cell where you want the result to display.<\/li>\n<li>Type in the CUBEMEMBERPROPERTY function with the necessary arguments.<\/li>\n<li>Press Enter to display the property value.<\/li>\n<\/ol>\n<p>Before using the CUBEMEMBERPROPERTY function, ensure your spreadsheet is connected to an OLAP cube data source.<\/p>\n<p>By following these guidelines and examples, you&#8217;ll be able to effectively utilize the CUBEMEMBERPROPERTY function to extract detailed information about cube members in both Excel and Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Returns the value of a member property in the cube Use to validate that a member name exists within the cube and to return the specified property for this member<\/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-121","post","type-post","status-publish","format-standard","hentry","category-cube"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel CUBEMEMBERPROPERTY Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel CUBEMEMBERPROPERTY 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\/cubememberproperty\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel CUBEMEMBERPROPERTY Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel CUBEMEMBERPROPERTY function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/\" \/>\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:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel CUBEMEMBERPROPERTY 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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/\",\"name\":\"Excel CUBEMEMBERPROPERTY 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel CUBEMEMBERPROPERTY function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/cubememberproperty\/#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\":\"CUBEMEMBERPROPERTY\"}]},{\"@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 CUBEMEMBERPROPERTY Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel CUBEMEMBERPROPERTY 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\/cubememberproperty\/","og_locale":"en_US","og_type":"article","og_title":"Excel CUBEMEMBERPROPERTY Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel CUBEMEMBERPROPERTY function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:33:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel CUBEMEMBERPROPERTY Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/","url":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/","name":"Excel CUBEMEMBERPROPERTY 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel CUBEMEMBERPROPERTY function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/cubememberproperty\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/cubememberproperty\/#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":"CUBEMEMBERPROPERTY"}]},{"@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\/121","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=121"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":3012,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/121\/revisions\/3012"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}