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 created. Enter all the information that we entered in Chapter 1, Getting Started with MicroStrategy and during the statistics configuration step, we should create a new DSN for the Enterprise Manager repository:

   

3. Then...