Cube
Excel 2007
◉ 8 views
=CUBEMEMBER()
Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel for iPadExcel Web AppExcel for iPhoneExcel for Android tabletsExcel for Android phones
=CUBEMEMBER(connection, member_expression, [caption])
Hover argument names in the table for details.
Output typeMixed
Popularity30 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =CUBEMEMBER() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
connection |
Text | Required | A text string of the name of the connection to the cube. |
member_expression |
Text | Required | A text string of a multidimensional expression (MDX) that evaluates to a unique member in the cube. Alternatively, member_expression can be a tuple, specified as a cell range or an array constant. |
caption |
Text | Optional | A text string displayed in the cell instead of the caption, if one is defined, from the cube. When a tuple is returned, the caption used is the one for the last member in the tuple. |
▣ Examples
مثال عضو سال مالی ۲۰۰۴
=CUBEMEMBER("Sales","[Time].[Fiscal].[2004]")
مثال با مرجع سلول
=CUBEMEMBER($A$1,D$12)
مثال تاپل با عنوان سفارشی
=CUBEMEMBER("Sales",(B4, C6, D5),"SalesFor2004")
مثال تاپل محصول و زمان
=CUBEMEMBER("xlextdat8 FoodMart 2000 Sales","([Product].[Food],[Time].[1997])")
مثال با محدوده سلولی
=CUBEMEMBER($A$1,C$12:D$12)
✦ Tips
- When the CUBEMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.
- When you use CUBEMEMBER as an argument to another CUBE function, the MDX expression that identifies the member or tuple is used by that CUBE function, not the displayed value in the cell of the CUBEMEMBER function.
⚠ Common Errors
#NAME?
If the connection name is not a valid workbook connection stored in the workbook, CUBEMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEMEMBER returns a #NAME? error value.
Fix: Check the connection name in the Connections section
#VALUE!
If at least one element within the tuple is invalid, CUBEMEMBER returns a #VALUE! error value. If member_expression is longer than 255 characters, which is the limit for an argument to a function, CUBEMEMBER returns a #VALUE! error value.
Fix: اعضای تاپل را بررسی کنید و برای رشتههای طولانی از مرجع سلول استفاده کنید.
#N/A
CUBEMEMBER returns a #N/A error value when: The member_expression syntax is incorrect. CUBEMEMBER may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection, and that PivotTable is deleted or you convert the PivotTable to formulas. (On the Options tab, in the Tools group, click OLAP Tools, and then click Convert to Formulas.)
Fix: نحو MDX، وجود عضو در کیوب و سازگاری ابعاد اعضای مجموعه را بررسی کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!