Optimize input values to meet a target

Use target-based optimization to determine the input values required to achieve a specific business objective, such as a revenue target. Optimize recalculates one or more selected input measures and updates them with the values needed to achieve the specified result.

Prerequisites#

Before you begin, review the Prerequisites section for Optimize to understand the initial setup requirements.

Achieve a target on a calculated field #

To demonstrate target-based optimization, set a target for the calculated field Profit forecast by optimizing independent variables - Revenue Forecast, Purchase Forecast, Advertising Forecast, and Transport Forecast.

1. Select the target cell in the calculated measure. In the Planning ribbon, select Optimize. In this example, select the target cell from the Profit Forecast measure.

2. To achieve a specific target, set Objective to Target and enter the target value. In this example, set the target value to 45m.

3. Select the data input or forecast measures (independent variables) to optimize from Variables to Update. In this case, Optimize adjusts the Revenue Forecast, Purchase Forecast, Advertising Forecast, and Transport Forecast to achieve the target Profit Forecast. Select Next.

4. Select Add Constraint to define the minimum and maximum limits for the data input measure. For more information, see Configure optimization thresholds.

5. Choose the measure to apply the constraint from Apply to Variable. Select Range for the Set Type option. Enter the minimum and maximum optimization thresholds.

6. Select Apply. Select Add to specify additional constraints. Select Run after you define all the constraints.

7. Review the adjusted values, then select Apply to update the independent measures with the optimized values. For more information about Optimize parameters, see Adjust parameters to achieve targets.

8. Optimize increases the Profit Forecast to 45m from 43.92m after adjusting independent measures within the specified constraints. Since you applied Optimize to a total value, the update is cascaded to all the related child dimensions.