BEAM Action group

This topic describes the Procedure Actions included in the BEAM Action group and their specific properties.

The BEAM Actions allow you to run existing Forecast and Clustering scenarios, as well as R Calculations which transfer data to Rserve, retrieve it, and store it into Cubes.

The BEAM Action group offers the following steps:

• Predictive analysis

• Clustering

• R Calculation

Predictive analytics

This step allows you to run a previously configured B.E.A.M. Forecasting scenario.
To configure this step, select the desired scenario from the “Select a scenario” dropdown list.
Enable the “Use scenario selection” option to discard the currently active selection and apply the selection configured in the chosen scenario. If the option is disabled, the Forecast will consider only the data related to the members in the active selection at the time when the step is executed.

The “Run mode” option is needed to run Predictive Analytics in one of the following modes:

Learning & forecast

The B.E.A.M. engine will always go through the learning phase of the source data first and then run the forecast scenario.

Forecast

The B.E.A.M. engine will only run the forecast scenario, based on the latest learning phase performed. This means that the forecast will not take into account any changes made to the source data since the last learning phase was performed.
Please note that if you want to select this mode, the learning phase for the selected scenario must have been performed at least once

See B.E.A.M. Forecasting for more information.

Clustering

This step allows you to run a previously configured BEAM Clustering scenario.
To configure this step, select the desired scenario from the “Select a scenario” dropdown list.
Enable the “Use scenario selection” option to discard the currently active selection and apply the selection configured in the chosen scenario. If the option is disabled, the Forecast will consider only the data related to the members in the active selection at the time when the step is executed.

See B.E.A.M. Clustering for more information.

R Calculation

This step allows you to transfer data to an Rserve instance, where it’s processed through R language. It then retrieves output data and stores it into Cubes in Board.

The R-Calculation Procedure performs the following actions:

1. Connects to an Rserve instance

2. Creates empty data frames defined in the "Stream Board Data to R" and "Read R DataFrame" sections and populates the dataframes defined in the "Stream Board Data to R" section with Board data

3. Executes the script (the script may populate the data frames defined in the "Read R DataFrame" section)

4. Runs the Data reader so that it reads data from R data frames defined in the "Read R DataFrame" section and stores it into Cubes in Board. When the process ends, the Procedure disconnects from Rserve.

The R Calculation step transfers data from Board to R in the form of dataframes. Those dataframes are processed through an R script and stored into new dataframes that are sent back to Board via a Data reader.
To configure the step, proceed as follows:

1. Configure the host Rserve.exe is running on (you will need the correct port number and login credentials)

2. Configure data that will be sent from Board to R

   1. You can extract Cubes, Trees, Entities, or Layouts. Various objects can be extracted in a single step

   2. Each extractor must be associated with a dataframe name

   3. Data will be read by R as dataframes with their specific name

3. Configure the R script in the dedicated text box using statements in R

4. Configure the readback process. You will need to configure a list of Data readers and dataframe names they’re associated with

When R starts running, Board will instantiate dataframes with the selected names, overwriting any existing objects with the same name in R.

How to configure Rserve

To configure a working environment, you’ll have to install R on a server (or virtual machine) and install the Rserve package from the CRAN (Comprehensive R Archive Network).
 
To do that, enter the following command on the R console:
 install.packages(“RServe”,dest=”<DEST_DIR>”)
 
To run Rserve, enter the following command on the R console:
Rserve(args="--RS-conf C:\\Dataset\\Rserv.cfg")

The configuration file is optional but, if used, may contain the following settings and information that are useful to Board:

1. Remote access: enabled

2. Authentication: enabled

3. A credential list with usernames and passwords

4. Port number

In the case of a Capsule Procedure, the Data model dropdown menu allows you to select the Data model on which the Procedure step will be executed, except in cases where the Procedure step has specific options that act on other Data models (for example, the "Save Pending Changes to Disk" step in the "Advanced Action Group" can be configured to act on all Data models or only on the Data model where the Procedure resides).

The runaway query protection system does not apply to "Extract" Procedure steps, the Dataflow step, the R Calculation step and all requests coming from Office Add-ins.