Context

A function that collect data of other functions and unify them in one table. Results depending on the selected Option. It is possible to chose between the Collection Category Aggregation, Last, Massjoin, Union and Union Aggregation.

Prerequisites

As a prerequisite, a function with data (Source Data) under the Environment function must be provided as input to be collected using the Collection Function.

Collection Category: Last

In this Collection Category only Data from the last input function is shown.

Steps

1. Select “Last” as Collection Category in the ”Settings” Roadmapstep.

2. Click the “Collection Functions” Roadmapstep.

3. Select the Data Input. Therefore you can use the Add Button to add a function from the environment or click the Sync Button to add every function, which is below the Collection Business Function.

4. If you like to remove a function, click remove.

5. If you like to change the order of functions mark one and click the move up or move down Button.

6. If the changes are meant to be preserved, choose Save.

7. To generate, choose Generate.

8. For a preview, choose Test.

Scenario: Last

Source Data

You are able to add many functions in the second step. In this three Input functions are added.

Only the last Input Function Data is displayed.

Collection Category: Mass Join

In this Collection Category Data is collected depended on the fields you choose.

Steps

1. Select “Mass Join” as Collection Category in the “Select” Roadmapstep.

2. Select one or more fields, which are the characteristics for collecting the data.

3. If you like to change the order of fields mark one and click the move up or move down Button.

4. Click the “Collection Functions” Roadmapstep.

5. Select the Data Input. Therefore you can use the Add Button to add a function from the environment or click the Sync Button to add every function, which is below the Collection Business Function.

6. If you like to remove a function, click remove.

7. If you like to change the order of functions mark one and click the move up or move down Button.

8. If the changes are meant to be preserved, choose Save.

9. To generate, choose Generate.

10. For a preview, choose Test.

Collection Category: Union and Union Aggregation

In this Collection Category every Data from the input functions is collected.

Steps

1. Select “Union” or “Union Aggregation” as Collection Category in the”Settings” Roadmapstep.

2. 2. For “Union Aggregation it is optional to select one or more fields, which should be added to the result data.

3. If you like to change the order of fields mark one and click the move up or move down Button.

4. Click the “Collection Functions” Roadmapstep.

5. Select the Data Input. Therefore you can use the Add Button to add a function from the environment or click the Sync Button to add every function, which is below the Collection Business Function.

6. If you like to remove a function, click remove.

7. If you like to change the order of functions mark one and click the move up or move down Button.

8. If the changes are meant to be preserved, choose Save.

9. To generate, choose Generate.

10. For a preview, choose Test.

Scenario: Union

Source Data

You are able to add many functions in the second step for example two.

Every Input Function is listed for itself.

Scenario: Union Aggregation

Source Data

You have the option to add one or more Fields for example Amount.

You are able to add many functions (“Input Function Data 1 and 2”) in the second step. In this example two Input Functions are added. For Union Aggregation functions, need the same Columns.

Every data with exactly the same characteristics is aggregated and key figures are summed up. The chosen field is added to the output data.