Using the Clear Data Template

Use the Clear Data template to clear data from members in the cube.

To clear data, you specify the members whose values you want to clear. You can clear data for one member or for a block of members.

For example, you could use the Clear Data template to clear forecast data before copying data from "actual" to "forecast" and making changes.

To use the Clear Data template:

Create or open a business rule or a template.
Do one of the following:
- For a graphical rule or template, under New Objects, select Clear Data, and then drop it into the flow chart between Begin and End.
- For a script rule or template, expand System Templates, then select Clear Data, and then drop it into the desired area in the script.
Enter the requested information in the Clear Data Wizard.

Table 4-1 Clear Data Wizard Steps

Step Explanation

Step	Explanation
Data Selection	Define the data to clear by selecting one or more members for each dimension. The following options are available: Click next to Use Predefined Selection to select variables to populate all the dimensions with values. Click next to Member Selector to select members and functions for each dimension. Select a dimension, and then click to select a variable, member, or function. In Select a Clearblock Option, select an option to define how to clear the data: All—Clears all blocks of data Upper—Clears only consolidated blocks of data. Dynamic—Clears blocks containing values derived from Dynamic Calc and Store member combinations Non-Input—Clears data blocks containing derived values. This works only for blocks that are created completely by a calculation operation and not blocks into which any values are loaded. N/A—Clears data blocks and sets the members to #Missing
Settings	If you have a multi-currency application with `HSP_Rates` set to "sparse" or a single-currency application, Settings displays the members selected in Data Selection. Click the drop-down, and select a dimension where a single member is selected, preferably a dense dimension. Note: Since the script uses the member from the dimension you select, if you cannot select a dimension where a single member is selected, then you cannot use this template.

Data Selection

Define the data to clear by selecting one or more members for each dimension.

The following options are available:

Click next to Use Predefined Selection to select variables to populate all the dimensions with values.
Click next to Member Selector to select members and functions for each dimension.
Select a dimension, and then click to select a variable, member, or function.

In Select a Clearblock Option, select an option to define how to clear the data:

All—Clears all blocks of data
Upper—Clears only consolidated blocks of data.
Dynamic—Clears blocks containing values derived from Dynamic Calc and Store member combinations
Non-Input—Clears data blocks containing derived values. This works only for blocks that are created completely by a calculation operation and not blocks into which any values are loaded.
N/A—Clears data blocks and sets the members to #Missing

Settings

If you have a multi-currency application with HSP_Rates set to "sparse" or a single-currency application, Settings displays the members selected in Data Selection.

Click the drop-down, and select a dimension where a single member is selected, preferably a dense dimension.

Note: Since the script uses the member from the dimension you select, if you cannot select a dimension where a single member is selected, then you cannot use this template.