Creating a New Pivot Grid Pagelet Using the Pagelet Wizard
Use the Specify Pagelet Information page (PTPPB_WIZ_INFO) to enter the pagelet title and other pagelet information.
Navigation:
Access the Specify Pagelet Information page by selecting
This example illustrates the fields and controls on the Specify Pagelet Information page. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
Pagelet Title |
Enter a title for the Pivot Grid pagelet. This field is required. |
Category ID |
Select the pagelet category ID. Note: The portal administrator can use this value when running pagelet reports and when searching for pagelets that need to be moved between different portal sites. |
Next |
The Next button is available after you enter the pagelet title in the Pagelet Title field and move the cursor to any other field. Click this button to advance the wizard to the next page. |
Use the Select Data Source page (PTPPB_WIZ_DATASRC) to select the pagelet data source type that will be used for the pivot grid and to select the Pivot Grid model to be created as a pagelet.
Navigation:
Access the Select Data Source page by clicking the Next button on the Specify Pagelet Information page.
This example illustrates the fields and controls on the Select Data Source page. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
Data Type |
Select the data type Pivot Grid. |
Pivot Grid Name |
This field appears after you select the data type Pivot Grid. Click the search icon to select a pivot grid from existing pivot grids. |
Next |
The Next button is available after you select a pivot grid from the Pivot Grid Name field. Click this button to advance the wizard to the next page. |
Use the Specify Data Source Parameters page (PTPPB_WIZ_DATAPRMS) to select a view for the Pivot Grid model, create new views for the model using the Pivot Grid View Options component, and specify the initial width and height of the pagelet.
Navigation:
Access the Specify Data Source Parameters page by clicking the Next button on the Select Data Source page.
This example illustrates the fields and controls on the Specify Data Source Parameters page. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
Configure pivot grid views |
Click this link to open the Pivot Grid Views Component dialog box, where you can define pivot grid display options. |
Description |
Enter a description for the pagelet. The default values are:
|
Usage Type |
Select a usage type for your pivot grid. Available options are:
|
Next |
Click to advance the wizard to the next page. |
Narrow Viewer
The Narrow Viewer mode is useful for pivot grid pagelets in the work center. You can set the Narrow Viewer mode for pagelets using the Publish as Pagelet page or the Pagelet Wizard - Specifying Data Source Parameters page.
The published pagelet has a single column filter mode in the chart-only models. All functionalities available in the normal viewer are also available in Narrow Viewer mode.
Oracle PeopleSoft recommends that you use the Narrow Viewer mode for the chart-only models. You can expand the width of charts in the narrow viewer from their default settings by using the advanced chart options in the viewer. If you use the Narrow Viewer mode for the grids, the grids occupy the same real estate as in the normal viewer.
This example illustrates a dashboard showing the narrow chart view in the left pane, unexpanded from the default width, and in the right pane expanded from the default width.
Note that:
Options Menu and chart icons are available for all views.
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.
If the Pivot Grid model has filters, the default narrow view of a Pivot Grid pagelet shows the width of the chart at 210 pixels.
This example shows the narrow view of Pivot Grid pagelets with the minimum width for Pivot Grid models that have filters. The width of the chart is 210 pixels, and group boxes are collapsed by default. You can click the bars in the chart to access the detailed view.
If the Pivot Grid model has no filters, the default narrow view of a Pivot Grid pagelet can be scaled back to 175 pixels, and you can set the narrow view to a smaller size.
This example shows the narrowest view for a model with no filters. The width of the chart is 175 pixels. You can click the bars in the chart to access the detailed view.
If the width of the chart is less than 300 pixels, then when you click the chart sector or bar, you access the detailed view directly without the drill-down or Related Action menu.
If the width of the chart is greater than 300 pixels, the narrow view of pagelets shows locator links, the drill-down menu, the detailed view, and the Related Action menu.
This example shows the minimum width of the Pivot Grid models with the drill-down menu.
If the drill-down menu has multiple levels, then the side of the chart is adjusted to show all drill-down levels.
Defining the Pivot Grid Display Options
Use the Pivot Grid Views page (PTPG_VIEWOPTIONS) to configure different views for the selected Pivot Grid model.
Navigation:
Open the Pivot Grid Views Component dialog box by clicking the Configure pivot grid views link on the Specify Data Source Parameters page.
This example illustrates the fields and controls on the Pivot Grid Views Component dialog box. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
View Name |
Select the Pivot Grid view to use for this pagelet. |
Data Source Prompts |
Enter the default values for the PSQuery runtime prompts. Note: This section is only available when the selected query that built the grid has prompts attached. |
Display Options |
Define pagelet view options for the grid and the chart. Available options are:
|
Calculation Formula |
The Calculation Formula column is available only for number (facts) fields. Select either the Percentage or the Percentage Grand Total option to display the number (fact) values in the grid and chart. You are able to apply or remove this calculation option using the Options Menu icon in the Pivot Grid Viewer. |
Grid Options |
Define whether drag-and-drop functionality is allowed in the grid, whether the initial view of the grid is expanded or collapsed, and whether the grid can be expanded or collapsed. Available options are:
|
Chart Options |
Define information for axis and value columns of the grid, and define chart type and axes information for the chart. Available options are Title, Type, X axis label, and Y axis label. |
Advanced Options |
Define the 3D rotation angle and height of the chart. |
Save As |
Click to open the Save View As dialog box, where you can either save the current Pivot Grid model as a new view or update an existing view. |
Close |
Click to close the Pivot Gird Views component and copy the selected view name to PVG_VIEWNAME data source parameter. |
Use the Select Display Format page (PTPPB_WIZ_DISPFRMT) to confirm the display format of the pagelet.
Navigation:
Access the Select Display Format page by clicking the Next button on the Specify Data Source Parameters page.
This example illustrates the fields and controls on the Select Display Format page. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
Specify Display Options |
Confirm the display format of the pagelet. Note: Passthru is the only display option available for Pivot Grid. |
Next |
Click to advance the wizard to the next page. |
Use the Specify Display Options page (PTPG_PGVIEWER) to define the display options of the pagelet, preview the Pivot Grid model, and view the pagelet that is selected.
Navigation:
Access the Specify Display Options page by clicking the Next button on the Select Display Format page.
This example illustrates the fields and controls on the Specify Display Options page. Definitions for the fields and controls appear following the example.
Field or Control |
Description |
|---|---|
Additional Text |
The Additional Text region contains the options to add headers, footers, opening text, and closing text to a pagelet. |
Search Options |
The Search Options region contains the options to override the default search functionality for the current pagelet only. |
Pagelet Preview |
When you change the Additional Text or Search Options, the changes automatically update the preview. |
Next |
Click to advance the wizard to the next page. |
Use the Specify Publishing Options page (PTPPB_WIZ_PUBOPT) to define the location, type, and security attributes for the pagelet and publish the pagelet.
Navigation:
Access the Specify Publishing Options page by clicking the Next button on the Select Display Options page.
This example illustrates the fields and controls on the Specify Publishing Options page. Definitions for the fields and controls appear following the example.
Note: You can include the Pivot Grid pagelet in Operational Dashboards, WorkCenters (pagelet width 256 pixels when configured in a workcenter), and homepages. Only the Homepage Pagelet and Embeddable Pagelet options are applicable for Pivot Grid pagelets.
Field or Control |
Description |
|---|---|
Homepage Pagelet |
Select this option to publish the pagelet as a homepage pagelet that can be added to a homepage or WorkCenter operational dashboard page. |
Template Pagelet |
This option is not applicable for pivot grids. |
Embeddable Pagelet |
Select this option to make your pagelet available as an embeddable pagelet that can be generated by the Pagelet Wizard API for rendering within an HTML area of a PeopleSoft Pure Internet Architecture target page or using an iScript. |
Pagelet Security |
Administrators can set pagelet security as public, or they can set a permission list based on user roles. |
Save |
Click to save the pagelet. |
Finish |
Click to transfer to the Pagelet Creation Confirmed page, where you also can save the pagelet. Access the homepage to personalize it to include the newly created pagelet. |
Note: While working with the Pagelet Wizard, you can modify your previous selections at any step by clicking a step number icon. Changes in your selection could change the structure of a pagelet.