MicroStrategy ONE

Delete All Unused Managed Objects

Managed objects can become unused in a project when you stop using the feature that created the managed objects. You can delete all unused managed objects to clean up your project.

For example, you can create a separate database instance for your Freeform SQL reports in your project. Later on, you may decide to no longer use Freeform SQL, or any of the reports created with the Freeform SQL feature. After you delete all the Freeform SQL reports, you can remove the Freeform SQL database instance from the project. Once you remove the database instance from the project, any Freeform SQL managed objects that depended solely on that database instance can be deleted.

You can implement the same process when removing database instances for Query Builder, SAP BW, Essbase, and Analysis Services.

To Delete All Unused Managed Objects from a Project

  1. Remove all reports created with Freeform SQL, Query Builder, or MDX cubes.

    If you are removing MDX cube managed objects, you must also remove all imported MDX cubes.

  2. In Developer, right-click the project and select Project Configuration.
  3. Expand the Database instances category.
  4. Select either SQL data warehouses or MDX data warehouses, depending on the database instance you want to remove.

    Freeform SQL and Query Builder use relational database instances, while SAP BW, Essbase, and Analysis Services use MDX cube database instances. For more information on the difference between the two, see the Installation and Configuration Help.

  5. Clear the check box for the database instance you want to remove from the project. You can only remove a database instance from a project if the database instance has no dependent objects in the project.
  6. Click OK to accept the changes and close the Project Configuration Editor.

    This procedure removes some preliminary object dependencies. Attribute and metric managed objects are not automatically deleted by this procedure, because you can reuse the managed attributes and metrics at a later time. If you do not plan to use the attribute and metric managed objects and want to delete them permanently from your project, continue through the rest of this procedure.

To Delete Unused Attribute and Metric Managed Objects

In Developer, from the Administration menu, select Projects > Delete unused managed objects.