Error when joining two OBIEE report queries into one
Print
Modified on: Mon, 24 Apr, 2017 at 2:51 PM
If you are joining two OBIEE reports by creating a join relationship in the same data connection/source, you will see an error in Tableau. This is because Tableau would send a query to OBIEE as if they are both from the same schema or report which is incorrect.
The correct approach is to use Tableau's database join capability. You must create two data connections - one for each report and then create a join as needed. Then Tableau would send individual queries to each of the data sources (in this case - OBIEE report), fetch the data, and then join them in-memory. Attached is a short video of how this done.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.