CUBEMEMBERPROPERTY Function in Excel: Syntax, Examples and Free Practice
CUBEMEMBERPROPERTY is an Excel Cube function. Returns a property value of a cube member.
CUBEMEMBERPROPERTY syntax
Arguments
connection: The name of the data connection to the cubemember_expression: A text expression identifying a member in the cubeproperty: Which property to return
When to use CUBEMEMBERPROPERTY
Used only when a workbook is connected to an external OLAP data cube (e.g. via SQL Server Analysis Services) — not relevant for typical spreadsheet work.
Practice CUBEMEMBERPROPERTY online, free
Open the live Excel-style spreadsheet and try CUBEMEMBERPROPERTY yourself. No Excel install or sign-up needed to start.
Practice CUBEMEMBERPROPERTY now →More Cube functions
Frequently asked questions
What does the CUBEMEMBERPROPERTY function do in Excel?
Returns a property value of a cube member.
What is the syntax of CUBEMEMBERPROPERTY in Excel?
The syntax is =CUBEMEMBERPROPERTY(connection, member_expression, property). connection: The name of the data connection to the cube; member_expression: A text expression identifying a member in the cube; property: Which property to return.
Where can I practice CUBEMEMBERPROPERTY online for free?
Open the free live spreadsheet on Cellgrids and try CUBEMEMBERPROPERTY yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Cube functions · Excel case studies · Excel tutorials · Excel shortcuts