Using the Database explorer

The Database explorer is a tool on the modeling workbench that shows information on database objects and allows you to perform common bulk actions on those objects. You must be an Administrator or Modeler to work with Database explorer.

To open the Database explorer, right-click the database on the modeling workbench Databases tree, then click Database explorer.

The Database explorer opens a Properties tab with the name of the database, which displays a table with the main TM1 objects that you can view, along with the numbers of each object in the specified database. Click the item count to open a table that displays all of the specified objects in the database. You can select multiple objects in the table and perform a bulk action on all selected objects.

With Database explorer, you can complete the following bulk actions on the following database objects:
  • Cubes
    • Delete
    • Lock
    • Unlock
  • Dimensions
    • Delete
    • Lock
    • Unlock
    • Reserve
    • Release
  • Hierarchies
    • Delete
  • Sets
    • Delete
  • Processes
    • Delete
  • Chores
    • Delete
    • Enable chore schedule
    • Disable chore schedule

You can also use filters to look for specific database objects in the system.