Creating the Enterprise Manager project

The Enterprise Manager metadata contains all the facts, attributes, hierarchies, metrics, filters, and reports that are predefined as part of the Enterprise Manager project. The Enterprise Manager project can be created on a machine with your production metadata. It is installed in the form of a MicroStrategy Object Manager Package. You can create a new metadata database or use an existing metadata database.

You can automate the creation of the Enterprise Manager project by using a Configuration Wizard response file. For instructions on creating the response file, details about the settings in the response file, and steps on running the response file, see Using a response file to create an Enterprise Manager project.

To create a new metadata database

1

Create a database to store your Enterprise Manager metadata. This is generally performed by your database administrator. This database must be one of the databases certified for use with MicroStrategy metadata. For a list of certified databases, see the MicroStrategy Readme.

2

Use the MicroStrategy Connectivity Wizard to create a Data Source Name (DSN) for the metadata. Note this DSN for later. It is needed when creating the statistics tables and when you specify the DSN for the Metadata Location.

To access the Connectivity Wizard, from the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select Connectivity Wizard. For detailed instructions on using the Connectivity Wizard, see the Installation and Configuration Help.

To create the Enterprise Manager project

1

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

2

Select Create Enterprise Manager project and click Next. The Enterprise Manager Project Creation page opens.

3

Type in a valid User Name and Password to connect to Intelligence Server metadata.

4

Click Next. The Enterprise Manager Repository page opens.

5

From the DSN drop-down list, select the data source name of the Enterprise Manager repository.

6

Type in a valid User Name and Password to connect to the database.

7

Click Next. The Summary page displays the tasks that will be performed.

8

Review the information and when you are ready, click Finish. The process can take several minutes.

Enterprise Manager is now initialized in your system; you can connect to it using MicroStrategy Command Manager, select which projects to monitor, and schedule the data loads. For steps on these, see Configuring Enterprise Manager.