ByD: not all selected results shown when merging 2 data sources and calculating key figures

[alexander_oschatz]

Hi there,

I'd like to Combine or Join the 2 data sources

• FINGLAU02
• SCMCFJU01

to then search for and calculate specific data, e.g. the sum of specific cost centre bookings and the sum of all goods-out postings both for the same date. To then show them side-by-side as calculated key figure, e.g. Column A: 200 EUR and Column B: 300 kg on the 3rd of May 2019.

Unfortunately the only overlapping info in both data sources are

SCMCFJU01 < > FINGLAU02

BT_DATE < > POSTING_DATE

PE_UUID < > PROFITCTR_UUID

As I have some more (2-4) selection criteria for each source I'd like to ask for a best practice how to merge these 2 data sources when these 4 characterstics are the only overlapping ones. At the moment I'm only able to combine these 2 data sources and my selections will only generate the requested data from one of the sources.

Regards

Alex