MicroStrategy ONE

Creating the Enterprise Manager repository

The Statistics and Enterprise Manager Repository should reside in a database that is separate from your production databases. You can use an existing statistics database in your system or create a new database:

  • To use an existing database, note the Data Source Name (DSN) for it. This DSN is used later in the setup process, when you are prompted for the Enterprise Manager repository.
  • To create a new repository, follow the procedure below.

To create a new Enterprise Manager statistics repository

  1. Create a database to store your Enterprise Manager statistics repository. This is generally performed by your database administrator. This database must be one of those certified for use as a MicroStrategy statistics repository. For a list of certified databases, see the MicroStrategy Readme.
  2. Use the MicroStrategy Connectivity Wizard to create a DSN for the statistics repository. Note this DSN for later. You need it when creating the statistics tables and when you specify the DSN for the Statistics and Enterprise Manager repository.

    If you are upgrading from an earlier version of Enterprise Manager, performing the steps below drops the existing tables. To avoid losing this data, see the MicroStrategy Upgrade Guide for instructions on upgrading.

Set up the tables in the Enterprise Manager statistics repository

  1. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select Configuration Wizard.

    2. The Configuration Wizard must be run with administrator privileges. If you are not an administrator on the local machine, from the Start menu, instead of selecting Configuration Wizard, right-click Configuration Wizard and select Run As Administrator.

  2. On the Welcome page, select Create Metadata, History List and Enterprise Manager Repositories and click Next. The Repository Configuration: Repository Types page opens.
  3. Select the Statistics & Enterprise Manager option and clear the other options. Click Next. The Repository Configuration: Statistics and Enterprise Manager Repository page opens.
  4. From the DSN drop-down list, select the Data Source Name for the database that will contain your Enterprise Manager repository (the same database that you will use to log Intelligence Server statistics). This is the database and DSN you created in the first two steps of this procedure.
  5. Type a valid User Name and Password for this database. The login that you specify must have permission to create and drop tables in the database, and permission to create views.
  6. Click Next. The Configuration Wizard connects to the database.

    7. If Enterprise Manager tables already exist in this database, it prompts you for whether to re-create the tables.

    Clicking Yes deletes the existing tables and all information in them.

    To leave the existing tables in place, click No. To re-create the tables, click Yes.

  7. The Summary page lists the tasks that will be performed. To create the tables, click Finish. The process can take several minutes.

    Now that the statistics repository tables exist, you can configure projects to log statistics there. See Setting up projects to log statistics to the statistics database.