Overview
This document introduces the following common issues that you may encounter in the association process.
The Add Association button is displayed in gray.
An error message occurs, indicating duplicate associated fields.
You are not allowed to establish an association between two direct-connected tables from different databases.
Add Association in Gray
Description
When you hover the mouse over the Add Association button, a prompt "No permission to add association" appears.
Cause
You cannot add associations to the dataset if you do not have the management permission.
To solve the problem, the admin needs to reassign the data table management permissions to the user. For details, see Public Data Management Permission.
Duplicate Associated Fields
Description
An error message occurs after you add an association, as shown in the following figure.
Cause
The Contract Table is the 1-side table in a 1:N association. The 1-side table is the main table, and it does not allow duplicate values to exist in the associated field Company ID.
Solution
This section introduces how to check if there are duplicate values in the associated field of the 1-side table.
Create a group table with the 1-side table, and drag the associated field Company ID into Dimension, and the field Count into Indicator. Then sort the field Count in descending order. If the maximum count is greater than 1, it indicates that the associated field Company ID has duplicate values. In this case, you need to modify the 1-side table.
Association Failure Between Direct-connected Tables from Different Databases
Description
An error message "[DIRECT-ETL] unsupported data source: databases on different hosts/ports" is displayed in the self-service dataset or component.
Cause
In the direct-connected data mode, two tables from different databases cannot be associated.
Some databases cannot be associated with Excel datasets. For details, see Direct Connect Databases Supporting Integrated Analysis with Excel.
Solution
The direct-connected mode does not support cross-database association. You can switch to the extracted data mode for association.
