BI Publisher GUI Outer Join Query
Content
Hi,
We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models.
Background: We used to have this pending approval report in single data set, however due to complexity of the query and required information that we were trying to pull, server costs were too high and report stopped working as gets time out.
In order to optimize the query we tried to do 3 set query so that server costs are kept bellow limit. Within the Data View we are able to view all results which are contained within G1 query and G2 query.