SQL Server Analysis Services 2012 Cube Development Cookbook

Creating measures

A calculated measure performs aggregation in the model efficiently by processing calculations on the server during query time. Measures can be defined using simple aggregate functions, or they can include complex business logic by using combinations of functions.

Getting ready

In a Tabular Model, a table can play two roles either as a container for measures (often referred to as a measure group or fact table) or a lookup table (often referred to as a dimension table in multidimensional models). When a model is processed, the Tabular processing engine determines the role of tables and applies the appropriate metadata to them in the final model. If a table has non-summarized or non-numeric columns, it shows up in the client application ...