Synchronizing Supporting Details with the Cube

Data source types: Planning

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

To synchronize supporting details with the database:

Open a form.
In the form, click the cell that has the supporting details you want to remove.
From the provider ribbon or provider Ad Hoc ribbon, select Supporting Details.
In the Supporting Details window, delete the information, and then click OK.
Select an option from the displayed message to specify how to handle the aggregate value of the deleted supporting detail stored in the cube:
- To delete the value from the cube, click Yes, set the value(s) to #Missing.
- To leave the data value in the cube as is, click No, leave the value(s) as is.