Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

231

232

233

234

235

236

237

238

239

240

Creating Analytic Grids Chapter 13

Producing an analytic grid involves many of the same tasks as generating a regular grid. These include

inserting and resizing grid controls, inserting and manipulating grid columns, and setting column

properties. In addition, you set certain analytic grid properties b y using the Analytics tab, Use tab,

Label tab, and General tab in the Analytic Grid Properties dialog box.

See C

hapter 13

, “Creating Analytic Grids,” Setting Column Properties for Analytic Grids, page 224.

See C

hapter 13, “Creating Analytic Grids,” Setting Analytic Grid Label Properties, page 217.

See C

hapter 13, “Creating Analytic Grids,” Setting Analytic Grid Use Properties, page 218.

See C

hapter 13

, “Creating Analytic Grids,” Setting Analytic Grid General Properties, page 220.

You can also co

ntrol the analytic grid layout programmatically using analytic grid APIs.

See Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference, “Analytic Calculation

Engine Classes,” GetLayout.

See Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference, “Analytic Grid Classes,”

SetLayout.

You can popula

te the grid with data in two ways: use the PeopleCode analytic grid classes or have the system

populate the

analytic grid with data automatically.

See Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference, “Analytic Grid Classes”.

To populate the analytic grid data automatically:

1. Insert i nto t

he page any control from which you can obtain analytic instance values—for example, an

edit box.

2. Set this cont

rol’s properties to the analytic instance (select the appropriate record and field name on

the Record ta

b); this will be the analytic instance field you select in the Analytics tab of the Analytic

Grid Propert

ies dialog box.

3. Drag the appr

opriate record onto the grid.

Although the developer determines the initial layout of the analytic grid using PeopleSoft Application

Designer, one of the primary advantages of the analytic grid is that end users can also modify the layout of the

grid at runtime. Among other things, end users can use the analytic grid to:

• Pivot data—for example, swap row and column orientations.

• Perform hierarchy-related actions such as expanding, collapsing, drilling in, and drilling out in the data.

• Slice data—for example, view a subset of a multidimensional array.

• Hide non-dimensional fields.

• Modify data.

• Save the current view settings.

• Restore the defaults as specified by the application.

See Enterpr

ise PeopleTools 8.49 PeopleBook: Using PeopleSoft Applications, “Working With Pages,”

Working wit

h Analytic Grids.

Components for Working with Analytic Grids

You design a

nalytic grids using PeopleSoft Application Designer. In addition, you may need to work with

analytic gr

ids in the runtime environment.