12.3.7 Aggregation

This section provides information about the Aggregation component.

1. Drag and drop the Aggregation component on the canvas to define an aggregation on an EDD.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. Aggregation component accepts input only from an EDD and it can have only one output.
4. If you have multiple EDDs to be aggregated then you must select as many number of aggregation components, connect each to the respective EDD, and then define their group by having clauses. Example: To add aggregation to three EDDs, drag three aggregation components on to the canvas and link them to their respective EDDs.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. Double-click the Aggregation component to define an aggregation condition. In the Aggregation Window, you will see the selected EDD under the Entities tab. Double click the entities, functions, and operators to build your expression in the Group By field. Repeat this step to build your clause in the Having field.
7. Click Validate to verify the correctness of the SQL Expression.
8. Click Ok.
9. Click Reset to reset all the aggregation conditions and begin afresh.