MicroStrategy Enterprise Manager prerequisites

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

• You have write access to the databases containing the Statistics and Enterprise Manager Repository and 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.

  If you are using DB2 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.

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

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

• 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.

  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.