Analyzing System Information

MicroStrategy supports importing data from search indexes, also known as search as a source. For example, you can examine data patterns by correlating events recorded in multiple sources, such as web access logs, error logs, and so on. Using search to explore your data provides a quick and intuitive way to access and analyze subsets of your data.

To support this type of system information analysis, you need to configure the following system:

• Log management: Your log files for your system must be retrieved and combined. Various tools, such as syslog-ng, are available to provide this type of log file management. Common log management tasks include formatting, classifying data, correlating related messages, logging directly into a database, and so on.
• Log collection and search creation: Once the data from your logs has been retrieved, this data must be stored and put through ETL processing to create a standard log format. This data can then be turned into an index and search system. Tools such as Apache Flume™ and Apache Solr™ can be used together to provide a system for log collection and search creation.
• Log analysis: With your log files combined into a search system, you can integrate the search system into MicroStrategy. Along with performing search analysis on text data, you can also take advantage of all the standard MicroStrategy reporting, dashboarding, and analysis capabilities.

  You have error logs for server stored in your search system, and you have performance data for that same server stored in a database. You can include these two collections of data on a single dashboard for analysis in MicroStrategy. For steps to integrate your search system into MicroStrategy using Data Import, refer to the MicroStrategy Web Help.