1. Functional Configuration Reference for Business Intelligence Applications
  2. Functional Configuration Task Reference
  3. About Configuring Projects Forecast Fact for PeopleSoft

About Configuring Projects Forecast Fact for PeopleSoft

Estimate to Complete (ETC not to be confused with the Analysis Type value 'ETC') Cost and Revenue data from PeopleSoft Projects Costing area source is extracted for Project Forecast. Users would need to configure the analysis types for Estimate to Complete Analysis Types in the PROJ_FORECAST_FILTER in the FSM.

In the FSM, go to 'Manage Data Load Parameters section'; filter for Source PeopleSoft 9.0 or 9.1 FINSCM, filter Offering Oracle Project Analytics, filter Functional Area Project Control and Costing.

For Variable PROJ_FORECAST_FILTER set the Analysis types for Cost and Revenue metrics from Projects Costing Area in quotes for example 'ETC','ETB'.

Identifying Project Forecast Costs and Revenue ETC Metrics Based on Analysis Type, Source Type, Category, and Subcategory Combination of Values

You must configure the following flat files to identify Project Forecast ETC Costs and Revenues based on a Analysis Type (Mandatory), Source Type, Category, and Subcategory combination of values.

Note:

If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows:

  1. From the Tasks bar, click Define Business Intelligence Applications.

  2. Click Actions, then Manage Source Configuration Data Files.

  3. Click the Export Source Configuration Data Files option on the tool bar.

  4. Move the required files to the right hand list, then click Export.

  • Configuring file_Project_Forecast_config_psft.csv

    The ETL process uses this flat file to designate which columns (Analysis Type, Source Type, Category, and Subcategory) are used in the lookup. A parameter specified in Configuration Manager determines whether this lookup is performed for an implementation.

    Example (1) if you wish to configure the filter only on Analysis Type then:

    Description of table1-gif.gif follows
    Description of the illustration table1-gif.gif

    Example (2) if you wish to configure the filter on RESOURCE_CAT and RESOURCE TYPE then (ANALYSIS_TYPE is mandatory):

    Description of table2-gif.gif follows
    Description of the illustration table2-gif.gif

  • Configuring file_Project_Forecast_psft.csv

    The ETL process uses this flat file to list all Analysis Type, Source Type, Category, and Subcategory combination of values to use for Project Forecast ETC Cost and Revenue. Example for the above configuration in (1):

    Description of table3-gif.gif follows
    Description of the illustration table3-gif.gif

    Example for the configuration in (2):

    Description of table4-gif.gif follows
    Description of the illustration table4-gif.gif