Rscripts for Logistic Regression

Apr 12, 2015 at 4:36 AM
Hi ,
I have recently started intergrating R with MicroStrategy, I was able to find probabilities using R scripts in metrics, but i was not able to do ROCR curve, confusion metrix and AUC
is there a way to get them all inn MicroStrategy, Kindly help


Thanks in Advance,
Gayathri
Apr 13, 2015 at 1:04 PM
Hi Gayathri,

I think the simplest way to do this would be to have the R script save the 'workspace', and then go back in after the report has run and load up the workspace in R and take a look at the diagnostics. It will be saved as an .Rdata file.

http://www.statmethods.net/interface/workspace.html

A quick Google search for the terms you mentioned (AUC, confusion matrix, and ROCR curve) and 'R' will bring up lots of links to StackExchange or StackOverflow for the actual code to create the objects once you're back in R.

If the user requirements are to get all of the model diagnostics into some kind of dashboard in MicroStrategy, I think the best way to do that would be to tweak the R script to export images, and then have links to those images in the document or dashboard.

Hope this helps!

Erik