List of Excel Cube Functions with Syntax and Arguments

This reference table lists all officially documented Cube Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.

#Excel FunctionDescriptionSyntax with ArgumentsSyntax onlyArguments only
1CUBEKPIMEMBERReturns a key performance indicator (KPI) property and displays the KPI name in the cell=CUBEKPIMEMBER(connectionconnection [required]: A text string of the name of the connection to the cube., kpi_namekpi_name [required]: A text string of the name of the KPI in the cube., kpi_propertykpi_property [required]: The KPI component returned and can be one of the following:

, [captioncaption [optional]: An alternative text string that is displayed in the cell instead of kpi_name and kpi_property.])
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
  • connection (required): A text string of the name of the connection to the cube.
  • kpi_name (required): A text string of the name of the KPI in the cube.
  • kpi_property (required): The KPI component returned and can be one of the following:

  • caption (optional): An alternative text string that is displayed in the cell instead of kpi_name and kpi_property.
2CUBEMEMBERReturns a member or tuple from the cube=CUBEMEMBER(connectionconnection [required]: A text string of the name of the connection to the cube., member_expressionmember_expression [required]: A text string of a multidimensional expression (MDX) that evaluates to a unique member in the cube., [captioncaption [optional]: A text string displayed in the cell instead of the caption, if one is defined, from the cube.])=CUBEMEMBER(connection, member_expression, [caption])
  • connection (required): A text string of the name of the connection to the cube.
  • member_expression (required): A text string of a multidimensional expression (MDX) that evaluates to a unique member in the cube.
  • caption (optional): A text string displayed in the cell instead of the caption, if one is defined, from the cube.
3CUBEMEMBERPROPERTY in Excel, returns the value of a member property from a cube=CUBEMEMBERPROPERTY(connectionconnection [required]: A text string of the name of the connection to the cube., member_expressionmember_expression [required]: A text string of a multidimensional expression (MDX) of a member within the cube., propertyproperty [required]: A text string of the name of the property returned or a reference to a cell that contains the name of the property.)=CUBEMEMBERPROPERTY(connection, member_expression, property)
  • connection (required): A text string of the name of the connection to the cube.
  • member_expression (required): A text string of a multidimensional expression (MDX) of a member within the cube.
  • property (required): A text string of the name of the property returned or a reference to a cell that contains the name of the property.
4CUBERANKEDMEMBERReturns the nth, or ranked, member in a set=CUBERANKEDMEMBER(connectionconnection [required]: A text string of the name of the connection to the cube., set_expressionset_expression [required]: A text string of a set expression, such as "{[Item1]., rankrank [required]: An integer value specifying the top value to return., [captioncaption [optional]: A text string displayed in the cell instead of the caption, if one is defined, from the cube.])=CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
  • connection (required): A text string of the name of the connection to the cube.
  • set_expression (required): A text string of a set expression, such as "{[Item1].
  • rank (required): An integer value specifying the top value to return.
  • caption (optional): A text string displayed in the cell instead of the caption, if one is defined, from the cube.
5CUBESETDefines 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=CUBESET(connectionconnection [required]: A text string of the name of the connection to the cube., set_expressionset_expression [required]: A text string of a set expression that results in a set of members or tuples., [captioncaption [optional]: A text string that is displayed in the cell instead of the caption, if one is defined, from the cube.], [sort_ordersort_order [optional]: The type of sort, if any, to perform and can be one of the following:

], [sort_bysort_by [optional]: A text string of the value by which to sort.])
=CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
  • connection (required): A text string of the name of the connection to the cube.
  • set_expression (required): A text string of a set expression that results in a set of members or tuples.
  • caption (optional): A text string that is displayed in the cell instead of the caption, if one is defined, from the cube.
  • sort_order (optional): The type of sort, if any, to perform and can be one of the following:

  • sort_by (optional): A text string of the value by which to sort.
6CUBESETCOUNTReturns the number of items in a set=CUBESETCOUNT(setset [required]: A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function.)=CUBESETCOUNT(set)
  • set (required): A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function.
7CUBEVALUEReturns an aggregated value from the cube=CUBEVALUE(connectionconnection [required]: A text string of the name of the connection to the cube., [member_expressionmember_expression [optional]: A text string of a multidimensional expression (MDX) of a member within the cube.1], ...)=CUBEVALUE(connection, [member_expression1], ...)
  • connection (required): A text string of the name of the connection to the cube.
  • member_expression (optional): A text string of a multidimensional expression (MDX) of a member within the cube.

 

0 Comments for '(Excel) - List of Excel Cube Functions with Syntax and Arguments'   

 
Email me replies   

Please kindly review and accept Terms of Use and Cookie & Policy Policy