SAP Knowledge Base Article - Public

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

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

  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.

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

Product

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