Use the Calculation Wizard

You can use the Calculation Wizard to create new calculation columns that compare two existing columns, and also to create metrics in bulk.

It has a built-in mechanism to handle divide-by-zero and null cases, as well as other difficult situations. The Calculation Wizard provides an automated way to calculate the sales by quarter, the percentage of revenue, minimum and maximum values, and so on.

In the Calculation Wizard, the New Calculation page select from the following options:

• Change (CurrentX - ComparisonX)

  Subtract the value of the comparison column from the source column.

  For example, for the Change calculation, you can choose whether to return NULL or some other value when the comparison column is NULL.

• Percent Change (100.0 * (CurrentX - ComparisonX) / ComparisonX)

  Subtract the value of the comparison column from the source column and express as a percentage.

• Index (1.0 * CurrentX / ComparisonX)

  Divide the source column by the comparison column.

• Percent (100.0 * (CurrentX / ComparisonX))

  Divide the source column by the comparison column and express as a percentage.

1. In the Business Model and Mapping layer, right-click any logical fact or dimension column of data type numeric measure column, and then select Calculation Wizard.
2. Click Next
3. In the Select Columns, choose the columns that you want to compare with the source column.
4. Click Remove to take items out of the selected list.
5. Click Next.
6. In the New Calculations screen, choose the calculations to perform for specific columns.
7. Click Next when you've finished creating calculations.
8. In online mode, check out the objects to change.
9. Click Next to check out the necessary objects.

   The Finish screen displays a summary of the calculations that are created.

10. Click Back or select a particular step from the navigation panel to make changes.
11. Click Finish. The new calculation columns are created.