Synchronizing Supporting Detail with Essbase

Data source types: Oracle Hyperion Planning

If you are unfamiliar with Planning, see theOracle Hyperion Planning User's Guide, available in the Oracle Help Center. To open this library, from the Smart View ribbon, select the arrow next to Help, and then Documentation.

In Planning applications, when you delete supporting detail for a cell, you affect the associated value in the relational database. You specify how to handle the stored Oracle Essbase value. You can set it to #Missing or leave it as it was before the supporting detail was deleted. This feature is useful if you want to use supporting detail as a scratch pad or calculator.

To synchronize supporting detail with Essbase:

  1. Open a form.
  2. In the form, click the cell that has the supporting detail you want to remove.
  3. From the Planning or Planning Ad Hoc ribbon, select Supporting Detail.
  4. In the Supporting Detail window, delete the information, and then click OK.
  5. Select an option from the displayed message to specify how to handle the aggregate value of the deleted supporting detail stored in Essbase:
    • To delete the value from Essbase, click Yes, set the value(s) to #Missing.

    • To leave the data value in Essbase as is, click No, leave the value(s) as is.