Creating columns for Budget and Forecast

In this procedure, we will add two columns that provide information about budget and forecast for the selected product level.

  1. Click the border of the Product hyperblock to select it.
  2. Drag the right-hand edge of the Product hyperblock to cell E11.
    The hyperblock now occupies cells B11 to E11.
  3. Click D11 and click Edit OLAP formula to create an OLAP formula. Specify Budget as the value of the Valtype element.
  4. Select E11 and click Edit OLAP formula to create an OLAP formula. Specify Forecast as the value of the Valtype element.