Enterprise Manager system components

• Intelligence Servers

  The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables.

• Enterprise Manager

  Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server operates.

  • The Enterprise Manager project is the heart of Enterprise Manager. It runs against the Enterprise Manager data warehouse (as shown above). The project contains facts, attributes, hierarchies, metrics, filters, and prompts that are used in the reports and dashboards. These are designed to help users monitor and tune their entire MicroStrategy system. For detailed descriptions of each report and dashboard, see Reporting in Enterprise Manager.
  • The Enterprise Manager server directs Intelligence Servers to load statistics about the monitored projects into the statistics repository and runs the data load, which moves statistics data into the repository fact tables.
  • MicroStrategy Command Manager is used to schedule the Enterprise Manager data loads and maintain Enterprise Manager. You can also use it to monitor data load progress.
    • For steps on configuring Enterprise Manager via MicroStrategy Command Manager, see Configuring Enterprise Manager.

• Statistics repository

  The statistics repository contains data on the MicroStrategy system's usage and performance; the staging tables are populated by all projects that are configured to log statistics. For an explanation of the collected statistics, see the System Administration Help. For details about the contents of the statistics tables, see the Statistics Data Dictionary in the System Administration Guide.

• Enterprise Manager data warehouse

  The Enterprise Manager data warehouse is in the same database as the statistics repository. The data warehouse contains the following:

  • Lookup tables contain descriptive information about each object in the monitored projects, such as name, owner, creation date, folder path, and so on. In the data load process, the lookup tables are loaded with data from the staging lookup tables.
  • Statistics tables contain raw statistics data that has been loaded from the staging statistics tables by the data load process.
  • Fact tables contain data that has been processed and loaded from the statistics tables by the data load process.