Deleting a dimension from Hyperion Planning application (11.1.2.3)

I have seen few posting online regarding how to delete a dimension from classic planning application. Most of them were tested in system 9. The table structure has changed from 9 to 11 so I tried in 11.1.2.3.500 with “Decision Package Enabled Public Sector Planning and Budgeting Application”. Most of old steps hold true in 11.1.2.3 also. Here are the steps to delete dimension from Planning Application. This steps also applies to pre-build module like Public Sector Planning and Financial Planning application.

1.      Delete all members of the dimension you want to remove (if there are any) 

2.      If security is enabled at dimension level, uncheck that option in the dimension properties 

3.      Refresh the Planning application to Essbase 

4.      Stop the Planning web services.

5.      Edit the relational database for the Planning application concerned 

6.      Find dimension to be removed in the HSP_OBJECT table by running a SQL query: 
SELECT * FROM HSP_OBJECT WHERE (OBJECT_NAME = 'NameOf TheDimension'); 
Write down the OBJECT_ID number of the dimension. Once you find the object make the note of object it. You will need this ID to find in other tables.  (Do not delete the record in the HSP_OBJECT table at this time)

7.      Delete the record with the dimension’s OBJECT_ID in the HSP_UNIQUE_NAMES table 
Make sure this record has been removed from the table. 
Then delete the row matching the dimension’s OBJECT_ID in the following tables, if it is present: 
HSP_MEMBER (MEMBER_ID and DIM_ID should both match the OJBECT_ID) 
HSP_MRU_MEMBERS (DIM_ID should match; this table is present in System 9 only) 
HSP_DIMENSION (DIM_ID should match) 
HSP_OBJECT (delete the row you retrieved earlier when checking the OBJECT_ID) 
HSP_PENDING_XACTS (usually empty, but should be checked) 

8.      Restart Planning service 

9.      Do a Refresh of the Planning application to Essbase 

10.  Clear the browser cookies and log into planning application. The dimension should disappeared.. 

11.  Do another refresh of the Planning application to confirm no errors occur 

Additional reading

How Can We Delete Dimensions In Planning Once The Application Has Been Deployed From EPMA? [ID 1055007.1]

http://www.network54.com/Forum/58296/thread/1164751141/Delete+dimension+in+Planning

How to delete dimension from Planning Application

http://hyperionism.blogspot.com/2009/02/how-to-delete-dimension-from-planning_12.html

Delete Dimension from Planning Application

https://community.oracle.com/thread/1061026

Note:- Please make sure you have backup  of your environment before to perform above mentioned steps. These steps can be used as a guideline. Author does not hold any responsibility for any damage.