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 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:
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
. And generating them using R is made easier thanks to packages like
Hope this helps, and good luck!