Skip to main content

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.

Hello. Probably you will need a combination of BIND and DOMAIN_TABLE and PUs.

Please, check these links:

https://help.celonis.cloud/help/display/CIBC/BIND

https://help.celonis.cloud/help/display/CIBC/DOMAIN_TABLE

Tks.

D

 


Reply