Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Category: Cube Functions

Excel Cube functions perform calculations and extract data from a cube, which is stored on an external SQL server.

CUBESET function: Description, Usage, Syntax, Examples and Explanation

What is CUBESET function in Excel? CUBESET function is one of Cube functions that defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel. Syntax of CUBESET function CUBESET(connection, set_expression, , [sort_order], [sort_by]) The CUBESET function syntax has the following arguments: Connection: A…

CUBESETCOUNT function: Description, Usage, Syntax, Examples and Explanation

 What is CUBESETCOUNT function in Excel? CUBESETCOUNT function is one of Cube functions in Microsoft Excel which returns the number of items in a set. Syntax of CUBESETCOUNT function CUBESETCOUNT(set) The CUBESETCOUNT function syntax has the following argument: Set: A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function. Set can also be the CUBESET…

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

What is CUBEVALUE function in Excel? CUBEVALUE function is one of Cube functions in Microsoft Excel which returns an aggregated value from the cube. Syntax of CUBEVALUE function CUBEVALUE(connection, [member_expression1], [member_expression2], …) The CUBEVALUE function syntax has the following arguments: Connection: A text string of the name of the connection to the cube. Member_expression(Optional): A text string of a multidimensional expression (MDX) that evaluates to…

CUBEMEMBERPROPERTY function: Description, Usage, Syntax, Examples and Explanation

What is CUBEMEMBERPROPERTY function in Excel? CUBEMEMBERPROPERTY function is one of the Cube functions in Excel which returns the value of a member property from a cube. Usage of CUBEMEMBERPROPERTY function CUBEMEMBERPROPERTY function is used to validate that a member name exists within the cube, and to return the specified property for this member. Syntax of CUBEMEMBERPROPERTY function CUBEMEMBERPROPERTY(connection, member_expression, property) The CUBEMEMBERPROPERTY function syntax has the following arguments: Connection: A…

CUBERANKEDMEMBER function: Description, Usage, Syntax, Examples and Explanation

What is CUBERANKEDMEMBER function in Excel? The CUBERANKEDMEMBER function is one of the Cube functions in Microsoft Excel which returns the nth, or ranked, member in a set.  It is used to return one or more elements in a set, such as the top sales performer or the top 10 students. Syntax of CUBERANKEDMEMBER function CUBERANKEDMEMBER(connection, set_expression, rank, ) The CUBERANKEDMEMBER function syntax has the following arguments: Connection:…

CUBEMEMBER function: Description, Usage, Syntax, Examples and Explanation

 What is CUBEMEMBER  function in Excel? CUBEMEMBER  function  is one of the Cube functions in Microsoft Excel which returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube. Syntax of CUBEMEMBER  function CUBEMEMBER(connection, member_expression, ) The CUBEMEMBER function syntax has the following arguments: Connection: A text string of the name of the connection to the cube. Member_expression:…

CUBEKPIMEMBER function: Description, Usage, Syntax, Examples and Explanation

 What is CUBEKPIMEMBER function in Excel? CUBEKPIMEMBER function is one of the Cube functions in Microsoft Excel which returns a key performance indicator (KPI) property and displays the KPI name in the cell.  A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization’s performance. Note: The CUBEKPIMEMBER function is supported only when the…

Complete List of Excel Cube Functions References and Examples

Excel Cube functions were introduced in Microsoft Excel 2007. The Cube functions  perform calculations and extract data from a cube, which is stored on an external SQL server. These functions are only supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source. Data cubes are multidimensional sets of data that can be stored in a…