Project Description

CLICK HERE for the R Integration Pack User Guide

CLICK HERE for the R Script "Shelf" that contains ready-to-go R Analytics


The MicroStrategy R Integration Pack makes it easy for anyone to deploy sophisticated R Analytics to any user, anywhere, any time. Thanks to an architecture designed with extensibility at its core, MicroStrategy delivers an innovative R integration that sets the standard for simplicity, scalability and performance. Now virtually any algorithm, statistic or analysis can be added to the industry's leading Business Intelligence platform thanks to third generation features no other BI product can match:

  • No R left behind: Any R Script, all R packages
  • No Servers Required: R Scripts execute inside the BI engine just like our native analytics
  • Data from MicroStrategy, Results from R, plus easy-to-use function parameters that give end-users process control without any coding required
  • High-Performance, COM-based Execution
  • Centralized RScripts Repository enables fool-proof deployment of analytics from development to production.
  • R Scripts are referenced, not embedded, making for easy maintenance and version control
  • R Scripts errors caught and logged
  • One Script, Multiple Execution Modes
  • Support for Windows, Linux, AIX, Solaris
  • Transparent R Environment: Persist/Load Files, Objects & Images, Unattended Package Installation
  • Leverages all MicroStrategy platform features, including structured and unstructured data, in-memory cubes, re-usable metadata objects, visual data discovery, enterprise-level security and more, all seamlessly delivered via web and mobile, cloud and office.
  • Available at no extra cost

R Programmers will be impressed with the drag-and-drop deployR() utility that makes capturing the analytic's signature quick and easy.

But you don't need to know R to get started! Thanks to our on-line collection of "Off-the-Shelf" R Analytics, any MicroStrategy user can inject R analytics to solve common business problems. Included with these analytics are powerful new tools like the predictive algorithms for ARIMA, Neural Network, Random Forests, Stepwise Linear and Logistic Regression algorithms, a cool Pairwise Variable Correlation visualization and many more. All these analytics leverage MicroStrategy's best practices and enterprise-ready robustness features. Data scientists, and especially Analytic Amateurs who want to learn by example, are welcome to adapt and re-purpose any of the of the source code provided with these Off-the-Shelf scripts.

Getting Started

Conceptually, think of the R Analytic as a black box with an R Script inside. MicroStrategy doesn't need to know much about the R Script in the black box, it only needs to know how to pass data in and, after the script has executed in the R environment, how to consume the results.


There are three main steps to using the R Integration Pack:

  1. Installation: A one-time install of R and the R Script functions into your MicroStrategy environment, performed by system administrator types or anyone with permissions to install and configure software on the system.
  2. Deployment: Delivering results from R to any BI User is what the R Integration Pack is all about. Thanks to the ever-growing collection of "Off-the-Shelf" R Scripts, you don’t need to know anything about R code, no programming is required. If you can create a metric in MicroStrategy, and practically anyone can, then you can deploy an R Analytic as well. It's really that simple!


For more details, please see the R Integration Pack User Guide

Last edited Sep 8 at 3:13 AM by tzink, version 51