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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.