Purpose of Analytic Type Definitions

You create analytic type definitions for use with PeopleSoft Optimization Framework and Analytic Calculation Engine. In PeopleSoft Optimization Framework, you create analytic type definitions to group optimization records, optimization transactions, and optimization plug-ins together as one entity.

See Creating Analytic Type Definitions.

In Analytic Calculation Engine, you create analytic type definitions to group records and an analytic model together as one entity. You follow the same procedure to create analytic type definitions for both PeopleSoft Optimization Framework and Analytic Calculation Engine.

When creating a new analytic model definition, you create the analytic type definition in this developmental sequence:

  1. Create and save an analytic model definition.

    See Understanding the Analytic Model Definition Creation Process.

  2. Create an analytic type definition and define records.

    See Example: Working with an Analytic Type and an Analytic Model, Viewing Record Definitions, Saving Record Definitions, Creating New Record Definitions, Setting Record Properties.

  3. Associate the analytic model with the analytic type.

    See Creating Analytic Type Definitions.

  4. In the cube collection properties, map a main record in the analytic type to the cube collection.

    You can also map an aggregate record in the analytic type to the cube collection.

    See Mapping a Cube Collection to Main and Aggregate Records.

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

    See Mapping Data Cubes and Dimensions to Fields.

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 Configuring Analytic Type Records.

  2. Create a new cube collection in the analytic model definition.

    See Understanding Cube Collections, Understanding Types of Cube Collections, Creating Cube Collections, Defining Cube Collection Properties.

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

    See Mapping a Cube Collection to Main and Aggregate Records.

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

    See Mapping Data Cubes and Dimensions to Fields.

The following example illustrates the typical process for creating an analytic type definition to be used with a new analytic model. In this example, you create an analytic type definition called QE_ACE_DGCPROB and define the records that are used in the analytic model. You insert all of these records (except derived/work records) into the analytic type definition and set the attributes of the records.

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 Understanding Cube Collections.

To create an analytic type definition to be used with a new analytic model:

  1. Define the records within the QE_ACE_DBCPROB analytic type definition.

    Image: Records tab

    Example of defining the records within the QE_ACE_DBCPROB analytic type definition.

    Example of defining the records within the QE_ACE_DBCPROB analytic type definition

  2. Using the information in the following table, you create an analytic model definition called QE_ACE_DGCMODEL, with data cubes and dimensions that are related in this manner.

    Data Cube

    Attached Dimensions

    SALARY input data cube

    These dimensions are attached to the SALARY data cube:

    • BUSINESS_UNIT

    • DEPTID

    • EMPLID

    • JOBCODE

    EXPENSE input data cube

    These dimensions are attached to the EXPENSE data cube:

    • BUSINESS_UNIT

    • DEPTID

    • EMPLID

    • JOBCODE

    BONUS_PERCENT input data cube

    These dimensions are attached to the BONUS_PERCENT data cube:

    • BUSINESS_UNIT

    • DEPTID

    • EMPLID

    • JOBCODE

    Note: At this step in the process, you do not create the analytic model definition's cube collections.

  3. On the Models tab, you associate the QE_ACE_DBCPROB analytic type to the QE_ACE_DGCMODEL analytic model.

    Image: Models tab

    Example of associating the QE_ACE_DBCPROB analytic type to the QE_ACE_DGCMODEL analytic model.

    Example of associating the QE_ACE_DBCPROB analytic type to the QE_ACE_DGCMODEL analytic model

  4. You open the analytic model definition and create a read/write cube collection called QE_ACE_EMPLOYEE1_IN.

  5. On the General tab of the cube collection's properties, you map the cube collection to the QE_ACE_EMPL1 main record.

    Image: General tab

    Example of mapping the QE_ACE_EMPLOYEE1_IN cube collection to the QE_ACE_EMPL1 main record.

    Example of mapping the QE_ACE_EMPLOYEE1_IN cube collection to the QE_ACE_EMPL1 main record

    Note: This cube collection does not use an aggregate record.

  6. On the Field Map tab, you map the fields in the QE_ACE_EMPL1 record to the data cubes and dimensions.

    Image: Field Map tab

    Example of mapping data cubes and dimensions to the fields of the QE_ACE_EMPL1 record.

    Example of mapping data cubes and dimensions to the fields of the QE_ACE_EMPL1 record

    Note: 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 Data Cubes and Dimensions.