Cube Formulas in Excel

Cube formulas in Excel are used to perform cube related calculations such as tuple, value of member property, aggregate value and number of items in a set. The cube formulas extract values from an Excel data model and provide flexibility on reporting.

In this tutorial page, you will learn how to use all the cube formulas in Microsoft Excel with detailed explanations, examples and videos.

Cube Formulas in Excel | Rath Point

All Cube Formulas in Excel

Click on any of the below cube formulas in Excel to get the detailed information about it.

CUBEKPIMEMBER Formula in Excel

CUBEMEMBER Formula in Excel

CUBEMEMBERPROPERTY Formula in Excel

CUBERANKEDMEMBER Formula in Excel

CUBESET Formula in Excel

CUBESETCOUNT Formula in Excel

CUBEVALUE Formula in Excel

Summary of all Cube Formulas in Excel

CUBEKPIMEMBER

Key Performance Indicator (KPI) property and displays the KPI name in the cell.

CUBEMEMBER

Value of a specific member or tuple from the cube.

CUBEMEMBERPROPERTY

Value of a member property from the cube.

CUBERANKEDMEMBER

Nth or ranked member in a set.

CUBESET

A calculated set of members or tuples by sending a set expression to the cube on the server.

CUBESETCOUNT

Count the number of items in a set within a cube.

CUBEVALUE

Aggregated value from the cube.

» Financial Formulas

» Logical Formulas

» Text Formulas

» Date & Time Formulas

» Lookup & Ref Formulas

» Math & Trig Formulas

» Statistical Formulas

» Engineering Formulas

» Cube Formulas

» Information Formulas

» Compatibility Formulas

» Web Formulas