Symptom
You want to create a Join Data Source (Inner Join or Left Outer Join) with a Join Condition on a Key Figure, however the system throws an exception.
Environment
- SAP Cloud for Customer
- SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Data Sources view.
- Click on New -> Joined Data Sources button.
- On the new screen, use your desired Data Sources and create a Join Condition by mapping Key Figures on both Data Sources.
- Click on Check.
You will face an exception.
Cause
The system prevents you from creating an inconsistent data source. The reason behind this is due to the fact you cannot create a join condition (dependency) on a calculated element (Key Figure) because it is not a constant and it can change depending on other key figures/characteristics values.
Therefore, join conditions cannot be created on key figures.
Resolution
This is the correct behaviour. You can create a join condition on characteristics that are common for all involved data sources and that present the same granularity (not m * n, for example).
Keywords
data source, error message, join condition, key figures, not possible, dump, crash , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To