PeopleSoft Pivot Grid Overview

PeopleSoft Pivot Grid supports operational dashboard reporting within the PeopleTools framework to provide a pivot table and chart representation of data using PSQuery, Composite Query, and component data source. The framework also enables you to see different views of the data, as in a Microsoft Excel pivot table, and the same data is also available in a chart view.

Using Pivot Grid, you can view data in these different visualizations:

• Pivot Grid only.

  You are able to view the operational reporting data in a grid, where data pivoting, slicing, and dicing is possible.

• Chart only.

  You are able to view the operational reporting data in a chart, change the axis, filter the results, drill down to other dimensions and detail. In addition, you can display the grid from a chart-only view and then perform various actions—such as pivoting data, dragging and dropping, and slicing and filtering data—to change the grid layout. After the layout is satisfactory, you can synchronize the chart with the grid view.

• Pivot Grid and chart.

  You are able to view the operational reporting data in both a grid and a chart. The data between the grid and the chart is synchronized.