CUBESET Function in Excel: Syntax, Examples and Free Practice
CUBESET is an Excel Cube function. Defines a set of members from a data cube.
CUBESET syntax
Arguments
connection: The name of the data connection to the cubeset_expression: A text expression defining a set of cube memberscaption: The display text to use instead of the raw name (optional)sort_order: How the set should be sorted (optional)sort_by: Which value to sort the set by (optional)
When to use CUBESET
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 CUBESET online, free
Open the live Excel-style spreadsheet and try CUBESET yourself. No Excel install or sign-up needed to start.
Practice CUBESET now →More Cube functions
Frequently asked questions
What does the CUBESET function do in Excel?
Defines a set of members from a data cube.
What is the syntax of CUBESET in Excel?
The syntax is =CUBESET(connection, set_expression, [caption], [sort_order], [sort_by]). connection: The name of the data connection to the cube; set_expression: A text expression defining a set of cube members; caption: The display text to use instead of the raw name (optional); sort_order: How the set should be sorted (optional); sort_by: Which value to sort the set by (optional).
Where can I practice CUBESET online for free?
Open the free live spreadsheet on Cellgrids and try CUBESET 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