Query and Reporting Features
- What is a Drilling URL?
- Drilling URL is an expression that contains a URL. It drills down to another object.
- It is defined by selecting Query, Menu, Component, Page, Portal Object, or URL of choice.
- It is matched/pointed to fields in your query.
- What are Connected and Composite Queries?
- Connected and Composite Queries are delivered, advanced Query tools that allow you to combine two or more existing PeopleSoft queries in parent/child relationships. Results are returned in XML.
- Used for complex queries with multiple inner or outer joins, grouping, or hierarchy. Useful for easier unions and outer joins.
- What is a Pivot Grid?
- Pivot Grid enables users to visually display data in different views by pivoting and filtering
- Data can be viewed in grids or charts
- Uses PeopleSoft Query as the Data Source
- Is created through the use of a Wizard
Links to Presentations (HEUG.ORG)
Drilling URLs
PS Query – Drilling URLs – More Info at Your Fingertips Using Student Academic Data! (Alliance 2015 – Northern Illinois University)
Drill Down URLS (NEWHEUG 2015 – University of Massachusetts)
Using Drilling URL Function in PS Query to Integrate PS Components (Alliance 2014 – University of Texas at Arlington)
Connected and Composite Queries
Connected Query and Composite Query (NEWHEUG Alliance 2016 – University of Massachusetts)
Powerful PeopleSoft 9.2 Composite and Connected Query (MIDHEUG Alliance 2016 – SpearMC)
XML Publisher with Connected Query – A Primer (Alliance 2012 – University of Central Florida)
It Pays to be Connected – The Power of Connected Query (SCHRUG 2015 – University of Texas at Arlington)
Pivot Grid
Pivot Grids 101 (HEUG Education Series Webinar – May 17, 2017 – UT Dallas)
Pivot Grid (SCHRUG 2015 – University of Houston)
Pivot Grids – Slice and Dice Your Query Data (Alliance 2016 – Cedar Fall Utilities)
Online Reporting Made Easy with Pivot Grid (Arab HEUG Alliance Conference 2016 – Abu Dhabi University)
PeopleSoft : Evolution of XMLP and Pivot Grid For PeopleSoft Reporting : Usage and Troubleshooting (Alliance 2013 – Oracle)
Reporting Tools
PeopleSoft Reporting Tools – Query, BI Publisher, and Pivot Grids (Alliance 2017 – MiraCosta College)
Making Sense of PS Reporting Tools: Query, Composite, Connected, BI Publisher, Pivot Grid, Dashboard (Alliance 2017 – University of Wisconsin – Oshkosh)
