Cleanup of Metadata after deleting Contributor App. V10

Post Reply
Mark H
Posts: 60
Joined: Tue Jul 10, 2012 3:37 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Cleanup of Metadata after deleting Contributor App. V10

Post by Mark H »

Folks

In Performance Modeler:
Have deleted applications using standard front end. Then tried to create new application using the same underlying 'model' with same approval hierarchy as before:

Error:
The Approval Hierarchy dimension 'xxxxxx' is being used by appliction '{5c8ba7c1-1cd7-4567-8182-07827b195afb}

After some grumbling i created a new Approval hierarchy and applied to all cubes in the model

Error
The cubeview 'xxxxxx' is being used by appliction '{5c8ba7c1-1cd7-4567-8182-07827b195afb}


Clearly the cleanup of internal metadata is still thinking the old/deleted application still exists.

Found bunch of control cubes relating to application state. Very loath to simply delete then. IS there a control cube clean up job i can run. Have already restarted the TM1 Server but no help.

See attachment for control cubes in question:

}TP_Application_State
Attachments
tp_applications_metadata.JPG
tp_applications_metadata.JPG (50.52 KiB) Viewed 3744 times
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Cleanup of Metadata after deleting Contributor App. V10

Post by sachin »

Mark H wrote:Folks

In Performance Modeler:
Have deleted applications using standard front end. Then tried to create new application using the same underlying 'model' with same approval hierarchy as before:
Have you restarted your service AFTER you delete the application? Sometime that can clear orphan/unused metadata
Check out my blog for some good information on TM1, SPSS
Mark H
Posts: 60
Joined: Tue Jul 10, 2012 3:37 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Cleanup of Metadata after deleting Contributor App. V10

Post by Mark H »

Yes, tried that. Problem persists
Mark H
Posts: 60
Joined: Tue Jul 10, 2012 3:37 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Cleanup of Metadata after deleting Contributor App. V10

Post by Mark H »

Found the solution:

There is a TI process we can use to 'clean-up'. Perhaps one day will invent menu driven options :(

http://www-01.ibm.com/support/docview.w ... wg21542848

It works.

M
Post Reply