Skip to Content

Querying PeopleSoft tables

Hie Guys,

I have successfully created a combined report from 2 different universes.

"Universe 1" was created based on a SQL query from a MySQL connection/database. I created a derived table using the SQL query. Now, one of the objects in the derived table named "Sponsor Name" had "Sponsor ID' values from "Universe 2". Thus, I had to create a detail variable to get the Sponsor Names. The problem I am facing is - some of the ID fields from "Universe 1" are not available in "Universe 2". Thus, I have some blank Sponsor Names in the combined report.

Details about the MySQL Connection:

The "MySQL" database queries a "PeopleSoft - Oracle" table to get the Sponsor Names. I've attached snapshot of the query below.

Can anyone help me on getting this issue resolved? Thanks.

query.jpg (334.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 03:08 PM

    So what exactly is the issue. If you do not have the matching ids in both the universe and you are using a left outer join you will get blank data for sponsor name. This is how it works.

    If you do not want to show the records where the sponsor name is not blank then you will have to use inner join (caution: this will remove the entire rows with non matching id) or you need to have the matching id in both your left and right tables

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.