KB47802: How to install R Integration Pack in MicroStrategy 9.x/10.x on Windows Operating Systems

1. Introduction:
In 2013, a new feature was introduced to deploy R Analytics to Strategy easily - R Integration Pack. The R Integration Pack is an evolution of previous FPWizard, an alternative approach to deploying analytics from R to Strategy. This brief video describes and demonstrates how the Strategy Intelligence Platform makes it easy to integrate with the open-source R analytics platform to build powerful advanced and predictive analytics. It then shows how to use these analytics alongside any other data in your environment in a visual, agile discovery environment.
 
 
2. Prerequisites:
Strategy

• Strategy version 9.2.1 or higher must be installed. An exception is that to deploy a new R analytic as a derived metric in Visual Insight requires version 9.3.1 or higher
• Strategy Architect is necessary for the one-time addition of the common RScript functions.

R

• R must be installed on systems that will execute the R analytics deployed to Strategy. This includes the Strategy Intelligence Server and any Strategy Developer clients that execute R analytics as derived metrics. R is not required on other clients such Strategy Web, Strategy Mobile, Strategy Visual Insight and Strategy Office since they are consumers of analytics deployed to the Strategy Intelligence Server.
• In Strategy 10.x, a 64-bit version of R must be installed and used.
• R can be installed from http://CRAN.R-project.org.
• If the R Analytic has dependencies on add-on packages that are not included standard with R, those packages must also be added to the R installation on the Strategy systems.

 
3. Download R Integration Pack
RScript Functions Installer: This installer adds a set of functions to Strategy that are used for executing analytics in R. These functions are required to execute your R analytic using Strategy. You can download the appropriate installer for your operating system from: http://rintegrationpack.codeplex.com/.
 
4. Installing the StrategyR Package for R
The StrategyR Package includes the R-based deployR utility, which is an interface used to prepare your R script for deployment to Strategy. To use deployR, the Strategy libraries must be installed and loaded. To install the package, open the R console from the R\R-3.x.x\bin folder in the R installation and execute the following command:

install.packages("StrategyR")

 

Once installed, the StrategyR library can be loaded by typing the following command in the R Console:

library(StrategyR)

 

After the library is loaded, one can launch the deployR utility by typing the following command in the R Console:

deployR()

 
The StrategyR library must be loaded in each new console session to launch deployR. For further information on how to use R with Strategy, consult the "Deploying R analytics in Strategy" section in the R Integration Pack User Guide.
 
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.