About Configuring Project Commitment Fact for PeopleSoft
The commitment subject area from PeopleSoft is filtered from the source by filtering on the PS_INSTALLATION_PC table to ensure the analysis types for commitment transactions of Purchase Orders and Requisitions are mapped appropriately in PeopleSoft.
Configuration of Commitment Snapshot
Commitment data being transient, a snapshot table W_PROJ_COMMITMENT_SNP_F is populated. The grain of data in the snapshot table is controlled by ETL parameter PROJ_COMMITMENT_GRAIN. This parameter is set in the FSM and can have values WEEK, MONTH, QUARTER and YEAR. Example: PROJ_COMMITMENT_GRAIN = 'WEEK' would mean that the snapshot table stores one snapshot per week. So if the ETL is run multiple times within a week, the last snapshot will keep overwriting the older one until the end of the week. The Friday record will be kept, and a new record will be generated next Monday for the new week. This Grain is specified using Tasks in FSM. The default is set to 'Month'.
Set the value for this variable in the FSM by navigating to Manage Data Load Parameters section'; filter for offering Oracle Project Analytics.