This content has been marked as final. Show 3 replies
Delete the app from shared services.
Delete the app from essbase (using EAS)
Go into the planning system relational tables
Table HSPSYS_APPLICATION, delete row relating to planning app, note the app_id.
Table HSPSYS_APP_CLUSTER_DTL, delete row with id that you have just noted down (a record may not exist so just ignore this step)
Table HSPSYS_PROPERTIES, delete records with id that you noted down.
Table HSPSYS_DATASOURCES, update app_id to -1 for the datasource you use for the planning app. (if you don't want to use the datasource again just delete the record)
Drop/Recreate the schema for the planning application, this is so the schema can be used again when you recreate the application.