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.
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.
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.
This is the correct behaviour. You can create a join condition on characteristics that are common for all involved data soources and that present the same granularity (not m * n, for example).
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To