The external Logical SQL functions such as EVALUATE_SCRIPT, FORECAST, and CLUSTER feed input data to the standalone R-process or to Oracle R Enterprise. Therefore, to create analyses that include these functions, you must install either the R or Oracle R Enterprise external engine in your environment.
R is a widely used environment for statistical computing and graphics and can be used with many different data sources including external files or databases. Oracle R Enterprise is installed specifically for use with the Oracle Database, and makes the open source R statistical programming language and environment ready for use by Oracle BI EE.
See Advanced Analytics External Logical SQL Functions in Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition for more information about using these functions in analyses.
To create analyses using the advanced analytics external Logical SQL functions, you must install R and the required R packages.
If you are using Oracle Database, then see Installing Oracle R Enterprise and Required R Packages on the Oracle Database for more information.
You need to install the 3.1.1 R version distributed with Oracle BI.
You can find the R installer in the following Oracle BI environment location:
ORACLE_HOME/bi/bifoundation/advanced_analytics/r-installer.zip
The distributed R installation supports Linux (OLE 6 and OLE 7) and Windows (7 and 8).
Use the procedures in this section to install R and the R packages on UNIX platforms.
See Before You Begin the Installation for general prerequisite information.
Before you perform the installation, note the following important information and required tasks:
Run RInstaller.sh as root or using the sudo command. See the README.txt that is included in r-installer.zip for more information.
Locate proxy.txt in the RInstaller folder and edit it to include the proxy server details.
For OLE 7, before you install the Oracle R distribution, you need to install the TexLive and TexInfo RPMs.
The required RPM versions are: texlive-epsf-svn21461.2.7.4-32.el7.noarch.rpm and texinfo-tex-5.1-4.el7.x86_64.rpm.
Download the RPMs and install them using rpm -ivh <rpm_name>.
You must install the RPMs in this specific order: texlive and then texinfo.
To Install R on UNIX Platforms:
Note:
You must run the RInstaller in the following operation as a Root user.Open a command line, navigate to the installer's location, and enter the following to decompress and run the distributed R installer:
bash-4.1$ unzip r-installer.zip
bash-4.1$ cd RInstaller
bash-4.1$ ./RInstaller.sh
Usage ./RInstaller { install | installpackages | uninstall }
bash-4.1$ sudo ./RInstaller.sh install
To Install R Packages on UNIX Platforms
For UNIX platforms, after you have installed R, then from the same command line run the following command to download and install the required R packages (forecast, mvoutlier, randomForest, RJSONIO, and matrixcalc). Running this command also installs the OBIEEAdvancedAnalytics R package. The installer uses the proxy information from proxy.txt to download the packages from CRAN.
bash-4.1$ sudo ./RInstaller.sh installpackages
Use the procedures in this section to install R and the R packages on Windows.
See Before You Begin the Installation for general prerequisite information.
Before you perform the installation, note the following important information and required tasks:
Locate proxy.txt in the RInstaller folder and edit it to include the proxy server details.
Before you can install R on Windows, you must confirm that your Windows environment contains the wget and the unzip utilities. You can download these utilities from the following locations:
After you have installed R, then from the same command line run the following command to download and install the required R packages (forecast, mvoutlier, randomForest, RJSONIO, and matrixcalc). Running this command also installs the OBIEEAdvancedAnalytics R package.
.\RInstaller.bat installpackages
Oracle BI EE use the R engine included in Oracle R Enterprise instead of R. Oracle BI EE can use the Oracle R Enterprise colocation option, where the data can reside in the Oracle R Enterprise database. (In the non-colocation option, the data does not reside in the Oracle R Enterprise database.)
See Before You Begin the Installation for more information. If you are using databases other than the Oracle Database, then see Installing R and R Packages for more information.
Oracle BI EE requires that you install Oracle R Enterprise version 1.4 or 1.4.1.
Table 7-1 ORE Configuration and Support Matrix
| Oracle R Enterprise Version | Oracle R Enterprise Distributed R Version | Oracle Database Version |
|---|---|---|
|
1.4 |
3.0.1 3.1.1 |
11.2.0.3 11.2.0.4 12.1.0.1 |
|
1.4.1 |
3.0.1 3.1.1 |
11.2.0.3 11.2.0.4 12.1.0.1 |
Use the procedures in this section to install Oracle R Enterprise 1.4.1 on the Oracle database and to install all of the required R packages on Oracle R Enterprise.
To Install Oracle R Enterprise on the Database
A sample user such as ruser or rqueser is used for R Execution on the database.
To install Oracle R Enterprise 1.4.1 on the database follow the installation instructions in Oracle R Enterprise Installation and Administration Guide, Release 1.4.1.
For information about the steps in a typical installation of Oracle R Enterprise on a Linux server and a Windows client, see the "A Sample Installation of Oracle R Enterprise" in Oracle R Enterprise Installation and Administration Guide.
To Install R Packages on Oracle R Enterprise