Create a custom Calculation (Calculated Member) using Analysis Services 2012 Cube Designer

In this article we will examine how to design a Calculated Member using Cube Designer in SQL Server Analysis Services 2012.

What is a Calculated Member?

A Calculated Member is the result of customized measures or dimension members, by combining cube data, arithmetic operators, numbers, and functions. For example, you can create a calculated member named 'Gross Profit' wich includes total sales amounts, minus the total product costs. Gross Profit can then be displayed to end users in a separate row or column.