Deleting a Planning Application in Oracle Hyperion Planning, Fusion Edition 11.2.2

In one of my earlier blogs, I demonstrated the steps to create a Planning application. In this tutorial, I will show you how to delete a Planning application in EPM 11.2.2.

I have a sample application called 'poc1'.

Now, lets go about tactically nuking the application 💀

First step that we need to do is delete the Planning Essbase application from EAS console. Before that, we will clear the data in the application.

Go to each plan type, right click on it then Clear then All data.

You will be asked for confirmation. Please select Yes.

You will get a confirmation once data is cleared.

Do this for all the plan types. Now let's delete the application from EAS console. Right click on the application name then Delete then Application.

You will be asked for confirmation. Please select Yes.

The application will be deleted from EAS console.

Now, before we head over to Workspace and delete the application from there, let's take a glance at few back-end tables.

In Planning application schema, the application exists in the HSPSYS_APPLICATION table:

In the HSPSYS_DATASOURCE table, the data source for this application has a value of 2 in APP_ID field.

Before deleting the application, number of tables in the Planning application's schema is 142.

SQL: select count (*) from (select * from all_objects where owner='<your Planning application schema>' and object_type='TABLE');

Now, let's go to Planning Administration in Workspace. In Manage Applications, I can see the application listed:

In Manage Data Source, I can see the data source listed for this application:

In the Manage Application screen, click on the application and click on the red cross.

You will be asked for a confirmation, click on Yes.

You will get a confirmation:

Click on OK. By now the application should have been deleted from the Application Groups in Shared Services. If not, delete it manually.

The Delete Application button deletes all Planning created HSP_xxx tables in the Planning relational database and all the records pertaining to that application in the Planning System database. Let's check.

Note: The Delete Application button also deletes the application and all associated cubes/plan types from Essbase. However, we have already done this step in the beginning.

The HSPSYS_APPLICATION table no longer has the application details:

The HSPSYS_DATASOURCE table, the data source used to connect to this application remains in the Planning System database and gets a -1 in the APP_ID field .

This indicates that the data source is free to be used. Notice that the application name is no longer linked to the data source.

Now, let's check the tables (if they are indeed existing) in the Planning application's schema.

SQL: select count (*) from (select * from all_objects where owner='<your Planning application schema>' and object_type='TABLE');

All the tables have been dropped. The schema is clean. If you see any tables remaining, drop them manually.

SQL: drop TABLE <schema_name>.<table_name> cascade constraints purge;

That's all!