Sum, average, count, min, max, stddev, stddevp, stdvar, stdvarp. Presentation by smart erp solutions covering how to use pivot grids for data visualization in peoplesoft applications. Pivot grids can be created from a ps query using the pivot grid wizard as shown in the step by step description in the white paper. Work with multiple tables and summary calculations. Dec, 2019 my oracle support provides customers with access to over a million knowledge articles and a vibrant support community of peers and oracle experts.
The pivot grid control represents data from an underlying data source in a crosstabulated form. If there are filters in the pivot grid model, the default narrow view of a pivot grid pagelet shows the width of the chart at 210 pixels. The framework also enables users to see different views of the data as in an microsoft excel pivot table, and the same data is also available in a chart view. Session 3 administering and migrating pivot grids, peoplesoft pivot grids these free learning sessions provide an introduction on how to design a psquery to use for your pivot grid model, create a pivot grid, incorporate pivot grid pagelets into your applications, administer, and migrate pivot, 8. We will identify the current pivot grid models and demonstrate a. Work with expert oracle university instructors through a combi. Peoplesoft has come with many changes with peopletools 8.
Pivot grids provide great abilities in analytics yet maintaining the simplicity. Pivot grid with multiple ps queries macd dec, 2019 2. Net is a blog about oracle peoplesoft tips, tricks, jobs and erp technologies. This enables users to visually display data in a dashboard. You can display data in different views by performing operations such as pivoting and filtering, which enables business analysts to interpret data in a variety of ways. Peoplesoft pivot grids these free learning sessions provide an introduction on how to design a psquery to use for your pivot grid model, create a pivot grid, incorporate pivot grid pagelets into your applications, administer, and migrate pivot grids. Pivot can produce the output in regular text or xml. Once a pivot grid related tile is added to a homepage, users have more options to analyze their data in fluid mode. In this training we will discuss the peoplesoft financials business intelligence feature pivot grids. Pivot grid supports operational dashboard reporting within the peopletools framework to provide a pivot table and chart representation of data using psquery. Also you can attach related actions to the pivot grid from this page. How to create a tile for an existing pivot grid in peoplesoft fluid. Adding analytics to navbar, homepage and dashboard.
I researched over this and found a solution on oracle support. To know how to create a pivot grid, read my previous post on the topic. A look at pivot grids in campus solutions oracle campus. Also oracle is working on peoplesoft on cloud and i bet peoplesoft is again going to be one of the leading hcm solution for customers. Aug 27, 2015 in the last post for my series on benefits of peoplesoft 9. Understanding peoplesoft pivot grid pivot grid terms. Creating a pivot grid is also a simple task for those who are already familiar with ps queries. Oct 28, 2011 peoplesoft pivot grids display views of your data in a dashboard. Peoplesoft project is a temporary endeavour undertaken to create a unique peoplesoft software product. The framework also enables users to see different views of the data as in an microsoft excel pivot table, and the same data is also available in a. A brief display of oracle peoplesoft s data visualization and data presentation capabilities. Can be easily created using ps queries, hence providing a lot. Pivot grids allow you to create dashboardlike reporting in the form of a pivot table or chart representation of the data in your peoplesoft application using one of the following. Deploying peopletools pivot grids on peoplesoft homepages.
Peoplesoft pivot grids display views of your data in a dashboard. Three primary roles are available for pivot grid users. Whether presented in an operational dashboard as a pagelet or viewed using the pivot grid viewer, the data needed to. Use pivot grids to see exactly the data you want and how you want to see it. Next adding your tile to fluid home page as explained in my previous post peoplesoft fluid tilespart 1. By default numbers are not formatted to show thousand separator or currency symbols.
Pivotgridcontrol class winforms controls devexpress help. Pivot grid, understanding component real time search using pivot grid in the fluid mode, security for realtime component search. With every new peopletool release peoplesoft continues to enrich pivot grid functionality. For example, the recruiting users in pivot grid gets late responses. Aug 03, 20 presentation by smart erp solutions covering how to use pivot grids for data visualization in peoplesoft applications. Data can be displayed in different views by performing operations such as pivoting and filtering, which enables business analysts to interpret. Viewing psquery drilling urls in pivot grid detail view. Highlevel overview and flow diagram for peoplesoft pivot grid peoplesoft pivot grid provides the overall functionality of storing pivot grid metadata, generating queries at runtime, and rendering display for the pivot grid and chart.
Pivot grid uses psquery as the data source, with pivot grid grids and peoplesoft charts as the visualization. The peoplesoft pivot grid is a reporting tool used to provide a pivot table and chart representation of live data using ps query data source. Mar 20, 2014 i recently worked on the pivot grids in peoplesoft 9. How to sort grid columns using peoplecode peoplesoft. Pivot grid performance tends to depend on the results of the query and then needs to collate them into the data set. Our company uses peoplesoft hcm for benefits, recruiting and selfservice.
Limitations of peoplesoft chart and peoplesoft pivot grid. Pivot grids can do all this for you while you invest your precious time in thinking about the best way to act on that data. This software or hardware and documentation may provide access to or information about content, products, and services. It is a road map intended to help you assess the business benefits of upgrading to peoplesoft peopletools 8. Users not assigned to one of these roles will be pivot grid end users. Pivot grid supports operational dashboard reporting within the peopletools framework to provide a pivot table and chart representation of data using psquery data source. Installing peoplesoft payroll module is an example of peoplesoft project. Oct 25, 2016 an easy way to locate these is to filter by the image number 9. Pspgcore core pivot grid record peopletools table reference. Session 1 creating pivot grids, peoplesoft pivot grids these free learning sessions provide an introduction on how to design a psquery to use for your pivot grid model, create a pivot grid, incorporate pivot grid pagelets into your applications, administer, and migrate pivot, 8. In the latter case, you dont need to specify the domain of values the pivot operation needs to search. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Pivot grids deliver interactive charts that allow you to not just pivot. This training covers the basic and advanced functions of peoplesoft query and peoplesoft pivot grid.
Highlevel overview and flow diagram for peoplesoft pivot grid. Available at my oracle support, information on peoplesoft enterprise campus solutions 9. The related actions and pagelet will be covered in a different section. The data for the table pspgdtype needs to be imported into the database. Create expressions, drilling urls, anyjoins and outerjoins. Pivot grid can pivot and filter data, which enables business analysts to see different views of the same data.
Feb 03, 2017 next adding your tile to fluid home page as explained in my previous post peoplesoft fluid tilespart 1. Pivot grids offer a strong option for analytical reporting needs. Pivot grid with multiple ps queries oracle community. Pivot grid uses psquery and component as the data source, with pivot grids and peoplesoft charts as the visualization options.
Whether presented in an operational dashboard as a pagelet or viewed using the pivot grid viewer, the data needed to manage the company will be at your users fingertips. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. Peoplesoft pivot grid the peoplesoft pivot grid is a reporting tool used to provide a pivot table and chart representation of live data using ps query data source. Pivot grids posted on march 20, 2014 by saurav khandelwal i recently worked on the pivot grids in peoplesoft 9. Ongoing investment in peoplesoft analytics and insight rainfocus. Pivot grids display pivot tables and chart representations of psquery data. Generic error while executing the query datasource on time. Pivot grid administrator or pivot grid developers can set to show or hide the options menu and chart icons using the viewer options section in the pivot grid wizard specify data model options page. The pivot grid wizard is used to create and maintain pivot grid models. The wizard contains five steps that walk through the process of defining the core of the grid data, values and axes and the initial pivot display.
This topic provides additional information for this section of the product documentation. Peoplesoft pivot grids have been out since peopletools 8. This software or hardware is developed for general use in a variety of information management applications. Sep 26, 2019 peoplesoft enterprise hcm talent acquisition manager version 9. No data source for peoplesoft pivot grid i was trying to create a pivot grid but the pivot grid wizard is showing invalid value for the data source. For more information on pivot and unpivot operations, refer to the oracle database 11g sql language reference. Jul 28, 2015 the peoplesoft pivot grid is a reporting tool used to provide a pivot table and chart representation of live data using ps query data source. Now our pivot grid tile is placed on home page as shown below. From reporting tools pivot grid pivot grid vieweropen a grid in fluid mode. Peoplesoft pivot grid enables users to visually display data in a dashboard. Pivot grid supports operational dashboard reporting within the oracle peoplesoft peopletools framework to provide a pivot table and chart representation of data using peoplesoft query data source. Dec 06, 2016 the pivot grid gives users the ability to quickly and easily filter student data within campus solutions and take action through related actions and urls. This payroll module will take care of the companies payroll related requirement. By using enhanced pivot grids, users can access a wide variety of transactional and analytic content online, in context with their.
Peoplesoft was always single point and will always be. I recently had to solve a pivot grid and pagelet query number formatting problem. This program will be conducted with interactive lectures, powerpoint. How to change chart colors of pivot grids viewed in fluid mode. I found this problem exists in peoplesoft query, pivot grids and pagelets that render query output. Peoplesoft delivers the roles pivotgridadmin and pivotgridsuperuser. Aug 12, 2014 the peoplesoft pivot grid is a reporting tool used to provide a pivot table and chart representation of live data using ps query data source.
Pivots grids can display the results in a grid format, a chart format, or both. Depending on the filters you have on the query, the pivot grid also needs to work out the distinct number of values it can load to the filter fields. I recently worked on the pivot grids in peoplesoft 9. Get your team aligned with all the tools you need on one secure, reliable video platform. Peoplesoft fluid tilespart 2 peoplesoft techniques. Work with expert oracle university instructors through a combination of interacti. Without this common styling its much harder to read large numbers.
139 210 1394 62 971 206 700 144 1366 1397 898 1177 144 438 291 733 869 598 954 573 1199 675 553 124 45 757 255 784 400 328 481 953 343