Advertisements

Exploring the RStudio Interface

In this post we will explore the RStudio interface.  This is where you will manage your R environment, issue commands for processing and analyzing data, create scripts, view results, and much more.  Below is an image of the default RStudio interface.

RStudio_Environment

On the left:
Console – the window where you enter commands, and where output is displayed.

On the top-right:
Environment tab – shows the variables and values created through the console
History tab – shows the history of past executed commands

On the bottom-right:
Files tab – displays folders and files from the file system, from which you can select files, set working directory, create folders, copy and move folders and files, and more.
Plots tab – displays the plots that have been created and allows for you to export them.
Packages tab – displays all the packages currently installed and available.  Loaded packages will have the checkbox checked and packages must be loaded before they can be used.
Help tab – useful for getting help about R and R packages, and keyword search is available which can be very helpful when you don’t know exactly what you are looking for.
Viewer tab – can be used to view local web content, such as, static HTML files written to the session temporary directory or a locally run web application.

On the top-left (when a script is created or opened):
– Script pane and tabs – When you create or open a R script, it will create a new pane area in the top-left of the application window, and the Console pane will get shifted down to the bottom-left area.

RStudio_Environment_with_Script_pane

A new Script tab will open in this pane for each new script opened or created. From this window, you will be able to run your script line by line or in its entirety, among many other functions.

Thanks for reading!

Advertisements

Installing, Loading, Unloading, and Removing R Packages in RStudio

R has thousands of packages available for statistics and data analytics, but before you can use them, they need to be installed.  In this post I cover installing, loading, unloading, and removing R packages in RStudio. In these examples, I use the ggplot2 package – a popular graphics and visualization package in R.  Wherever you see ggplot2 in the examples below, you can replace it with the package you want to perform these actions on.

To install a package via the User Interface

In RStudio, select Tools -> Install Packages from the main menu, or click Install in the Packages tab on the bottom-right.
R_Installing_Packages_ToolsMenu

The Install Packages dialog appears.
R_Installing_Packages_ToolsMenu_InstallDialog

Start typing the name of the package you want to install, and a list of all packages that start with the letters you have type will show up in the selection list.
R_Installing_Packages_ToolsMenu_InstallDialog_PartialNameFind

Select (or type the full name of) the package you want to install, ensure that “Install dependencies” is checked, and click “Install”.
The statement will be automatically entered and run as shown below.
R_Installing_Packages_ToolsMenu_Output

And the output will show if the package is successfully installed.
R_Installing_Packages_ToolsMenu_Output2

At this point, you will be able to see the package in the list in the Packages tab on the right.
R_Installing_Packages_ToolsMenu_Output3

To install a package via script
Instead of using the user interface (menu), you can also install packages directly via script.

install.packages("ggplot2")

See script statement below.  And as before, the package shows in the Packages tab.
R_Installing_Packages_Script

After a package has been installed, it needs to be loaded before you can use it.

Loading and Unloading a package (via user interface or script):

To load a package you can simply check the checkbox beside the package name in the Packages tab – as shown by the yellow box highlight below.  This will automatically enter and execute the command shown with the yellow arrow.

Or you can enter the script, by entering the command as shown with the green arrow:

library("ggplot2")

As an alternative, the require(ggplot2) command will also load the package.

To unload the package, you can simply uncheck the checkbox beside the package name in the Packages tab, or enter the command shown by the red arrow:

detach("package:ggplot2", unload=TRUE)

R_Loading_Unloading_Packages You will notice that after running the detach command, the Package checkbox will not be checked (will be unchecked).

To remove (uninstall) a package (via user interface or script):

To remove a package, you can simply click the “x” icon shown to the right of the package in the Packages window. See the yellow box highlight beside ggplot2 below.

Or you can run the script command as shown below in the Console window.

remove.packages("ggplot2")

R_Removing_Packages_Script_or_GUI

The below shows the output after removing a package.  You will notice that the package is no longer in the Packages list on the right hand side.  In this example, ggplot2 is no longer in the list of packages.
R_Removing_Packages_Output

An advantage of using the script option instead of the user interface methods to perform the above actions is that you will have a history of what you have done.

Thanks for reading!

Installing RStudio on Windows

RStudio is an open-source integrated development environment (IDE) for R. It also has commercial versions with expansive capabilities available (at a cost).  It runs on the desktop with multiple operating systems, or in a browser connected to a RStudio server.  RStudio includes a console, syntax-highlighting editor that supports direct code execution, as well as tools for plotting, history, debugging and workspace management. This post covers installing RStudio.  Note that R needs to be installed first – see this post for installing R.

To get started, go to http://www.rstudio.com.

Under RStudio, click Download.
RStudio_download

Choose the desired version of RStudio.  You will likely want the “RStudio Desktop (Open Source License)” version. On the same page, you will be able to read about the various options available – free and pay versions.
RStudio_choose_version

This will bring you down in the page to the installers.  Choose the installer that is appropriate for you.  In this example, we are installing on Windows, and so we chose the “RStudio 1.0.153 – Windows Vista/7/8/10” version.  Note: RStudio requires that R is installed.  If you have not already installed R, do so first (see this post for Installing R).
RStudio_choose_installer

After the download is complete, run the exe by double-clicking on it.
RStudio_install_run_exe

Click Next at the Welcome screen.
RStudio_install_welcome_1

Choose the install directory, click Next
RStudio_install_location_2

Chooses a Start Menu Folder, click Install
RStudio_install_start_menu_folder_3

Installing …
RStudio_install_installing_4

Complete the installation.
RStudio_install_complete_5

Run RStudio
RStudio_install_RStudio_icon

RStudio IDE
RStudio_install_run_RStudio

You will notice that the left window “Console” is the same as the “R Console” window in the stand-alone R installation.  This is because RStudio is built on top of R.

Good luck on your R journey!

Installing R on Windows

R is an open source software platform for data manipulation, statistical computing, calculation, analytics, and graphics.  It provides a wide variety of statistical/mathematical and high-quality graphical capabilities.  Some of the statistical capabilities include linear and nonlinear modeling, classical statistical tests, time-series analysis, classification, and clustering, and more.
You will find R useful in Analytics and Business Intelligence environments where data needs to be analyzed to uncover patterns or for better understanding and help make predictions and decisions.
In this post, we cover the installation of R.

To get started, go to http://www.r-project.org.

Click the “download R” link (underlined in yellow below).
rprojectorg

Choose the CRAN (Comprehensive R Archive Network) mirror location closest to you.
ChooseBestLocation

Choose the version for your install computer’s operating system (OS). In this example, we are installing on Windows – so we chose “Download R for Windows”.
R_ChooseOS

Assuming this is your first install, click “base” or “Install R for the first time”.
R_Install

Then, click “Download R 3.4.1 for Windows” (or whatever the appropriate version is at the time)
R_download

After the download is complete, go to the download directory, and double-click the R exe to run it.
R_run_exe

Choose your language
R_install_lang

Click Next
R_install_welcome_2

Review the license agreement, click Next
R_install_license_3

Accept the default directory or enter/select a new one.
R_install_dir_4

Select the components you want.  If your PC is 32-bit, then unselect 64-bit if it is shown as an option.  If your PC is 64-bit, you can install both 32-bit and 64-bit (default) or choose one of them.
R_install_components_5

Choose No and click Next (unless you want to customize the startup options for R, but this can be done later)
R_install_startup_6

Click Next
R_install_start_menu_folder_7

Choose Icon and Registry options
R_install_additional_8

Installing
R_install_installing_9

Click Finish to complete the installation
R_install_complete_10

Desktop and Quick Launch icons
R_install_desktop_icons     R_install_quicklaunch_icons

Run R.
R_install_runR

Next, we’ll cover installing RStudio.

Good luck on your R journey.

Installing the OBIEE 12c Client on Windows

Installing the OBIEE 12c Client is straight forward.  Here are the steps.

Visit the Oracle Business Intelligence page on the Oracle website. Go to the Downloads tab.
OBIEE12c_Downloads
Select the version of Oracle Business Intelligence (OBI) 12c that you want to install.

When the version download page appears, select “Accept the License Agreement”, and then under “Oracle Business Intelligence Developer Client Tool (12.x.x.x)”, click on “for Windows x86-64 bit” – (see green arrows below)
AcceptLicenseAgreement_ThenDownload

Download and save the file to your computer.

After the download is complete, go to the downloaded zip file … bi_client_12.x.x.x.x_Windows.X64.zip
OBIEE12C_ExtractZip
Right-click on the file and select Extract All.  Or extract using another method.

After the executable has been extracted, right-click on it and “Run as administrator”.
OBIEE12c_RunAsAdministrator

This will start the installer

OBIEE12c_PreparingTheInstaller   OBIEE12c_Step0of5

Click through the next 5 steps

OBIEE12c_Step2of5

OBIEE12c_Step3of5

OBIEE12c_Step5of5

After the installation is complete, run one of the applications: Start -> Oracle Business Intelligence Client -> Administration
OBIEE12c_Run

The Oracle BI Administration Tool should open and be ready for you to use it.
OBIEE12c_BIAdministrationTool

Thanks for reading. Hope this helps.

Issues identified after upgrading from OBIEE 11g to OBIEE 12c

After upgrading our Development environment from OBIEE 11g to OBIEE 12c, we encountered some issues.  This post describes some of the issues we have identified so far and how we resolved them.

  1. Images are missing.
    • This was fixed by moving all images to the new OBIEE 12c images directories.
  2. Dashboards with hidden pages are broken.
    • This was initially resolved by moving the hidden pages to the end of the dashboards list in the dashboard properties dialog.
    • We later discovered that there is an Oracle patch for this, and applying it resolved the issue.
  3. Colors on graphs are different.
    • This will need to be resolved by configuring reports with specific colors.
  4. Some of the graphs scales are changed
    • This was resolved by setting the appropriate graph scale properties.
  5. The order of the items in the legend on some graphs changed
    • This was left as is. It seems there is no “resolution” for this (no way to make it exactly as it was before), but it seems to be ok as is.
  6. Prompts shifted
    • This was resolved by setting the dashboard column objects’ (that contain the prompts) width properties
  7. Dashboard Pages missing after upgrade
    • This was resolved by changing and resaving the dashboard pages in 11g and re-migrating the catalog to 12c.
  8. In some cases, the Subject Areas do not show (missing) in Manage Privileges.
    • A restart of the services resolved this.

 

I will keep adding to this list as new issues are encountered and resolved.

Good luck with your upgrade!

 

Dashboards with hidden pages behave strangely after upgrade to OBIEE 12c

After upgrading from OBIEE 11g to OBIEE 12c, some dashboards behaved strangely.  Things that were wrong include:

  • unable to edit the dashboard from the dashboard page
  • unable to see some of the dashboard pages / tabs
  • click on one tab and it takes you to another tab

It turns out that all the dashboards affected by this behavior were dashboards with hidden pages / tabs.

There is a workaround for this.  The workaround is – move all the hidden pages / tabs to be at the end of the list of dashboards pages in the dashboard properties view.  After doing this, the dashboard will work as expected.

There is also an Oracle patch for this bug.  It is Patch # 23511448.  As of the time of this post, it was still an interim patch and not yet a production patch.  From our perspective, the patch seems to have resolved the issue without causing any new issues.  However, since it’s still an interim patch, apply at your own risk.

Thanks for reading.