ja_mageia

  • Narrow screen resolution
  • Wide screen resolution
  • Decrease font size
  • Default font size
  • Increase font size
Home Misc What is the recommended way to delete Planning applications and their related database tables?
What is the recommended way to delete Planning applications and their related database tables? PDF Print E-mail

Both Planning Classic and EPMA have a delete application feature that deletes the application
and its related database tables.
For Classic Planning:
Use the Classic Application Wizard in Planning to delete Classic Planning applications. See
"Deleting Applications" in the Oracle Hyperion Planning Administrator's Guide.
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. The data source used to connect to this application remains in the Planning System
database and gets a -1 in the app_id field used to point to the application record in another table
before the application was deleted. The Delete Application button also deletes the application
and all associated cubes/plan types from Essbase. No additional steps should be required to delete
a Core Planning application.
For EPMA:
Use the Application Library in EPMA to delete applications. See "Deleting Applications" in the
Oracle Hyperion Enterprise Performance Management Management Architect Administrator's
Guide.
An EPMA application will not show up in the list in Classic Planning Administration where the
Delete Application button is displayed. A Planning application that has been upgraded to EPMA
has to be deleted from the EPMA Application Library. Deleting the “application view” from the
EPMA Application library deletes everything deleted by the Delete Application button and in
addition deletes some records pertaining to this app from EPMA relational tables