The set contains at least one member with a different dimension than the other members.ĬUBEVALUE may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection, and that PivotTable is deleted or you convert the PivotTable to formulas. (This can occur with multiple elements from the same hierarchy.) The tuple is invalid because there is no intersection for the specified values. The member specified by member_expression doesn't exist in the cube. The member_expression syntax is incorrect. If at least one element within the tuple is invalid, CUBEVALUE returns a #VALUE! error value.ĬUBEVALUE returns a #N/A error value when: If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEVALUE returns a #NAME? error value. If the connection name is not a valid workbook connection stored in the workbook, CUBEVALUE returns a #NAME? error value.
If a cell reference is used for member_expression, and that cell reference contains a CUBE function, then member_expression uses the MDX expression for the item in the referenced cell, and not the value displayed in that referenced cell. When the CUBEVALUE function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved. If no measure is specified in member_expression, the default measure for that cube is used. Use member_expression as a slicer to define the portion of the cube for which the aggregated value is returned. Alternatively, member_expression can be a set defined with the CUBESET function. A text string of a multidimensional expression (MDX) that evaluates to a member or tuple within the cube. A text string of the name of the connection to the cube. The CUBEVALUE function syntax has the following arguments:Ĭonnection Required. Returns an aggregated value from the cube. This article describes the formula syntax and usage of the CUBEVALUE function in Microsoft Excel.
EXCEL 2016 FOR MAC OLAP FOR ANDROID
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel for iPad Excel Web App Excel for iPhone Excel for Android tablets Excel 2010 Excel 2007 Excel for Mac 2011 Excel for Android phones Excel Starter 2010 More.
0 kommentar(er)
