MicroStrategy ONE

MicroStrategy Enterprise Manager prerequisites

Before you install Enterprise Manager, make sure the following are true:

  • You have write access to two databases: one for the Statistics and Enterprise Manager Repository, and one for the Enterprise Manager project metadata. The Statistics and Enterprise Manager Repository should be in a database that is separate from your production data warehouse. The project metadata can be placed in the same database as other MicroStrategy project metadatas. Note the Data Source Name (DSN) for each.

    The Statistics and Enterprise Manager repository may be in any of these databases:

    • IBM DB2 UDB

    • MySQL

    • Oracle

    • SQL Server

    • Teradata

    • If you are using DB2 or Sybase for these, you must change the minimum page file size for the database to at least 16K. DB2 uses the page file size to determine the maximum size of a single row in the database. Some Enterprise Manager tables contain rows that require more than the default 4K.

    Before creating the DSN for a MySQL database using the Connectivity Wizard, you must obtain and install the ODBC driver for it.

    For a complete list of the versions of each database that are certified for use with Enterprise Manager, see the MicroStrategy Readme.

  • You have administrator privileges for the MicroStrategy projects that you want to monitor in Enterprise Manager. You must also have the Create Configuration Objects privilege for the project source in which you are creating the Enterprise Manager project.

    The Enterprise Manager metadata contains a user group called EMAdmin. Users in this group have all the privileges necessary to use all features of Enterprise Manager. It is recommended that any users who are to administer Enterprise Manager be added to this group.

  • To use the dashboards that come with Enterprise Manager, you need MicroStrategy Report Services. For information about the dashboards in Enterprise Manager, see Dashboard-style Documents.

    These dashboards are designed for use with MicroStrategy Web. If you are using MicroStrategy Web Universal, edit the dashboards and change all occurrences of Main.aspx in the links to mstrWeb.