Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

221

222

223

224

225

226

227

228

229

230

Understanding the Relationship of Analytic Types to Analytic Models Chapter 12

5. In the cube collection properties, map the fields in the record to data cubes and dimensions.

See C

hapter 7, “

Creating Cube Collections,” Mapping Data Cubes and Dimensions t o Fields, page 59.

When updating an analytic model definition, create an analytic type definition during this developmental

sequence:

1. Update the records in the analytic type definition.

See Enterpris

e PeopleTools 8.49 PeopleBook: PeopleSoft Optimization Framework,“Designing

Analytic Type

Definitions,” Configuring Analytic Type Records.

2. Create a new cu

be collection in the analytic model definition.

See C

hapter 7, “Creating Cube Collections,” page 53.

3. In the cube collection properties, map one of the updated records to the cube collection.

See C

hapter 7 , “Creating Cube Collections,” Mapping a Cube Collection to Main and Aggregate

Records, page 58.

4. In the cube collection properties, map fields of the updated record to data cubes and dimensions.

See C

hapter 7,

“Creating Cube Collections,” Mapping D ata Cubes and Dimensions to Fields, page 59.

Example: Working with an Analytic Type and an Analytic Model

This example i

llustrates the typical process for creating an analytic type definition to be used with a new

analytic mode

Note. For simplicity, this example maps only one cube collection to a main record, although the analytic model

definition in this example contains several records which would be used with several cube collections. The

record used in this example is mapped to a read/write cube collection for loading data from the database,

receiving end user input, and persisting data back to the database.

See Chapter 7, “Creating Cube Col l ections,” Understanding Cube Collec t i ons, page 53.

You create an

analytic type definition called QE_ACE_DGCPROB and define the records that are used in the

analytic mod

el. You insert all of these records (except derived/work records) into the analytic type definition

and set the at

tributes of the records, as shown in this example:

Example of defining the records within the QE_ACE_DBCPROB analytic type definition

Next, you create an analytic model d efinition called QE_ACE_DGCMODEL, with data cubes and dimensions

that are related in this manner: