Creating a calculated measure
One of the great strengths in a model is the ability to create calculated measures and calculated columns. This recipe will cover calculated measures, and the next recipe will discuss calculated columns. However, this is a good place to differentiate between the two.
A good example of a calculated measure would be the sum of sales in our sample model. In this case, we will want to slice the sum by many different values within the model, such as date, customer, and product. A calculated measure will use these values to create a slice of references that are used to get the sum of sales.
One example of a calculated member is a formatted customer name such as Last name, first name. In this case, you need to use the context ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
