Deleting Supporting Detail Associated With a Scenario
You can use the sddelete.sql
file, installed in the sql
directory, to delete supporting detail associated with scenarios. It includes SQL queries that delete supporting detail for selected scenarios. To use the Clear Cell Detail feature to clear supporting detail, see Clearing Cell Details.
To delete supporting detail associated with scenarios:
- Stop the Web application server.
- Update the SQL queries section of the
sddelete.sql
file corresponding to your type of relational database by substituting the scenario name with the supporting detail to delete. - Run queries in the
sddelete.sql
file appropriate for your relational database. - Start the Web application server.
Example: Deleting supporting detail associated with a scenario
Supporting detail for the Actual scenario is deleted:
DELETE
FROM HSP_COLUMN_DETAIL_ITEM
WHERE DETAIL_ID IN
(SELECT DETAIL_ID
FROM HSP_COLUMN_DETAIL
WHERE DIM1 =
(SELECT OBJECT_ID
FROM HSP_OBJECT
WHERE OBJECT_NAME ='ACTUAL'));
DELETE
FROM HSP_COLUMN_DETAIL
WHERE DIM1 =
(SELECT OBJECT_ID
FROM HSP_OBJECT
WHERE object_name ='Actual');