Table Of Contents

  1. Business Intelligence Introduction
    1. The Need
    2. The Need - 2
    3. Roadmap
    4. Balanced scorecard and Key Performance Indicators
  2. Statistics for Business Intelligence- Theory
    1. Introduction
    2. Descriptive Statistics
    3. Shape
    4. Distribution
    5. Sampling
    6. Inferential Statistics
    7. Hypothesis Testing
    8. Inference for two populations
    9. ANOVA
    10. Chi-Square Tests
    11. Simple Regression
    12. Multiple Regression
    13. Multiple Regression Model Building
    14. Non parametric statistics
  3. Statistics for Business Intelligence- Implementation
    1. T-test, F-test and p-value
    2. Use of Statistics- Practical considerations
    3. Statistics-Examples
    4. Design Of Experiments - Introduction
    5. Examples using R- Comparing two conditions
    6. Examples using R- Analysis of Variance
  4. Oracle Business Intelligence Enterprise Edition (OBIEE)
    1. OBIEE - Introduction
    2. OBIEE - Creating a MySql Datasource
    3. OBIEE - Creating an OBIEE repository and importing a physical schema
    4. OBIEE - Creating logical model and presentation catalog
    5. OBIEE - Creating Hierarchy and drill down table
    6. OBIEE - Using a Column Selector for additional Drill down
    7. OBIEE - Creating a Rank measure
    8. OBIEE - Managing Cache
    9. OBIEE - Creating and Using dynamic repository variable
    10. OBIEE - Session variables and row level security
    11. OBIEE - Configuring the publisher/scheduler for MySql
  5. R
    1. R and Java - JRI using eclipse
    2. R and Java - JRI using eclipse on 64 bit machines
    3. R and Java - JRI using Netbeans
    4. R - Tutorial I (Basics and Vectors)
  6. Data Management
    1. Introduction to Data warehouse
    2. Dimensional Modeling

Friday, September 30, 2011

R and Java - JRI Using Netbeans

Setting up R-Java in Netbeans is pretty straight forward. For those who need a walkthough here are the steps.
  1. Download and install R (for this example version 2.12.2). install rJava package. 
  2.  Download and install Netbeans. 
  3. In Netbeans Create a new java project. we will call it RJava.
  4.  From the [R_HOME]>/library/rJava/jri/examples folder, copy the file rtest.java into the project.
  5. Create a library in NetBeans and add the following jars to the library. - JRI.jar, JRIEngine.jar, REngine.jar. These files are present in [R_HOME]/library/rJava/jri/. Here's how the project looks like
  6. Minimize Netbeans. Add R_HOME variable (right click my computer-> properties-> Advanced ->Environment variables) R_HOME should point to the location where R is installed.
  7. edit the PATH variable and append the following (i) [R_HOME]\library\rJava\jri and (ii) [R_HOME]\bin
That's it. Right click on rtest.java and click on 'Run File'.

3 comments:

jess said...

May i ask some question here. I am a beginner of R and Java. The JRI actually show that R and Java are able to interface each other, that mean R and Java is compatible? If i write some R code and i hope to run in Java, how it work? can u some me an simple example? like i write a R code which read the first line data of a file and then sum it and save in other file. I able to do this from R but how can i run the R code and show the result it java? how it interfacing?

Deepak said...

I am getting the following error. Please help
------------------------------------
Creating Rengine (with arguments)
Rengine created, waiting for R
#
# A fatal error has been detected by the Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x6c733cd8, pid=1488, tid=3220
#
# JRE version: 7.0_01-b08
# Java VM: Java HotSpot(TM) Client VM (21.1-b02 mixed mode windows-x86 )
# Problematic frame:
# C [R.dll+0x33cd8]
#
# Failed to write core dump. Minidumps are not enabled by default on client versions of Windows
#
# An error report file with more information is saved as:
# C:\Program Files\R\R-2.15.1\library\rJava\jri\hs_err_pid1488.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.sun.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

Goyo Castillo said...

Hi, I follow each step that is in your article, but i got this error:

Cannot find JRI native library!
Please make sure that the JRI native library is in a directory listed in java.library.path.

java.lang.UnsatisfiedLinkError: C:\Program Files\Java\jdk1.7.0_04\jre\bin\jri.dll: Can't find dependent libraries
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1939)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1864)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1846)
at java.lang.Runtime.loadLibrary0(Runtime.java:845)
at java.lang.System.loadLibrary(System.java:1084)
at org.rosuda.JRI.Rengine.(Rengine.java:19)
at com.spontecorp.rjava.rtest.main(rtest.java:61)
Java Result: 1

I'm running on Windows 7 64 bits, JDK 1.7_04, Netbeans 7.2

I read and apply every sujestion that I founded in google, but nothing, always the same error.

By, the way ¿it is normal that rjava was installed in a different directory where R is installed?. I used the command install.packeges("rjava") and was installed automatically in a different directory, any way I setted this VM option; -Djava.library.path=C:\Users\Casper\Documents\R\win-library\2.15\rJava\jri\x64.

I´ll appreciate any help

 

Free Blog Counter