Implementing Analytics in R for Use in MicroStrategy

The R Integration Pack requires a general understanding of the MicroStrategy Business Intelligence environment, such as creating metrics and using them on reports.

To develop your R analytics, ensure that you or your organization's system administrator has installed the MicroStrategyR package on your development machine.

When implementing analytics in R to use in MicroStrategy, consider the following:

• The inputs and outputs of the R analytics correspond to MicroStrategy metrics. MicroStrategy metrics represent values in a cell or column of data in a report, grid, dataset, and so on.
• The input and output variables can be either scalars (a single value) or vectors (one or more values). It is not possible to automatically pass tables, matrices, or data frames between MicroStrategy and R when using this approach. To mimic passing table-like structures between MicroStrategy and R, you can use the Repeated Parameter option for R analytics, which allows a varying number of inputs.
• In addition to passing values as metric arguments, a set of Boolean, numeric, and string parameters is available to pass into R scalar values that do not change from execution to execution. The script's working directory is also a special function parameter (see Defining an R Script's File Location and Working Directory ).
• Graphs and plots can be saved to the file system to be included in MicroStrategy documents and dashboards.
• The R workspace can also be saved to the file system.