Example - Using a Calculated Column to Support Allocated Measures

You can add a calculated column that consists of numeric data to be used in measure allocation.

Suppose you have two sources of data about a professional sports team. The first source contains data for individual players, and the second contains current and forecast salary figures for each team.

Procedure

  1. You add a calculated column to the second data source representing each team's forecast salary based on a 13% increase for the next year, such as 
    "CURRENT_SALARY" * 1.13
  2. You drag the calculated column to the Measures list, which makes these figures available for allocation to the player level. For more information about how to allocate measures, see Allocating Measures.

Results

Your OLAP analysis users can now see each player's salary forecast.