Cube Functions in Excel
Cube Functions in Excel
Excel boasts a vast library of functions, but don’t be overwhelmed! We’ll explore the most essential functions grouped into intuitive categories. Here is the list of Excel Formulas and Functions. We have included Excel functions, Description, Syntax. Explained with Example Formulas.
Cube Functions
Unlock the Secrets of Multidimensional Data Analysis with Cube Functions, specifically designed for PivotTables. Explore data relationships, interact with different dimensions, and create dynamic reports to gain deeper insights from your complex datasets. (Note: Requires knowledge of PivotTables)
- Specifically designed for PivotTables.
- Explore data relationships and interact with different dimensions.
- Create dynamic reports for deeper insights from complex datasets.
Function | Description | Syntax and Formula |
CUBEKPIMEMBER | CUBEKPIMEMBER is an Excel function that returns a key performance indicator (KPI) value from an OLAP cube. | Syntax: CUBEKPIMEMBER(cube_name, kpi_name) Formula: CUBEKPIMEMBER(“Sales Cube”, “Sales”) returns the sales KPI value from the Sales Cube. |
CUBEMEMBER | The CUBEMEMBER function returns information about a member or tuple within a cube. | Syntax: CUBEMEMBER(cube_name, member_name) Formula: CUBEMEMBER(“Sales Cube”, “Product[Beverages]”) |
CUBEMEMBERPROPERTY | The CUBEMEMBERPROPERTY function returns a property value for a given cube member. | Syntax: CUBEMEMBERPROPERTY(cube_name, member_name, property_name) Formula: CUBEMEMBERPROPERTY(“Sales Cube”, “[Product].[Product].[Bread]”, “UniqueName”)This example returns the unique name of the cube member “[Product].[Product].[Bread]” from the “Sales Cube” cube. |
CUBERANKEDMEMBER | The CUBERANKEDMEMBER function is a Microsoft Excel function that returns the nth item in a set, based on its rank in the set. | Syntax: CUBERANKEDMEMBER(set, rank [, [ascending | descending]]) Formula: To return the third highest value in the set {1,2,3,4,5}, the following formula can be used: CUBERANKEDMEMBER({1,2,3,4,5}, 3, descending)The result of the formula is 3. |
CUBESET | The CUBESET function is used to create a set of members or tuples from a cube. | Syntax: CUBESET(cube_name, set_expression, [name]) Formula: CUBESET(“Sales Cube”, “[Measures].[Quantity] > 1000”, “High Quantity Sales”) |
CUBESETCOUNT | The CUBESETCOUNT function in Excel returns the number of sets in a cube. | Syntax: CUBESETCOUNT(cube_name) Formula: CUBESETCOUNT(“Sales Cube”)This example would return the number of sets in the cube named “Sales Cube”. |
CUBEVALUE | The CUBEVALUE function is a Microsoft Excel function that returns a value from an OLAP cube. | Syntax: CUBEVALUE(connection, cube_ref, field1, field2, …) Formula: CUBEVALUE(“OLAP”, “[Sales].[Product].[Product]”, “Revenue”) |
You May Like to Browers More
