MicroStrategy R Integration Pack

Overview

The MicroStrategy R Integration Pack enables business analysts to leverage the power of R inside MicroStrategy reports, dossiers, and visualizations.

R is an open-source, industry-leading tool for statistical computing and data mining.

With the MicroStrategy R Integration Pack, MicroStrategy computes derived metrics in R and returns the results to the MicroStrategy environment.

As an example, a user can create a forecast of revenue, as shown in the following visualization, by passing in the Revenue metric to a RScript function. The results appear as the Seasonal Forecast and Seasonal Forecast (No Outliers) metrics.

Because the R Integration Pack deploys R analytics as MicroStrategy metrics, deployment and management is easy. Additionally, the R Integration Pack includes a set of common R script functions, pre-compiled and ready to integrate into any MicroStrategy project.

Depending on your role, you perform one or more the following tasks to integrate or use your MicroStrategy software with R:

  • If you are a system administrator, install the R Integration Pack for R developers and MicroStrategy users.

    For detailed information on preparing your environments, and steps to install the R Integration Pack, see Installing and Configuring the R Integration Pack.

  • If you are a MicroStrategy analyst, use R analytics to analyze data. With the R Integration Pack installed and R analytics integrated with MicroStrategy, you can begin to analyze the R analytic statistical information in MicroStrategy by creating a metric. For detailed steps to create a metric that uses your R analytics, see Performing statistical analysis.
  • If you are an R developer, install the MicroStrategyR package, and develop your R analytics. An R analytic is a statistical analysis function that you write in R. To allow users to perform statistical analysis with an R analytic, you must implement the analytic as an R script, and integrate it with MicroStrategy using the deployR utility.

    For detailed steps and best practices to create R analytics for use in MicroStrategy, see Developing R Analytics for MicroStrategy.

  • The MicroStrategy R Integration Pack returns error and warning messages to help troubleshoot potential issues. Once you receive an error message you can search for it in Troubleshooting, which provides a potential cause and resolution to the problem.