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.

1) Download and open the attached Analysis Services solution provided at the end of this turorial.

2) Under the Cubes folder, double click on the Analysis Services Tutorial to open the Cube Designer.

3) Click on the Calculations tab.

4) Right click from within the Action Organizer pane and select New Calculated Member.

This will render the Calculated Member designer.

5) Enter '[Product Gross Profit Margin]' for the Name value.

6) Select 'Measures' for the Parent Hierarchy value.

Note: The Parent Hierarchy are descriptive categories of a dimension by which the numeric data (that is, measures) in a cube can be separated for analysis.

Note: Because we are not using Measures for the Parent Hierarchy the Parent Member is unavailable. A Parent Member allows you to place the newly created calculated member under a parent member. The heading for the calculated member is added at the level directly below the parent member you select.

About Us

InfoToad Consulting provides Data Management, Business Intelligence and Advanced Analytics solutions. If you would like to learn more about our services or solutons, please visit us at http://www.infotoad.com or call us at (877) 488-0566.