You can clear these cell details for a plan type: account annotations, supporting detail, cell text, and cell-level documents. For information on creating and viewing account annotations, supporting detail, cell text, and cell-level documents, see the Oracle Hyperion Planning User's Online Help.
Notes:
You cannot delete planning unit annotations.
Because this function is for administrators and interactive users, Planning assumes you have full access to details you delete.
Oracle recommends that you back up the application before performing this procedure. See the Oracle Hyperion Enterprise Performance Management System Backup and Recovery Guide.
You can also clear cell details with SQL scripts. See Deleting Application Information Using SQL.
To clear cell details:
For Plan Type, select a plan type, and click Go.
When you click Go, dimensions are selectable for this plan type.
Select members for the data intersections:
For Dimension, select at least one dimension with details to delete.
For displayed dimensions, click . On the Member Selection page, make a selection that includes the details to delete.
Note: | For every dimension selected, you must select at least one member. If a dimension is not selected, Planning includes all its members when clearing cell details. |
Optional: Further refine the data intersection by specifying more members:
To select another dimension so you can select its members, click Add Dimension.
To select all dimensions in the plan type, click Add All Dimensions.
Select members for the displayed dimensions.
Specify the type of information to delete by selecting at least one option from Clear Options:
Account Annotations
Supporting Details
Cell Text
Cell-level Document
A Confirmation page displays your selections.
Click Finish to proceed, or Back to change your selections.
If Clear Cell Details is successful, data is deleted from the plan type. If data is not deleted successfully, a message displays. You can also check the log file.
Optional: To view the execution status of Clear Cell Details and review the information that was deleted, select Tools, then Job Console.
See “Checking Job Status” in the Oracle Hyperion Planning User's Online Help.
To clear cell details for another plan type, select another plan type in step 2, and repeat the procedure.