If two identical variables are included in a report from different queries, they can be combined using a Merged Dimension. This tells the report how the different queries relate to one another.

The best fields to use for this are identifiers: Participant Site ID, Enterprise Site ID, etc.

The data in these fields must match exactly in order to be merged properly. For example: using a name field as a merged dimension is not a good idea as two or more participants could share a name.

If the same TouchPoint is being brought into a report from different queries, [Response ID_xx] can be used as a merged dimension. Do not use [Response ID] if two different TouchPoints are being pulled in, as this variable is only unique to each specific TouchPoint (every TouchPoint will have a Response ID_1, 2, 3, 4, etc.).

Webi may create merged dimensions automatically for objects with the same name in different queries. This can cause issues between queries, confusing the report. To disallow a report from automatically creating Merged Dimensions:

  1. Right click anywhere on the report to pull up Properties
  2. Un-check the box for Auto-Create Merged Dimensions.

For more information on creating merged dimensions, click here.

Please contact customer support if you need more information or additional assistance. 

Did this answer your question?