My Oracle Fusion Middleware Experiments

Purpose This blog post is intended for all the Oracle Analytics Server Administrators, Developers, Data Model designers, DW architects. Prerequisites Installation of  Oracle Analytics Client Tools  5.5.0 on Windows 64bit Download the OAS Client Tool Step 1: Uncompress the downloaded zip file  OAS-5.5.0-bi_client-win64.zip use any unzip tool which runs on a Windows machine. Step 2 : Open a new CMD and 'Run as Administrator' enter the .exe file hit ENTER key C:\work\data>OAS-5.5.0-bi_client-win64.exe Step 3: Launches install wizard Wizard step 2 Wizard step 3 Wizard Step 4 Wizard Step 5 Wizard Step 6 (Development of RPD or online RPD connections required this configuraiton) Wizard Optional Step "Add" ODBC configuration Select "Oracle BI Server DSN Configuration" is specific to your Datasource to which you have target to use, stored as Data.Source.. (This step is must for Design Data Model and Develop new RPD files) Troubleshooting If you run the installer f...

Installing R and R Packages on OAS 5.5.0 The main objective of this post is to give step-by-step "Installing of R and R-Packages" in an Oracle Analytics Server (OAS) 5.5.0. Similar steps were followed earlier on OBIEE environments as well. Here I have the target installing platform is "Oracle Linux" same steps will work for all RHEL flavors. What is R? R is open-source programming language and it is specially designed as scripting environment for statistical computing and Visualization graphics. R programming evolving since 1994, as an alternative to SAS, SPSS, and other proprietary Statistical environments.  R Environments with a rich set of packages to enhance productivity in businesses such as :  Spatial Statistics  Financial Market analysis  Bioinformatics  Social Network analysis What is the purpose of this installation? In the data Analytics, there is huge scope for external Logical SQL functions such as "EVALUATE_SCRIPT", "FORECAST...