Actual Costs are extracted from Project Costing for all Analysis Types within the project's Actual Cost Analysis Group.
All costs extracted will be loaded into the Cost Fact Line table as Raw Cost unless you perform one or both of these configurations:
The ETL process uses the file_Project_Cost_Burden_Analysis_Type_psft.csv
flat file to list all Analysis Types for Project Cost Burden Cost.
To use this identification during the ETL process, you need to set the variable BURDEN_ANALYSIS_TYPE to 1 in FSM
If the ETL process finds the Analysis Type in this flat file, it will not perform further lookups against other lookup tables to determine Project Cost Burden Cost.
FSM parameter BURDEN_ANALYSIS_TYPE is common to both Cost and Budget subject areas to identify Burden Costs.
If the requirements differ between Project Budget and Project Cost in your implementation you can create separate FSM and ODI variables for the same. In the case of creating separate FSM variables for budget and cost facts to identify burden costs, the ETL would need to be modified to use these new variables.
To identify the Project Cost Burden Costs based on Analysis Type:
You must configure the following flat files to identify Project Cost Burden Costs based on a Source Type, Category, and Subcategory combination of values: file_Project_Cost_Burden_TypeCatSub_config_psft.csv
. Use this flat file to specify all the columns among (Source Type, Category, and Subcategory) to use in the lookup: file_Project_Cost_Burden_TypeCatSub_psft.csv
.
To use this identification during the ETL process, you need to set the variable BURDEN_TYPECATSUB to 1 in FSM.
Based on the columns entered in the previous csv file, use this flat file to list all Source Type, Category, and Subcategory combination of values to use as Project Cost Burden Cost.
Note:
Both Project Budget and Project Cost use these flat files to load data to W_PROJ_LOOKUP_PS table, along with a FSM parameter, to identify Burden Costs.You can customize these files if the requirements differ between Project Budget and Project Cost in your implementation.