SouthCentral Presentations

A thrill of hope the PSQuery world rejoices – Advanced Topics in Query Manager 

07-12-2019 03:00 PM

This session is designed for PSQuery writers familiar with the basics of PeopleSoft query manager reporting, but looking to get more out of the tool.
The University of Texas at San Antonio has used PSQuery as its main reporting platform for almost 5 years since PeopleSoft implementation. Come learn some techniques and tips.
This session will cover windowed functions, partition functions, SQL insertion for group by CUBES and ROLLUPS, LISTAGG and other aggregates, Effective Dating considerations, easier ‘IN’ lists, flattening trees, handling and manipulating dates, other useful expressions, and more. The syntax will be based on Oracle servers and will use Human Resources and Financial Data, but the ideas are applicable to other setups.

Statistics
0 Favorited
13 Views
1 Files
0 Shares
13 Downloads
Attachment(s)
pptx file
SCHRUG_8126_190723_1110.pptx   2.08 MB   1 version
Uploaded - 09-18-2020

Related Entries and Links

No Related Resource entered.