Inserting and Manipulating Analytic Grid Columns
This topic discusses how to insert and manipulate analytic grid columns.
Note: The analytic grid supports a minimum of two columns: one for row axis and one for data; and it also supports a maximum of 101 columns: one for column axis and 100 for data. The default maximum number of columns is 41. You can also use the ACEGRDCOLS option in PeopleSoft Personalizations to set the number of columns displayed in the analytic grid. If necessary, the analytic grid provides a scroll bar that enables end users to scroll through all columns.
When the Freeze Column Mode check box is selected in the Analytic Grid Properties - Analytics tab, all columns in the analytic grid are displayed. No threshold is placed on the maximum number of columns. The user profile setting ACEGRDCOLS, has no affect if the Freeze Column Mode option is selected. The analytic grid provides a horizontal scroll bar to scroll through all the columns in the grid. The size of the analytic grid at runtime is a factor of the design time size of the analytic grid and the actual browser page width. The browser width is used only when the page is generated, so the size of the grid does not change as the user resizes the browser window. It does change on the next server trip when the page is regenerated.
The order of the dimensions in the analytic grid does not need to match the order of dimensions in the analytic model. The order in the model is for the purposes of calculation, whereas the order of columns in the analytic grid determines the order that displays to the end user.
Use one of the following methods to insert an analytic grid column:
Select a page control from the Insert menu and click the analytic grid.
Note: You can insert these page controls within analytic grids: edit boxes, long edit boxes, images, push buttons, and check boxes.
A cube formatted as dimension member should have field type of edit box.
Drag a page field from within the current page, or from another page, into the analytic grid.
Copy and paste a page field or record field.
Drag a definition (such as a record field definition, a page field definition, or an entire record definition) from the project workspace to the analytic grid.
The Analytic grid columns should all be bound to the same record definition to which the underlying cube collection is attached; the only exception is the columns used for related display/related edit. All the fields in the record definition that are mapped to either a dimension or a field should have a representative column in the analytic grid.
To delete an analytic grid column:
Select to access PeopleSoft Application Designer.
After signing in to the PeopleSoft Application Designer, open a page definition.
Select a column by clicking the column heading of the analytic grid.
Be sure that you select only the column and not the analytic grid as a whole; otherwise, you might delete the entire grid instead of just the column. The column is selected when it turns black. The whole analytic grid is selected when control boxes appear around the edges of the grid.
Press the Delete key.
To move analytic grid columns on the Layout tab:
Select to access PeopleSoft Application Designer.
After signing in to the PeopleSoft Application Designer, open a page definition and access the Layout tab.
Click to select a column heading of the analytic grid.
Drag the column to its new location.
Release the mouse button over the column that is to the left of the new location.
Note: The order of columns here determines the order in which they display to end users. However, to determine the axis on which fields appear, you use the Analytics tab in the Analytic Grid Properties dialog box. All non-dimensional fields can appear on one axis only.
To move analytic grid columns on the Order tab:
Select to access PeopleSoft Application Designer.
After signing in to the PeopleSoft Application Designer, open a page definition and access the Order tab.
Select the column row by clicking the row number.
The analytic grid is identified as such in the Type column and appears in green. All columns in the analytic grid are directly below this analytic grid row and appear in a lighter green.
Drag the row to the new position in the grid.
A red line indicates the new position of the column before you release it.
Note: You cannot move a column outside of the grid when working on the Order tab. Similarly, you cannot move an existing page control from elsewhere on the page into the grid. You can perform both of these operations on the Layout tab.
You can resize analytic grids in PeopleSoft Application Designer by dragging the right border of the grid. The size of individual columns is determined by the data they contain. The height of the analytic grid is determined by the number of rows it contains. If the number of columns extends beyond the maximum width of the page, a scroll bar is introduced to enable end users to scroll through the columns.
Note: When designing analytic grids, keep in mind that the row header, which you do not see in PeopleSoft Application Designer, takes up some of the width of the analytic grid that is displayed to end users.