Utility joins allow you to build dimensions and metrics that require 2 or 3 table references.
It permanently ties two tables together.

For example: to calculate net cost, the net rate will be in set at placement level in the dcm_meta_placement table. However, media cost in the dcm_data_aggregate table. The calculation you require is media_cost * net_rate.
To do this a utility join is required on the dcm_data_aggregate table tying on the dcm_meta_placement table.

To do this, on the Datasources tab of the Report Engine expand the Join option and select "add join" - this will open up the widget. Select "create a new join".

As we are joining two tables together, the join type required is utility join. Next select the datasource you would like to join to the table. In the example above; this would be the dcm_meta_placement table.

The LHS sql is the field in the main table, that will be used to connect to the datasource.
The RHS sql is the field in the table you are joining that will be used to connect to the datasource.
From the example, the LHS would be the placement ID from the dcm_data_aggregate table and the RHS would be the ID field from the dcm_meta_placement table.
Note: The token of the field {F...} is required and not the name.

Finally, select the type of join required - normally INNER - and tick the box "unconditional".

Then save, and the utility join is set.

Did this answer your question?