Data Flow Details

Level 2 header

• Show object list: This option displays all the objects from which connections can be created.

  Operations that can be performed on these objects can be selected from here. They include Group, Info-Object, ADSO, Data Source, and Field.

  

• Add: This option enables selection between Data Source and File to create a dataflow.

• Publish: Updates to the dataflow need to be published to reflect the updated configuration in the system.

• Hide/Show Header: To show or hide the Level 2 header.

• Pin Sub header: When the header is hidden, it can be pinned using this option.

ADSO Detail

On clicking any block created in data, its ADSO details can be updated. The Name, Description, Purpose, and Details are values derived from its source but can be updated. For example, if a dataflow is created on Model Inflow, the name, description, and purpose will show the model name, description, and purpose. The Details will show the field ID-description pair of fields contained in the model. The inflow will show the input source (if applicable) for the current selection. The outflow will show the output (if applicable) to which the data from the current selection will be moved. Hence, connections between sources can be created using inflow and outflow.

Source to Target

The details of the connection can be viewed from the link between two objects. The Source From to Target From mapping contains three tabs: Field Mapping, Data Filter, and Advanced.

• Field Mapping: This tab contains Source to Target mapping, which defines how data from the source will move to the target. If data needs to be moved from one field to another, the field can be selected as such, and matching for members can be done using a Conversion Rule. Alternatively, a fixed member can be used to set the source. A script can also be used to customize the mapping.

• Data Filter: This option allows filtering source data by member; only filtered data is then moved to the target. The option to enable user input by field is also available here.

• Advanced: This tab contains three options: Distribution, Target Clear Filter List, and Advanced Process. Distribution enables moving source data to the target in a fixed allocation proportion by using a Data Enrichment Rule. Target Clear Filter List allows for clearing values from the target so that when the dataflow is executed multiple times, the values in the target do not keep aggregating. Advanced Process allows for the creation of a custom script to extract data.