Everything Hyperion

During the budget preparation for the next year, we had a requirement where we had to delete the SUPPORTING DETAILS that were entered in Planning Data Forms.

It was not simply deleting all the details but we had to “wipe out everything from some of the supporting detail forms” where we had to “delete only the numbers and keep the description in some of the supporting detail reports.”

Well, in this case, there are two different options that came to my mind.

1                1. Use the “Clear Cell Details” options in Workspace. Administration -> Manage -> Clear Cell Details and specify the Plan Type and dimensions.

2                2. Use SQL script.

I thought about using the first option to start with, and I cleared the cell details using the Workspace. However, it wiped away the descriptions as well. So, it was not the proper method of clearing cell details in this case.

Therefore, I chose to use the second option of running the SQL script. The following Oracle link is where you can look to see how to “clear cell details.”

http://download.oracle.com/docs/cd/E17236_01/epm.1112/hp_admin/ch10s04s02.html

This document mentions two different SQL scripts – “sddelete.sql” and “aadelete.sql” and these can be found under the Hyperion home path D:\oracle\Middleware\EPMSystem11R1\products\Planning\config\sql.

By modifying the script as per our need and running the script, we were able to delete only the data in the supporting detail forms without having to delete the description.

If you have similar kind of situation, you can use the two scripts in order to delete supporting details.