Delete Unused Schema Objects: Managed Objects

MicroStrategy projects contain schemas and related schema objects, including attributes, tables, hierarchies, and so on. For an introduction to schema objects, see the Project Design Help.

Certain MicroStrategy features automatically create new schema objects, referred to as managed objects, which are not directly related to the project schema. The features that create their own managed objects are:

• Freeform SQL and Query Builder. For information on Freeform SQL and Query Builder, see the Advanced Reporting Help.
• MDX cube sources such as SAP BW, Hyperion Essbase, Microsoft Analysis Services, and IBM Cognos TM1. For information on MDX cube sources, see the MDX Cube Reporting Help.
• Import Data, which lets you use MicroStrategy Web to import data from different data sources, such as an Excel file, a table in a database, or the results of a SQL query, with minimum project design requirements.

Managed objects are stored in a special system folder, and can be difficult to delete individually due to how these objects are created and stored. If you use one of the features listed above, and then decide to remove some or all of that feature's related reports and MDX cubes from the project, there may be unused managed objects included in your project that can be deleted.

This section covers the following topics:

• Delete Managed Objects One-By-One
• Delete All Unused Managed Objects