Delete a database
Planning Analytics on Cloud users can delete TM1 databases by using Planning Analytics Workspace Administration.
The system imposes the following restrictions on this functionality:
- Last TM1 database cannot be deleted.
At least one database must always exist in Planning Analytics Workspace Administration.
- The database tm1s.cfg file is missing or contains errors.
For example, the
ServerName
parameter is missing in the file.The errors are not shown in Planning Analytics Workspace Administration, and are most likely caused by manual modifications to the tm1s.cfg file. For more information, see the topic Can I change the tm1s.cfg file?
- Cognos Controller Financial Analytics Publisher (FAP) databases cannot be deleted.
Before you begin
The ability to delete a TM1 database is not available in the Planning Analytics Workspace Classic Experience. For information about enabling the New Experience, see this article.
The database server must be stopped before you can delete the database.
About this task
Deleting the database in the user interface doesn’t delete the database directory and its contents from the data tier. The database directory, and the folders and files in it, are left for you to decide if they should be deleted, moved, copied, or kept on the data tier. It is strongly recommended to move the directory elsewhere if you don't intend to recreate the database.
Procedure
Results
The database name no longer appears in the Databases panel.
Also, the database is no longer available for use in Planning Analytics Workspace Books, as well as Planning Analytics for Microsoft Excel Explorations and Reports. Any existing content that leverages the database will now have errors.
What to do next
Decide what to do with the database directory and its contents. You can copy, move, or delete the directory, or keep in on the data tier. For more information about files and folders in the database directory, see Create a database.