What is an Analysis Action?

An 

Creating Analysis Actions

1. Click and drag the 

   Insert excerpt
   _run_analysis_icon _run_analysis_icon nopanel true

    Analysis action icon from the toolbar onto the canvas
2. Enter a name for the Analysis action, then select Create Action
3. In the Analysis action 

   Insert excerpt
   _property_settings _property_settings nopanel true

    on the right, populate the following details, as required

Tables

Add tables to this list to run analysis on when the Actionflow is triggered. Analysis is ran simultaneously on all tables in this list.

• To add a table, in the Tables section click the 

  Insert excerpt
  _tables _tables name icon nopanel true

   icon to open a list of tables for the application in the Repository
• Drag a table from the list into the Tables section

Input Parameters & _Context 

Attributes mapped into Analysis actions can be used in the attribute expressions on the table using the internal variable _context, e.g._context.AttributeName.

To do this, add attributes to the Input Parameters section of the Analysis action properties using the same name as in the Expression for the attribute on the table. 

For example, if a table relies on the expression '_context.Name', an attribute called 'Name' can be added to the Analysis action. The value for this can then be mapped to this attribute from any preceding connection.

Example Uses

If your table contains a Last Updated attribute, you can use Input Parameters and the _context variable to map an Output Attribute containing the expression now or today from a Calculate action onto the Input Parameters on the Analysis action, and then into the table using the _context variable.

Advanced

When an Analysis action is used in an Actionflow, the records are processed in parallel. While we can control the order records exit an Analysis action, we cannot control the order they are processed.

When disabled (default), records are processed in the order they are provided.

Worked Example

Here is a worked example using the Retail Data (available from the Learning Centre).

In this example, we are using:  

• A Shop Stock screen containing a grid of the Shop Stock data, a pie chart of the Shop Stock data and a grid of the Shop Departments data  - this screen was created using the Multi-Tile template

Import Bulk Stock

In this example, we'll set up an Actionflow that runs analysis on a table importing a bulk stock delivery and we'll map values into this data. As an optional process, we'll combine this bulk stock delivery with our existing stock and display this on the Shop Stock screen. 

Review Tables

1. Open the Analysis Model, Actionflow Intermediate Data
2. Click on the tables to review the data
   1. The Shop_Stock_Processed table contains the data on your Shop Stock screen and ERD
   2. The Shop_Stock_Additional_Processed table represents a new delivery of stock into your warehouse and requires combining into main stock data
      1. This is the table we will run analysis on as part of this example
   1. 1. Note that this table has a Period of Transactional, which will allow us to run analysis on it via the Actionflow

Actionflow Setup

1. On the Shop Stock screen, add an Actionflow to the  icon
2. Set the Input to 

   Insert excerpt
   _actionflow_on_click _actionflow_on_click nopanel true

3. Add a

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action to the canvas and connect the 

   Insert excerpt
   _input _input nopanel true

    node to it
4. On the Calculate action, add two Output Attributes:
   1. Name: distributionCentreID
      1. Type: Integer
      2. Expression: 1001
   2. Name: distributionCentre
      1. Type: String
      2. Expression: "North"
5. Add a 

   Insert excerpt
   _action_analysis _action_analysis nopanel true

    action to the canvas
6. On its Properties, in the Tables section, click the 

   Insert excerpt
   _tables _tables name icon nopanel true

    icon
   1. Drag across the Shop_Stock_Additional_Processed table from the Repository to the Analysis action properties
7. Connect the Calculate action to the Analysis action and map across both attributes
   1. Click on the Analysis action to view these two attributes in the Input Parameters

Table Attributes Setup

1. On the Analysis Model, Actionflow Intermediate Data, click on the table, Shop_Stock_Additional_Processed
2. Double-click on the attribute, distributionCentreID, and change the Expression to _context.distributionCentreID
   1. This is then referring to the attribute setup on the Calculate action
3. Make the same change for the attribute, distributionCentre, so it too is referring to the attribute set on the Calculate action
4. Save the Analysis Model

At this point, you can run the Actionflow and see the results of the Actionflow in the Shop_Stock_Additional_Processed table, which will now contain 50 records, along with the values for Distribution Centre ID and Distribution Centre as set in the Calculate action.

Optionally, follow the additional steps below to combine the new stock data with our existing stock data and display it on the Shop Stock screen.

Combine Data & Display (Optional)

1. On the Actionflow, create a 

   Insert excerpt
   _action_view _action_view nopanel true

    action with the Primary Table, Shop_Stock_Additional_Processed, and connect the Analysis action to the View action
   1. In its Properties, in the Data Retrieval Options section, set the Data Range to Latest
      1. This will ensure that this data isn't continuously added if the Actionflow is run repeatedly
   2. For the Output Attributes section, click the 

      Insert excerpt
      _attributes_icon _attributes_icon nopanel true

       icon and drag across all attributes
2. Create a 

   Insert excerpt
   _action_save _action_save nopanel true

    action to save the data to the Shop_Stock_Processed table
   1. In its Properties, in the Basic Settings section, set the Type to Insert and

      Insert excerpt
      _toggle_on _toggle_on nopanel true

       toggle on Auto Save Attributes
3. Connect the View to the Save action and map across all attributes
   1. 

4. 
   

   Expand
   title Checkpoint

   
   

5. On the Shop Stock screen, run the Actionflow by pressing  Import New Stock
6. The additional 50 records will be added to the Available Stock grid

Image Modified