O'Reilly logo

Getting Started with SQL Server 2012 Cube Development by Simon Lidberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating calculations

A key capability of the tabular mode is the ability to easily create calculations; these calculations could either be created as measures or KPIs that will be evaluated and calculated at the query time, or they can be created as columns that will be created during processing and stored as part of the model. In this section we will go through how to create calculations of different kinds when working with tabular models.

Adding calculated columns to the tabular model

The simplest calculation that you can create is a calculated column. A calculated column could either reference columns in the same table or other columns in other tables. To create a simple calculated column, perform the following steps:

  1. Switch to the Grid view ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required