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:
- 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;
- Now we need to reconfigure Intelligence Server by adding an Enterprise Manager repository based on the MSTREM database that we just ...