This project has moved and is read-only. For the latest updates, please go here.

Returning Graph or Chart created in R to MicroStrategy

Aug 6, 2014 at 2:10 PM
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.
Aug 6, 2014 at 4: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:

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 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!