I’d like to compare the Purchase Requisition (PR) value to the PO value and to the Invoice value. Therefore, I’ve added an OLAP table with the PO document numbers, PO Items and the PR number as dimensions and the PO Net Price (“EKPO”.“NETWR”) and the PR valuation price (“EBAN”.“RLWRT”) as KPIs. Afterwards, I’ve calculated the difference in percentage between PO and PR value – which works fine.
Now, I’ve tried to add the Invoice value as a third KPI to this analysis in order to see all differences within one view. Therefore, I’ve added the Invoice Value (“EKBE”.“REEWR”) to the KPIs, however received following error message:
“No common parent between tables could be found – please check your schema. The tables EBAN and EKBE do not have a common parent in the schema”
I do understand the issue, however do not know if and how I could solve it, in order to have all three values (PO, PR, Invoice) in the same table. Any ideas?