Deploying Enterprise Manager and collecting statistics

MicroStrategy Enterprise Manager is just a project on top of MicroStrategy server that includes its own schema and lots of reports in order to monitor and analyze Intelligence Server statistics. Let's install Enterprise Manager:

  1. We should create a new database for Enterprise Manager. Now we should choose Oracle. MicroStrategy Enterprise Manager doesn't support PostgreSQL. Let's create a new Oracle schema using SQL Developer:
          CREATE USER MSTREM IDENTIFIED BY HAPPY2016 default tablespace USERS; 
      GRANT UNLIMITED TABLESPACE TO MSTREM; 
      GRANT ALL PRIVILEGES to MSTREM;
  2. Now we need to reconfigure Intelligence Server by adding an Enterprise Manager repository based on the MSTREM database that we just ...

Get Mastering Business Intelligence with MicroStrategy now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial