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

BI Publisher GUI Outer Join Query

edited Apr 25, 2019 11:17AM in Reporting and Analytics for HCM 3 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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