3591724 - Error when deleting relationship in Table report

• An issue arises when attempting to delete a relationship in a table report, even when no columns are being used.
• The error message displayed is: "Cannot delete this relation (at least one relationship is required between the participating schemas)".

• SAP SuccessFactors HCM Suite
  
  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    
    • Table Reporting

1. Go to Report center
2. Edit Table/Adhoc report
3. Go to Relationships tab
4. Attempt to remove required relationship.
5. The error message "Cannot delete this relation (at least one relationship is required between the participating schemas)" is displayed.

This is the expected behavior in cross-domain Table Reports. When a cross-domain relationship is added between two domains, it is automatically created by default and cannot be removed independently.

If you need to remove the relationship, you will need to remove the associated domain from the dataset.

1. Go to Edit report.
2. Under General Info, find the delete data set option.
3. A drop-down of all domains being used in the report will appear.
4. Choose the domain to be deleted from the drop-down and delete. 

Note: Delete domain from dataset only if the domain and related columns are not required in the report.

Table report, delete relationship, error message, participating schemas, domain, delete data set option, Cannot delete this relation. , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

SAP SuccessFactors HCM Suite 2511 ; SAP SuccessFactors Platform 2511