Skip to Content
0
Jul 08, 2019 at 02:53 PM

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

77 Views Last edit Jul 09, 2019 at 09:34 AM 2 rev

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