Recalculating a report after an action runs

This example demonstrates a use of the Enforce recalculation of entire report option that is available as an optional input of a set parameter, select element, export report, or Application Engine process action.

The example uses a combo box that contains a list of years, and a hyperblock that displays the child elements of the selected year.

  1. Insert a combo box in a report and link it to the Period dimension of the Analysis cube.
  2. Use structure selection in the list designer to populate the list with several individual years.
  3. Create a report variable and select it as the output variable of the combo box.
  4. Drag the Period dimension into a cell to form a hyperblock.
  5. In structure selection in the list designer, select Functions > Elements underneath > All, Excluding Parent
  6. In the selection settings section of structure selection, select Edit Formula in the Element list and select the output variable of the combo box.
  7. In the Object Properties dialog of the combo box, select Perform action when selection changes and click the browse button.
  8. Click OK in the Define Action dialog.
    A set parameters action is created.
  9. In the Format Hyperblock dialog, select the Begin expansion at level check box and select 3 from the list.
    In View mode, the hyperblock displays the quarters and months of the year selected in the combo box.
  10. Select a different year from the combo box.
    The hyperblock collapses and displays only the quarters.
  11. Edit the action on the combo box and click Add input/option in the Inputs/Options section of the Edit Action dialog.
  12. Select Optional inputs > Enforce recalculation of whole report.
    In View mode, the hyperblock remains expanded when you select different years from the combo box.