Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to join two columns/attributes in OTBI

edited Apr 18, 2024 8:23AM in Enterprise Contracts 1 comment

Hello Gurus,

I am joining Enterprise contracts real time subject area and payables invoice subject area. All I am trying to get is the invoice amount, supplier information and contract number. For invoice amount, I have to use payables subject area. Right now joining the two subject areas results in cartesian join.

In the filter condition, I wanted to join party name from payables invoice subject area to contract party name from contracts subject area. This is the syntax → FILTER(SUM("Payables Invoices - Transactions Real Time"."- Invoice Amounts"."Invoice Amount") USING ("Contract Party"."Contract Party Name" = "Payables Invoices - Transactions Real Time"."- Party Details"."Party Name"))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!