MicroStrategy ONE

Compare Objects Between Two Projects

The Project Comparison Wizard compares objects in a source project and a destination project.

For the source project, you specify whether to compare objects from the entire project, or just from a single folder and all its subfolders. You also specify what types of objects (such as reports, attributes, or metrics) to include in the comparison.

Every object in a MicroStrategy project has a unique ID. Project Comparison looks at each object ID in the source project, and compares it to the object in the destination project with the same ID. For each object ID, Project Comparison indicates whether the object is:

  • Identical in both projects
  • Identical in both projects except for the folder path
  • Only present in the source project
  • Different between projects, and newer in the source or destination project

You can print this result list, or save it as a text file or an Excel file.

Since the Project Comparison Wizard is a part of Object Manager, you can also select objects from the result set to immediately migrate from the source project to the destination project. For more information about migrating objects using Object Manager, see Copy Objects Between Projects: Object Manager.

Using the Project Comparison Wizard

The following high-level procedure provides an overview of what the Project Comparison Wizard does.

To Compare Two Projects

  • To compare two projects with the Project Comparison Wizard, those projects must have related schemas. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. For information about duplicating projects, including instructions, see Duplicate a Project.
  • The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. For an overview of Object Manager, see Copy Objects Between Projects: Object Manager.
  1. In Windows, go to Start > All Programs > MicroStrategy Products > Object Manager.
  2. Open a project source in Object Manager.
  3. From the Project menu, select Compare Projects.
  4. Select the source and destination projects.
  5. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare.
  6. Review your choices at the summary screen and click Finish.
  7. Select Save as Text File or Save as Excel File.
  8. To migrate objects from the source project to the destination project using Object Manager, select those objects in the list and click Proceed. For more information about Object Manager, see Copy Objects Between Projects: Object Manager.