Removing the VALTYPE slicer

We will edit the formula in C11 to reference the Actual figures and remove the Valtype combo box which allowed users to select a value type.

  1. Open the Tutorial6 report. In Design Mode, select Actual from the Valtype combo box. Note the figure displayed in C11.
  2. Click C11 and open the Edit OLAP Formula dialog.
  3. Click the browse button next to the Valtype dimension to display the Elements dialog.
  4. Select the Actual element and click OK .
    The formula now refers to [Valtype].[Variance].[Actual] instead of to the Valtype combo box.
  5. Right-click the Valtype combo box and select Delete Object.
    Notice that the figure in C11 has not changed.
  6. Delete the Valtype: label from cell J11.