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.