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:

  1. Stop the Web application server.

  2. 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.

  3. Run queries in the sddelete.sql file appropriate for your relational database.

  4. 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');