Within an OLAP table, I would like to use both the Delivery Line Item Date ("VBEP"."EDATU") and the shipment gross weight ("LIPS"."BRGEW")
Does anyone know how I can apply a PQL function to combine these tables?
Please find the error below. I looked into the PQL documentation but I can't find the solution.
Error in formula
No common table could be found. The tables e"VBEP"] and n"LIPS"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: hVBEP]N <-- 1! VBAP]!1 --> N;VBFA]N <-- 1-LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.