Adding a Clear Data Action

You can use the Clear Data action to clear data from a portion of a database. This ensures that the destination is cleared before applying the next action or formula (or the components of a business rule). You can place the Clear Data action anywhere in the business rule. For additional information on this action, see the Essbase Technical Reference.

*  To add a Clear Data action to your business rule:

  1. If it is not open, open the graphical business rule to which you want to add a Clear Data action.

  2. If the BR Language tab is not selected, select it in the bottom of the left frame of the Analytic Administration Services window.

  3. Expand the Actions folder and double-click the Clear Data action, or drag it to the desired location in the business rule on the Graphical tab.

    The Clear Data action is added to the business rule and the Overview tab is displayed.

  4. On the Overview tab, specify whether you want to clear cells only or clear data blocks.

    • Clear Cells Only—Clears data cells from the database and sets them to #MISSING. For additional information, see the CLEARDATA command in the Essbase Technical Reference.

    • Clear Entire Block—Clears blocks of data and sets them to #MISSING. For additional information, see the CLEARBLOCK command in the Essbase Technical Reference. You can choose one of the following:

      • All (clears all data blocks)

      • Dynamic Calc & Store (clear blocks containing values derived from Dynamic Calc and Store member combinations)

      • Non-Input Blocks (clears blocks containing values derived from calculations)

      • Upper Level Blocks (clears all consolidated level blocks)

  5. For each dimension in the list that you want to include, select the values to be cleared by entering values in the Selected Values text box or by clicking the Member Selection button to select members and variables. For more information on selecting members, see Selecting Members.

    Values are cleared for the intersection of all specified dimensions for all values of the dimensions left <Not Specified>.