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:
- Right click anywhere on the report to pull up Properties
- 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.