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.

Note: To recreate a deleted database, you can create a new database with the same name. The database will use the existing directory and its contents if they are still on the data tier.

Procedure

  1. Log on to Planning Analytics as a member of the Administrator role.
  2. In the Welcome page, select Administration.
  3. Click Databases.
  4. In the Databases panel, locate the database that you want to delete, and click its name.
  5. On the Details tab, check the database status. If the status is Started, click Stop.

    The database must be stopped before it can be deleted. It might take a few minutes to stop the database. When the process is complete, the database icon changes to stopped Stopped database icon.

    You can now proceed to delete the database.

  6. In the Databases panel, select the database that you want to delete.
  7. In the toolbar, click the delete icon Delete database icon.

    A dialog box with a message is displayed.

  8. In the dialog box, select the Delete this database checkbox, and then click the Delete button.

    The database is deleted from the user interface, but the database directory is retained.

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.