BI solutions provide reports, dashboards, and ad hoc queries for the whole organization. Usually, MicroStrategy implementation is huge and it requires many administration tasks such as installation, update, and configuration of MicroStrategy servers. In addition, the administrator ensures the high availability of systems as well as performance. Moreover, they should manage security, monitor the project's environment, and manage the project's life cycle. Finally, they are responsible for troubleshooting.
MicroStrategy provides rich functionality for managing and monitoring the whole system and makes the life of an administrator easier with automatization of routine administrator tasks. Usually, developers are responsible for deploying and running BI solutions. As a result, it is important for BI developers to understand the architecture of BI tools and know how to manage them.
In this chapter, we will learn about:
In Chapter 1, Getting Started with MicroStrategy we covered the installation process of MicroStrategy and MicroStrategy Web. Let's look at how we can manage MicroStrategy Intelligence Server. In order to see the status of Intelligence Server or to start, stop, or restart it, we should use MicroStrategy Service Manager. There are several options available to run MicroStrategy:
In order to run MicroStrategy, we could go to the home folder and run Service Manager.
These are the main commands for MicroStrategy tools:
./mstrcmdmgrw
: MicroStrategy Command Manager./mstrcfgwiz
: MicroStrategy Configuration Wizard./mstrconnectwiz
: MicroStrategy Connectivity Configuration Wizard./mstrdbquerytool
: MicroStrategy DB Query Tool./mstrdiag
: MicroStrategy Diagnostics and Performance Logging./mstrsuppappcfgwiz
: MicroStrategy Health Center Configuration Wizard./mstrsuppappgui
: MicroStrategy Health Center Center Console./mstrlicmgr
: MicroStrategy License Manager./mstrodbcadx
: MicroStrategy ODBC Administrator./mstrsvcmgr
: MicroStrategy Service ManagerIn order to run commands on a Linux environment, we should go to the home folder and run the name of the command:
# cd /mstr10/microstrategy_home/bin # ./mstrsvcmgr
In case we use putty to communicate with a Linux machine, we should run the Xming application in order to get a GUI: https://en.wikipedia.org/wiki/Xming.
MicroStrategy Service Manager will appear as shown in the following screenshot:
We can start, stop, and restart Intelligence Server as well as manage other services:
In order to manage MicroStrategy Web we should access the MicroStrategy Web Administrator page using the browser. Go to http://192.168.81.134:8080/MicroStrategy/servlet/mstrWebAdmin
.
This page allows us to:
Another important configuration is setting project defaults in order to set different options for all users, such as font, grid options, and so on.