Oracle^® Business Intelligence Server Administration Guide > Oracle BI Administration Tool Utilities and Expression Builder > Utilities and Wizards >

Calculation Wizard

You use the Calculation Wizard to create new calculation columns that compare two existing columns and to create metrics in bulk (aggregated), including existing error trapping for NULL and divide by zero logic.

You start the Calculation Wizard in the Business Model and Mapping layer by right-clicking any logical fact or dimension column of data type numeric, and then selecting the option Calculation Wizard. For information about setting up the Calculation Wizard, refer to Using the Options Dialog Box—General Tab.