A text string that is displayed in the cell instead of the caption, if one is defined, from the cube. Set_expression can also be a cell reference to an Excel range that contains one or more members, tuples, or sets included in the set.Ĭaption Optional. A text string of a set expression that results in a set of members or tuples. A text string of the name of the connection to the cube. The CUBESET function syntax has the following arguments:Ĭonnection Required. SyntaxĬUBESET(connection, set_expression,, , ) Descriptionĭefines 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.
This article describes the formula syntax and usage of the CUBESET function in Microsoft Excel.
