Returning Graph or Chart created in R to MicroStrategy

Aug 6, 2014 at 1:10 PM
Hi,
I have a question that is it possible to create a chart in R and display it in MicroStrategy Report..And what is a Sankey Report and how it can be created and to be displayed in MicroStrategy..
Thanks in Advance.
Coordinator
Aug 6, 2014 at 3:39 PM
The data in MicroStrategy Reports can be viewed as a grid, graph or grid/graph using the MicroStrategy graph engines. To display a chart created using R (or any other source), instead use a MicroStrategy Document.

First, save the chart/graph/image from R as a file in the file system (JPEG, GIF, BMP, etc.). This post from R-Bloggers contains more details on how to do this: http://www.r-bloggers.com/automatically-save-your-plots-to-a-folder/.

Next, create a MicroStrategy Document and add an image/picture container to display the particular image file you saved in the step above, along side the report/grid that contains the metric which executes the R analytic used to create the image file. Any time you run the report, the image will be updated as the document is created.

A discussion of Sankey diagrams is a bit beyond the scope of this discussion forum, but a quick query using http://rseek.org/ revealed several packages and related posts that describe Sankey diagrams. For details on Sankey charts, see Wikipedia. And generating them using R is made easier thanks to packages like googleVis, riverplot and others.

Hope this helps, and good luck!