Expansion - EcoSys - 3.0 - Help - Hexagon PPM

EcoSys Connect Help

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
3.0

The expansion processor de-summarizing data into multiple records. It takes the entity set and creates rows based on the settings. 

The following fields need to be configured:

  1. Enter the following parameters in the Basic section,

    1. Expanded Attributes Name -The selected fields from the entity that will be expanded on. For each row, a new row will be created per column selected. Any columns not selected here will remain as is on these new rows. 

    2. Target ‘Name’ Attribute Name - The name for the new field added to the entity set which will have the expansion field name as a value.

    3. Target ‘Value’ Attribute Name - The name of the new field added to the entity set which will have the expansion field value as a value.

    4. Generate Row for Null Value - If there is a null value in one of the Expand Attribute Names fields, an expansion row should be created

      For example, configure the Expansion processor as follows:

      1. Set the Expand Attribute Names set to IsBase,InstrumentLenght1SiValue

      2. Set the Target ‘Name’ Attribute Name to ‘FieldName’

      3. Set the Target ‘Value’ Attribute Name to ‘FieldValue’

      4. Uncheck the Generate Row for Null Value.

        Consider the following rows in the entity set.

        The processor would display the following result: