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

Measure Name Column Name Format String

Extended Amount Currency

DiscountAmount

Product Standard Cost Currency

ProductStandardCost

Total Product Cost Currency

TotalProductCost

Tax Amt Currency

TaxAmt

Freight Currency

Freight

5. Now you have a cube with a measure group containing a total of 10 meas-
ures.

You will be able to analyze all the new measures using the existing dimensions; the
reason for this is that the relationship exists between the associated measure group
and the dimension tables.

Adding additional measure groups

In the sample database, Internet Sales is just one part of the entire sales for the
company; Adventure Works also sells through a chain of resellers. This information
is available in the FactResellerSales table. In order to perform analysis on this
information, we need to add the table and the related tables to the Data Source view
and then create the new dimensions and the measure group. To do this follow these
steps:

1. Open up the Adventure Works DW2012.dsv Data Source View file.