When the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or later data source, this function returns …
Category: Cube funcitons
Cube functions were introduced in Microsoft Excel 2007. They are used with connections to external SQL data sources and provide analysis tools. Data cubes are multidimensional sets of data that can be stored in a spreadsheet, providing a means to summarize information from the raw data source. A cube is different from queries in Microsoft Access or Microsoft SQL Server because the data in a cube is already grouped in hierarchies, and calculated measures are saved in the cube. This offers two advantages to the user: Summary information is readily available, and most of the heavy-duty calculations are performed on the server. The user does not have to spend much time consolidating the data in Excel. However, you cannot use calculated fields or elements for a PivotTable.
The CUBESETCOUNT function returns the number of items in a set. Syntax: CUBESETCOUNT(set) The CUBESETCOUNT function syntax has the following …
The CUBESET function defines a calculated set of members or tuples by sending a set expression to the cube on …
The CUBERANKEDMEMBER function returns the nth, or ranked, member in a set. Use this function to return one or more …
The CUBEMEMBERPROPERTY function returns the value of a member property from the cube. Use this Function to validate that a …
The CUBEMEMBER function returns a member or tuple from the cube. Use this function to validate that the member or …
Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable …