R PROGRAMMING INTEGRATION WITH OBIEE

R program is an open source programming language, used for statistical computing and graphics. It is mainly used by statisticians and data miners to develop statistical software for analysis of Data. The source code in R software is written in C, Fortran; and R.R has a command line interface along with different Graphic front ends.

Unique features of R include linear and nonlinear modelling, classification, time series analysis, clustering and many others. Many functions in R Programming are developed in R and at run time C, C++ and Fortran code can be linked and used to develop any customizations.

Advanced users can directly write C, C++, Java, to customize R objects. Another advantage of the R is its Static Graphics which can produce mathematical symbols and quality graphs. R is an interpreted language and can be accessed through a command line interpreter. R includes Data Structures like Vectors, Matrices, data frames, arrays and lists. By default, R provides a set of packages which can be used, in addition to that user can create different packages which allows in different reporting tools, graphic design and other customizations. As R is an open source language, many of the big companies are integrating R with other applications like Hadoop. The latest version of R is R-3.4.1

OBIEE integrated with R:

ORE (Oracle R Enterprise) embedded R Executing SQL Interface helps in integrating with OBIEE RPD and Dashboards. R script which is best for statistical data analysis can be integrated with OBIEE to have the best analysis between processes or products using distribution analysis and weighted t-tests, p-value scores, returning numerical results and computations. OBIEE 12C comes with embedded R functions like Trendline, Regression, Outliers and Clusters. To use these functions, we need to install R software and additional R packages.

R-Trendline-Adding a new trendline in the Graph

R-Regression- This function helps in relationships within the data.

R-Outliers- This function helps in identifying the exceptions in the data.

R-Clusters- This function will attempt to form groups within the data. This helps business in analyzing the data in an efficient way.

Conclusion:

Oracle R Enterprise can be integrated with Oracle database and can be used efficiently in K12, which helps in advanced analytical options with multiple Images, structured data and advanced calculations. These R Functions in OBIEE 12C integration have been used for our client K12 which has benefitted them to efficiently display data in the Graphs.