Základní info
This PeopleSoft Query Reporting Rel 8.53 training covers basic and advanced functions of PeopleSoft Query. You'll learn how to design reports that use criteria to filter data or that use predefined online calculations.Learn To: Filter output with criteria and runtime prompts. Work with multiple tables and summary calculations.Perform PSQuery administrative tasks. Create expressions, drilling URLs, any-joins and outer-joins. Use aggregate functions, subqueries, and unions.Use Query Manager, Query Viewer, Query Scheduler, Query Administrator, and Connected Query.Benefits to YouEnrolling in this course will help you understand PeopleSoft Query. You will use runtime prompts, expressions, criteria rows, aggregate functions, joins, subqueries, unions and so on. Learn how to extract the precise information you need to create visual representations of the PeopleSoft database, without having to write SQL statements.Create Reports with Runtime PromptsYou also learn to create reports with runtime prompts that build flexibility and reusability into your reports and decrease your report design time. Schedule queries to run while you are away so your reports always run on time, learn advanced techniques to view the exact data that you need, use expressions to perform configurable online calculations and combine data from unrelated tables or multiple queries to return one set of data.Perform Query Administration TasksIn addition, you will learn how to perform Query administrative tasks. You will also develop the skills to apply complex Query features. This will further enhance your knowledge of PeopleSoft Reporting Tools.
