SAP Knowledge Base Article - Public

1845156 - Creating Joined Data Source With Join Condition on Key Figure Results Not Possible


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

  1. Go to the Business Analytics work center.
  2. Go to the Design Data Sources view.
  3. Click on New -> Joined Data Sources button.
  4. On the new screen, use your desired Data Sources and create a Join Condition by mapping Key Figures on both Data Sources.
  5. 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


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions