Technical data

Chapter 13 Creating Analytic Grids
Note. The analytic grid supports a minimum of 2 columns (one for row axis and one for data) and a
maximum of 101 columns (one for column axis a nd 100 for data). The default maximum number of c olumns
is 41. You can also use the ACEGRDCOLS option in PeopleSoft Personalizations to set the number o f
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 Freeze Column Mode is selected, 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
Freeze Column Mode 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 p age 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.
See Enterprise PeopleTools 8.49 PeopleBook: Security Administration, “Managing PeopleSoft
Personalizations,” Working with Personalization Options.
Note. The order of the dimensions in the analytic grid does not need to match the o rder 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.
Inserting Analytic Grid Columns
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 ca
n insert these page controls within analytic grids: edit boxes, long edit boxes, images, push
buttons, an
d check boxes.
Note. 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 Analyti
c 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 u sed for related display/related edit. All the fields in
the record d
efinition that are mapped to either a dimension or a field should have a representative c olumn in
the analyti
cgrid.
Deleting Analytic Grid Columns
To delete an
analytic grid column:
1. Select a column by clicking the column heading.
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 c olumn. The column is selected when it turns black. The whole
analytic grid is selected when control boxes appear around the edges of the grid.
Copyright © 1988-2007, Oracl e. All rights reserved. 223