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

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.

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 soources and that present the same granularity (not m * n, for example).

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer all versions