SQL Server Analysis Services 2012 Cube Development Cookbook

Defining measure expressions

Measure expressions allow the performing of a calculation at the individual dimension member-level and subsequently aggregating the result for the entire dimension. A measure expression is either a product or division of two measures that could belong to the same or different measure groups. For example, the sample Adventure Works multidimensional database contains Reseller Sales and Exchange Rates measure groups. Since the fictitious bike company operates globally, we might want to express the [reseller sales amount] measure in multiple currencies. As you know, the currency rates vary from time to time, and hence, we maintain the Exchange Rates measure group that tracks how various currencies perform in comparison ...