The purpose of this exercise is to introduce you to creating new calculations using the CalcBuilder wizard. A calculation consists of existing data, functions, and constant values that are combined in a calculation to produce a new value. Depending on how the data, functions, and constant values are combined, the new value can be a new measure, such as Sales minus Quota.
This exercise creates a Quota Variance calculation that shows how Sales compares to Quota. In order to create this calculation, you use the CalcBuilder Wizard and select the Subtraction template. After the calculation is created, you can use it throughout your BI Beans application (for example, to display in graphs, crosstabs, and so on).
Quota Variance
. For calculation type, open the
Basic Arithmetic folder and select Subtraction.
Choose Next to continue.You just created a new calculation using the CalcBuilder Wizard. Now you can use this calculation, in the same way that you use any other measure, in any crosstab, table, or graph that you decide to create. If you want to modify the calculation, then simply right-click the calculation in the System-Navigator pane and select Edit from the popup menu.
1. Setting Up Your Project | Overview | 3. Creating Presentations