Adding Functionality to Your Cube - Getting Started with SQL Server 2012 Cube Development - page 151

2. Switch to the Cube Structure tab and right-click on the Fact Internet Sales
measure group and choose New Measure... :

3. In the New Measure dialog, click on the Order Quantity column and then
click on OK .

Note

In the New Measure dialog, you have the ability of specifying the type of
calculation that you wish to define on the measure. In all our measures,
we will either work with Sum or Count. However, there are a lot of
other calculations that you can perform on columns. Description of those
can be found in Books Online at http://msdn.microsoft.com/en-us/library/
ms175623.aspx#AggFunction .

4. Perform the same steps for the following measures:

Measure Name Column Name Format String

Order Quantity #,##0;-#,##0

OrderQuantity

Unit Price Currency

UnitPrice