Data Mediation › How to Implement Data Mediation › Define Aggregation Logic

Define Aggregation Logic

You can define the initial aggregation logic in the form of an SQL statement.

To define aggregation logic

1. Click Accounting, Data Mediation, Profile Management.

   The Profile Management list of profiles appears.

   If the target table column is empty and the configuration status is “pending,” the initial aggregation logic for the profile is not yet defined. The presence of a target table entry and a configuration status of “Defined” indicate that the profile has been previously defined.

   Note: The Target Table column is visible when the Show more columns double arrow icon is clicked.

2. Click the Define Aggregation Logic icon or the name field for the profile whose aggregation logic is to be defined.
3. Drag-and-drop each field from the data source into the target table field to define the logic to be used during aggregation.
4. Click Generate Query to generate the SQL Expression.

   Note: You can define the initial aggregation logic by using a SQL statement or procedure. Specify the initial aggregation logic to prepare the imported event usage data to include all of the server mandatory fields for the aggregation and cost allocation process. For example, suppose you have usage data for each host in temporary tables for data mediation and want to map the hosts to accounts using the data mediation reference tables. In that case, perform a join of these tables in the SQL procedure to prepare the event table.

5. Click Save.

   The aggregation logic is defined.