Removing the VALTYPE slicer

We can 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 value displayed in C11.
  2. Click C11 and open the Edit OLAP Formula dialog box.
  3. In the Data Area, click Formula in the Hierarchy column, adjacent to the ValType combo box selection. Select Value Type from the list that is enabled.
    The adjacent field in the Selection column displays [Valtype].[Variance].[Actual] - the unique name of the default element of the Value Type dimension.
  4. Click OK to close the Edit OLAP Formula dialog box.
  5. In Design mode, right-click the Valtype combo box and select Delete Object.
    Notice that the value in C11 has not changed. The formula in C11 now refers to the unique name of the Actual element, instead of to a combo box.
  6. Delete the Valtype: label from cell J6.