On this page you will find the specifications regarding the Model: Project and Fact Table: PROJECT FORECAST ITEM PFI.
This model fact represents project forecast items information and is based on the IFS Cloud fact FACT_PROJ_FORECAST_ITEM
Note: Please refer to documentation of each model to find out about attributes used in referenced models.
Attribute | Description (where applicable) |
Fact Proj Forecast Item ID | Project Forecast Item ID |
Line Description | Line Description |
Line Status | Line Status |
Financially Responsible Code | Line Financially Responsible |
Financially Responsible | Line Financially Responsible Code |
Confirmed By | Represents the responsible user for the confirmation |
Forecast Item Type | Forecast Item Type |
Created By Snapshot | Created By Snapshot |
Cost Struct Item Type | Cost Structure Item Type |
Cut Off Year | Cut off year |
Forecast Id Key | Forecast Id, part of PK in original source |
Item No Key | Item No, part of PK in original source |
Cut Off Period | Cut off period |
Aggregation of measures is based on SUM if not explicitly noted.
This section describes the basic measures in the cube. These are either measures defined in the core Information Source, in the model itself or in the ETL process. The columns have the following meaning:
Measure | Calculated Y/N | Contains Time Intelligence Y/N | Definition/Note (where applicable) | Aggregation Type | Hidden Y/N | Measure Expression |
Actual Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ACTUAL_BUDGET]) | |
Actual Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ACTUAL_BUDGET_REV]) | |
Adjusted ETC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ADJUSTED_ETC_BUDGET]) | |
Adjusted ETC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ADJUSTED_ETC_BUDGET_REV]) | |
Budget Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([BUDGET_BUDGET]) | |
Budget Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([BUDGET_BUDGET_REV]) | |
Committed Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([COMMITTED_BUDGET]) | |
Connected ETC CCO Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([CONNECTED_ETC_CCO_BUDGET]) | |
Connected ETC CCO Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([CONN_ETC_CCO_BUDGET_REV]) | |
Connected ETC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([CONNECTED_ETC_BUDGET]) | |
Connected ETC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([CONN_ETC_BUDGET_REV]) | |
EAC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EAC_BUDGET]) | |
EAC Net Change Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EAC_NET_CHANGE_BUDGET]) | |
EAC Net Change Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EAC_NET_CHANGE_BUDGET_REV]) | |
EAC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EAC_BUDGET_REV]) | |
ETC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ETC_BUDGET]) | |
ETC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ETC_BUDGET_REV]) | |
Earned Value Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EARNED_VALUE_BUDGET]) | |
Earned Value Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([EARNED_VALUE_BUDGET_REV]) | |
Estimated Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ESTIMATED_BUDGET]) | |
Estimated Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([ESTIMATED_BUDGET_REV]) | |
Planned Committed Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PLANNED_COMMITTED_BUDGET]) | |
Planned Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PLANNED_BUDGET]) | |
Planned Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PLANNED_BUDGET_REV]) | |
Posted Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([POSTED_BUDGET_REV]) | |
Preliminary Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PRELIMINARY_BUDGET_REV]) | |
Previous EAC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PREVIOUS_EAC_BUDGET]) | |
Previous EAC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PREVIOUS_EAC_BUDGET_REV]) | |
Previous ETC Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PREVIOUS_ETC_BUDGET]) | |
Previous ETC Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([PREVIOUS_ETC_BUDGET_REV]) | |
Unspread Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([UNSPREAD_AMOUNT_BUDGET]) | |
Unspread Rev Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([UNSPREAD_AMOUNT_BUDGET_REV]) | |
Used Cost Budget Curr PFI | N | N | Budget Currency calculation | N | SUM([USED_BUDGET]) | |
Actual Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ACTUAL_PROJECT]) | |
Actual Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ACTUAL_PROJECT_REV]) | |
Adjusted ETC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ADJUSTED_ETC_PROJECT]) | |
Adjusted ETC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ADJUSTED_ETC_PROJECT_REV]) | |
Budget Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([BUDGET_PROJECT]) | |
Budget Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([BUDGET_PROJECT_REV]) | |
Committed Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([COMMITTED_PROJECT]) | |
Connected ETC CCO Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([CONNECTED_ETC_CCO_PROJECT]) | |
Connected ETC CCO Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([CONN_ETC_CCO_PROJECT_REV]) | |
Connected ETC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([CONNECTED_ETC_PROJECT]) | |
Connected ETC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([CONN_ETC_PROJECT_REV]) | |
EAC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EAC_PROJECT]) | |
EAC Net Change Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EAC_NET_CHANGE_PROJECT]) | |
EAC Net Change Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EAC_NET_CHANGE_PROJECT_REV]) | |
EAC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EAC_PROJECT_REV]) | |
ETC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ETC_PROJECT]) | |
ETC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ETC_PROJECT_REV]) | |
Earned Value Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EARNED_VALUE_PROJECT]) | |
Earned Value Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([EARNED_VALUE_PROJECT_REV]) | |
Estimated Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ESTIMATED_PROJECT]) | |
Estimated Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([ESTIMATED_PROJECT_REV]) | |
Planned Committed Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PLANNED_COMMITTED_PROJECT]) | |
Planned Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PLANNED_PROJECT]) | |
Planned Revenue Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PLANNED_PROJECT_REV]) | |
Posted Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([POSTED_PROJECT_REV]) | |
Preliminary Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PRELIMINARY_PROJECT_REV]) | |
Previous EAC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PREVIOUS_EAC_PROJECT]) | |
Previous EAC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PREVIOUS_EAC_PROJECT_REV]) | |
Previous ETC Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PREVIOUS_ETC_PROJECT]) | |
Previous ETC Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([PREVIOUS_ETC_PROJECT_REV]) | |
Unspread Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([UNSPREAD_AMOUNT_PROJECT]) | |
Unspread Rev Proj Curr PFI | N | N | Project Currency calculation | N | SUM([UNSPREAD_AMOUNT_PROJECT_REV]) | |
Used Cost Proj Curr PFI | N | N | Project Currency calculation | N | SUM([USED_PROJECT]) | |
Actual Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ACTUAL])/[Currency Rate] | |
Actual Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ACTUAL_REV])/[Currency Rate] | |
Adjusted ETC Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ADJUSTED_ETC])/[Currency Rate] | |
Adjusted ETC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ADJUSTED_ETC_REV])/[Currency Rate] | |
Budget Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_BUDGET])/[Currency Rate] | |
Budget Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_BUDGET_REV])/[Currency Rate] | |
Connected ETC CCO Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_CONNECTED_ETC_CCO])/[Currency Rate] | |
Connected ETC CCO Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_CONN_ETC_CCO_REV])/[Currency Rate] | |
Connected ETC Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_CONNECTED_ETC])/[Currency Rate] | |
Connected ETC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_CONN_ETC_REV ])/[Currency Rate] | |
EAC Cost RC PFI | N | Y | Reporting Currency calculation | N | SUM([REP_CURR_EAC])/[Currency Rate] | |
EAC Net Change Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_EAC_NET_CHANGE])/[Currency Rate] | |
EAC Net Change Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_EAC_NET_CHANGE_REV])/[Currency Rate] | |
EAC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_EAC_REV])/[Currency Rate] | |
ETC Cost RC PFI | N | Y | Reporting Currency calculation | N | SUM([REP_CURR_ETC])/[Currency Rate] | |
ETC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ETC_REV])/[Currency Rate] | |
Earned Value Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_EARNED_VALUE])/[Currency Rate] | |
Earned Value Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_EARNED_VALUE_REV])/[Currency Rate] | |
Estimated Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ESTIMATED])/[Currency Rate] | |
Estimated Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_ESTIMATED_REV])/[Currency Rate] | |
Planned Committed Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PLANNED_COMMITTED])/[Currency Rate] | |
Planned Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PLANNED])/[Currency Rate] | |
Planned Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PLANNED_REV])/[Currency Rate] | |
Posted Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_POSTED_REV])/[Currency Rate] | |
Preliminary Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PRELIMINARY_REV])/[Currency Rate] | |
Previous EAC Cost RC PFI | N | Y | Reporting Currency calculation | N | SUM([REP_CURR_PREVIOUS_EAC])/[Currency Rate] | |
Previous EAC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PREVIOUS_EAC_REV])/[Currency Rate] | |
Previous ETC Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PREVIOUS_ETC])/[Currency Rate] | |
Previous ETC Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_PREVIOUS_ETC_REV])/[Currency Rate] | |
Unspread Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_UNSPREAD_AMOUNT])/[Currency Rate] | |
Unspread Rev RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_UNSPREAD_AMOUNT_REV])/[Currency Rate] | |
Used Cost RC PFI | Y | Y | Reporting Currency calculation | N | SUM([REP_CURR_USED])/[Currency Rate] | |
Actual Cost Trans Curr PFI | N | N | N | SUM([ACTUAL_TRANSACTION]) | ||
Actual Rev Trans Curr PFI | N | N | N | SUM([ACTUAL_TRANS_REV]) | ||
Adjusted ETC Cost Trans Curr PFI | N | N | N | SUM([ADJUSTED_ETC_TRANSACTION]) | ||
Adjusted ETC Rev Trans Curr PFI | N | N | N | SUM([ADJUSTED_ETC_TRANSACTION_REV]) | ||
Budget Cost Trans Curr PFI | N | N | Budget Currency calculation | N | SUM([BUDGET_TRANSACTION]) | |
Budget Rev Trans Curr PFI | N | N | Budget Currency calculation | N | SUM([BUDGET_TRANS_REV]) | |
Committed Cost Trans Curr PFI | N | N | N | SUM([COMMITTED_TRANSACTION]) | ||
Connected ETC CCO Cost Trans Curr PFI | N | N | N | SUM([CONNECTED_ETC_CCO_TRANSACTION]) | ||
Connected ETC CCO Rev Trans Curr PFI | N | N | N | SUM([CONN_ETC_CCO_TRANSACTION_REV]) | ||
Connected ETC Cost Trans Curr PFI | N | N | N | SUM([CONNECTED_ETC_TRANSACTION]) | ||
Connected ETC Rev Trans Curr PFI | N | N | N | SUM([CONN_ETC_TRANSACTION_REV]) | ||
EAC Cost Trans Curr PFI | N | N | N | SUM([EAC_TRANSACTION]) | ||
EAC Net Change Cost Trans Curr PFI | N | N | N | SUM([EAC_NET_CHANGE_TRANSACTION]) | ||
EAC Net Change Rev Trans Curr PFI | N | N | N | SUM([EAC_NET_CHANGE_TRANS_REV]) | ||
EAC Rev Trans Curr PFI | N | N | N | SUM([EAC_TRANS_REV]) | ||
ETC Cost Trans Curr PFI | N | N | N | SUM([ETC_TRANSACTION]) | ||
ETC Rev Trans Curr PFI | N | N | N | SUM([ETC_TRANS_REV]) | ||
Earned Value Cost Trans Curr PFI | N | N | N | SUM([EARNED_VALUE_TRANSACTION]) | ||
Earned Value Rev Trans Curr PFI | N | N | N | SUM([EARNED_VALUE_TRANS_REV]) | ||
Estimated Cost Trans Curr PFI | N | N | N | SUM([ESTIMATED_TRANSACTION]) | ||
Estimated Rev Trans Curr PFI | N | N | N | SUM([ESTIMATED_TRANS_REV]) | ||
Planned Committed Cost Trans Curr PFI | N | N | N | SUM([PLANNED_COMMITTED_TRANSACTION]) | ||
Planned Cost Trans Curr PFI | N | N | N | SUM([PLANNED_TRANSACTION]) | ||
Planned Rev Trans Curr PFI | N | N | N | SUM([PLANNED_TRANS_REV]) | ||
Posted Rev Trans Curr PFI | N | N | N | SUM([POSTED_TRANS_REV]) | ||
Preliminary Rev Trans Curr PFI | N | N | N | SUM([PRELIMINARY_TRANS_REV]) | ||
Previous EAC Cost Trans Curr PFI | N | N | N | SUM([PREVIOUS_EAC_TRANSACTION]) | ||
Previous EAC Rev Trans Curr PFI | N | N | N | SUM([PREVIOUS_EAC_TRANS_REV]) | ||
Previous ETC Cost Trans Curr PFI | N | N | N | SUM([PREVIOUS_ETC_TRANSACTION]) | ||
Previous ETC Rev Trans Curr PFI | N | N | N | SUM([PREVIOUS_ETC_TRANS_REV]) | ||
Unspread Cost Trans Curr PFI | N | N | N | SUM([UNSPREAD_AMOUNT_TRANSACTION]) | ||
Unspread Rev Trans Curr PFI | N | N | N | SUM([UNSPREAD_AMOUNT_TRANS_REV]) | ||
Used Cost Trans Curr PFI | N | N | N | SUM([USED_TRANSACTION]) | ||
Actual Cost PFI | N | N | N | SUM([ACTUAL]) | ||
Actual Rev PFI | N | N | N | SUM([ACTUAL_REV]) | ||
Adjusted ETC Cost PFI | N | N | N | SUM([ADJUSTED_ETC]) | ||
Adjusted ETC Rev PFI | N | N | N | SUM([ADJUSTED_ETC_REV]) | ||
Budget Cost PFI | N | N | Budget Currency calculation | N | SUM([BUDGET]) | |
Budget Rev PFI | N | N | Budget Currency calculation | N | SUM([BUDGET_REV]) | |
Committed Cost PFI | N | N | N | SUM([COMMITTED]) | ||
Connected ETC CCO Cost PFI | N | N | N | SUM([CONNECTED_ETC_CCO]) | ||
Connected ETC CCO Rev PFI | N | N | N | SUM([CONN_ETC_CCO_REV]) | ||
Connected ETC Cost PFI | N | N | N | SUM([CONNECTED_ETC]) | ||
Connected ETC Rev PFI | N | N | N | SUM([CONN_ETC_REV]) | ||
EAC Cost PFI | N | N | N | SUM([EAC]) | ||
EAC Net Change Cost PFI | N | N | N | SUM([EAC_NET_CHANGE]) | ||
EAC Net Change Rev PFI | N | N | N | SUM([EAC_NET_CHANGE_REV]) | ||
EAC Rev PFI | N | N | N | SUM([EAC_REV]) | ||
ETC Cost PFI | N | N | N | SUM([ETC]) | ||
ETC Rev PFI | N | N | N | SUM([ETC_REV]) | ||
Earned Value Cost PFI | N | N | N | SUM([EARNED_VALUE]) | ||
Earned Value Rev PFI | N | N | N | SUM([EARNED_VALUE_REV]) | ||
Estimated Cost PFI | N | N | N | SUM([ESTIMATED]) | ||
Estimated Rev PFI | N | N | N | SUM([ESTIMATED_REV]) | ||
Planned Committed Cost PFI | N | N | N | SUM([PLANNED_COMMITTED]) | ||
Planned Cost PFI | N | N | N | SUM([PLANNED]) | ||
Planned Rev PFI | N | N | N | SUM([PLANNED_REV]) | ||
Posted Rev PFI | N | N | N | SUM([POSTED_REV]) | ||
Preliminary Rev PFI | N | N | N | SUM([PRELIMINARY_REV]) | ||
Previous EAC Cost PFI | N | N | N | SUM([PREVIOUS_EAC]) | ||
Previous EAC Rev PFI | N | N | N | SUM([PREVIOUS_EAC_REV]) | ||
Previous ETC Cost PFI | N | N | N | SUM([PREVIOUS_ETC]) | ||
Previous ETC Rev PFI | N | N | N | SUM([PREVIOUS_ETC_REV]) | ||
Unspread Cost PFI | N | N | N | SUM([UNSPREAD_AMOUNT]) | ||
Unspread Rev PFI | N | N | N | SUM([UNSPREAD_AMOUNT_REV]) | ||
Used Cost PFI | N | N | N | SUM([USED]) |
Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of the different time measures. These measures need to be used with a specific time dimension hierarchy [REPORTING_DATE].[RepDateMFHy].
Measure | Meaning |
YTD |
Aggregated value for current month in current year. E.g.
for period 202010 Ytd represents sum of periods 202000-202010. |
R12 |
For a given period, the sum all months from one year back up to the
previous month. E.g. Rolling 12 for 202010 is the sum of months 201910
- 202009 |
PY |
Previous Year The value of the corresponding month one year back. E.g. for month 202010, the value of month 201910. |
YTD PY |
Year to Date Previous Year Aggregated value for corresponding month one year back. E.g. for month 202010 YTD Previous Year represents sum of months 201901-201910. |
R12 PY |
Rolling 12 (completed) Months Previous Year For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 202010 the sum of month 201810-201909 |
Avg XXX Ytd | Sum XXX YTD/Count XXX YTD |
Avg XXX R12 | Sum XXX R12/Count XXX R12 |
XXX % YTD | Count XXX YTD/Count YYY YTD |
XXX % R12 | Count XXX R12/Count XXX R12 |
Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
PROJECT FORECAST ITEM PFI | FACT_PROJ_FORECAST_ITEM_PQ_BI | FACT_PROJ_FORECAST_ITEM_PQ | On Line |