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:
Table 4-1 Clear Data Wizard Steps
Step | Explanation |
---|---|
Data Selection | Define the data to clear by selecting one or more members for each dimension.
The following options are available:
In Select a Clearblock Option, select an option to define how to clear the data:
|
Settings |
If you have a multi-currency application with 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. |