Technical data
Chapter 12 Understanding th e Relationship of Analytic Types to Analytic Models
Example of mapping data cubes and dimensions to the fields of the QE_ACE_EMPL1 record
When mapping dimensions and data cubes, you may want to map dimensions to the key fields in the main
record and data cubes to the non-key fields in the main record. The PeopleSoft system, however, does enable
you to map dimensions to non-key and data cubes to key fields. To perform the most appropriate mapping, you
must have a deeper understanding of the relationship between data cubes and dimensions.
See C
hapter 3, “Understanding Analytic Models,” Data Cubes and Dimensions, page 16.
See Also
Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Optimization Framework, “Designing Analytic Type
Definitions”
Relationship of Record Attributes to Data Caching Behavior
When you create an analytic type definition, how you set the record attributes determines the caching behavior
of the data that is used in the analytic model. This section describes analytic type definition record attributes
and their effects on data caching.
Read Once
When you map a cube collection to a record that contains a Read Once attribute in the analytic type, the
application data is read only once during analytic model load time. Map cube collections to Read Once records
to load data that the user should not change during the analytic model’s life cycle. You can specify the Read
Once attribute for these record types:
Copyright © 1988-2007, Oracl e. All rights reserved. 205