Základní info
This PeopleSoft Query Reporting Rel 8.53 training covers basic and advanced functions of PeopleSoft Query and PeopleSoft Pivot Grid. 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 subqueries, unions and Connected Query.Use Query Manager.Use PSQuery as data source for pivot grid models. View and manipulate PSQuery-based grids and charts.Create pivot grid models using Pivot Grid Wizard.Add pivot grid models as related contents.Add related contents and related actions to pivot grid models.Create pivot grid pagelets.Add pivot grid pagelets to homepages and dashboards.Perform Pivot Grid administrative tasks.Benefits to YouEnrolling in this course will help you understand PeopleSoft Query and PeopleSoft Pivot Grid. In the PeopleSoft Query lessons, 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.Pivot Grid LessonsThe Pivot Grid lessons of this course describe PeopleSoft Pivot Grid and how to use PSQuery as data source to create pivot grid models. You learn how to view and manipulate grids and charts using Pivot Grid Viewer, create pivot grid models using Pivot Grid Wizard and add pivot grid models to PeopleSoft pages as related contents. Furthermore, you'll walk away with the knowledge to add related contents to pivot grid models, create pivot grid pagelets, add pivot grid pagelets to homepages and dashboards and perform Pivot Grid administrative tasks.Perform Query Administration TasksIn addition, you will learn how to perform Query and Pivot Grid administrative tasks. You will also develop the skills to apply complex Query and Pivot Grid features. This will further enhance your knowledge of PeopleSoft Reporting Tools.
