Clearing Cell Details

You can clear these cell details for a cube: 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 Working with FreeForm.

Note:

Because this function is for Service Administrators and Power Users, the application assumes that you have full access to details you delete.

To clear cell details:

  1. Click the Navigator icon Navigator icon, and then under Actions, click Clear Cell Details.
  2. For Cube, select a cube.
  3. To select all dimensions in the cube, click Add All Dimensions.

    Select members for the displayed dimensions.

  4. Specify the type of information to delete by selecting at least one option from Clear Options.
  5. Select members for the data intersections:
    1. In Dimension, select at least one dimension with details to delete.
    2. For displayed dimensions, click Member Selector icon (Member Selector). 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 isn't selected, the application includes all its members when clearing cell details.

    Caution:

    To clear exactly the data you want, select at least one Account member and members from all other dimensions. If you don't select at least one Account member, no data is cleared, even if you select the Yes, set value to #Missing option. If you don't select members from the other dimensions, all data for the selected Account member is cleared across all other dimensions.

  6. Optional: To select another dimension so you can select its members, click Add Dimension icon (Add Dimension).
  7. Click Clear.

    A Confirmation page displays your selections.

  8. Click Finish to proceed, or Back to change your selections.

    If Clear Cell Details is successful, data is deleted from the cube. If data isn't deleted successfully, a message is displayed. You can also check the log file.

  9. Optional: To view the execution status of Clear Cell Details and review the information that was deleted, view the Job . See Managing Jobs.
  10. To clear cell details for another cube, select another cube in step 2, and repeat the procedure.