Skip to main content

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.

    Image of Dataflow Object List

  • 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

Image of ADSO Details

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

Image of Source to Target Mapping

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 tab allows filtering source data by member; only filtered data is then moved to the target. The Enable User Selection toggle controls whether filter values are editable or locked at execution time.

    v26.08: The Data Filter tab for remote table to sheet/model dataflows supports two filtering modes: Fixed Value and Advanced Script. Users can choose the appropriate mode for each filter row, enabling both simple static filtering and complex dynamic filter conditions. Each row in the Filter column now displays a dropdown selector showing the active mode (FV for Fixed Value or AS for Advanced Script) alongside a text box. Each filter row maintains independent configuration with no impact on other rows.

    • Fixed Value mode (the default) allows users to enter specific dimension member values, including comma-separated values for multiple members (e.g., 2024.P01, 2024.P02). Leaving the text box empty applies no filter, allowing all members to be used during execution.

    • Advanced Script mode enables users to write advanced filter expressions directly into the text box (e.g., BETWEEN '2024.P01' AND '2024.P12').

  • 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.

Was this article helpful?

We're sorry to hear that.