Using the Clear Data Template in a Business Rule (Planning and Essbase Block Storage Users Only)

You use the Clear Data template in a business rule to delete data from a location in the database. To delete data, you specify the location (that is, the application, dimensions, and members) of the data you want to delete. You can delete data for one member or for a block of members you define.

For example, you may want to use the Clear Data template in a business rule to delete forecast data before you copy data from actual to forecast to make changes to it.

  To use the Clear Data template in a business rule:

  1. Complete step 1 through step 4.

  2. In the Clear Data Template Wizard, on Data Selection, do one of these tasks:

    • Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

      Predefined selections are populated with variables you create. For each tab, the type of variables shown can differ. You can use predefined selections on any tab where there is member selection. You can also change the members that are populated when you use predefined selections.

    • Click the Member Selector icon to select members and functions for each of the dimensions listed.

      Note:

      In the Member Selector, the dimensions listed in the current step of the wizard are available for selection from Dimension. This enables you to select members and functions for any of the dimensions listed in the current step of the wizard.

    • Select a dimension in the list, and click the Actions icon to select a member, variable, or function. See Using Member Selection, Variables, Functions, and (for Planning Users Only) Smart Lists to Design Components.

  3. On Data Selection, do these tasks:

    1. Specify how to clear the data by selecting one of these options:

      • All: Clear cells only.

      • Upper: Clear the entire block.

      • Dynamic: Clear dynamic calc and store blocks.

      • Non-Input: Clear non input blocks.

      • N/A: Clear upper level blocks.

    2. Specify whether to turn the debug tool on for the wizard.

  4. If you have a multi currency application with HSP_Rates set to sparse or a single currency application, the Settings step is displayed. This step displays the members you selected on the Data Selection tab. Select a dimension where a single member is selected, preferably a dense dimension.

    Note:

    If you cannot select a dimension where a single member is selected, then you cannot use this template.

  5. Click Finish.