Model: Project - Specifications for Fact Table: PROJECT FORECAST ITEM PFI

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.

Attributes

Attribute Description (where applicable)
Fact Proj Forecast Item IDProject Forecast Item ID
Line DescriptionLine Description
Line StatusLine Status
Financially Responsible CodeLine Financially Responsible
Financially ResponsibleLine Financially Responsible Code
Confirmed ByRepresents the responsible user for the confirmation
Forecast Item TypeForecast Item Type
Created By SnapshotCreated By Snapshot
Cost Struct Item TypeCost Structure Item Type
Cut Off YearCut off year
Forecast Id KeyForecast Id, part of PK in original source
Item No KeyItem No, part of PK in original source
Cut Off PeriodCut off period

Measures (table to be generated as far as possible)

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 PFINNBudget Currency calculationNSUM([ACTUAL_BUDGET])
Actual Rev Budget Curr PFINNBudget Currency calculationNSUM([ACTUAL_BUDGET_REV])
Adjusted ETC Cost Budget Curr PFINNBudget Currency calculationNSUM([ADJUSTED_ETC_BUDGET])
Adjusted ETC Rev Budget Curr PFINNBudget Currency calculationNSUM([ADJUSTED_ETC_BUDGET_REV])
Budget Cost Budget Curr PFINNBudget Currency calculationNSUM([BUDGET_BUDGET])
Budget Rev Budget Curr PFINNBudget Currency calculationNSUM([BUDGET_BUDGET_REV])
Committed Cost Budget Curr PFINNBudget Currency calculationNSUM([COMMITTED_BUDGET])
Connected ETC CCO Cost Budget Curr PFINNBudget Currency calculationNSUM([CONNECTED_ETC_CCO_BUDGET])
Connected ETC CCO Rev Budget Curr PFINNBudget Currency calculationNSUM([CONN_ETC_CCO_BUDGET_REV])
Connected ETC Cost Budget Curr PFINNBudget Currency calculationNSUM([CONNECTED_ETC_BUDGET])
Connected ETC Rev Budget Curr PFINNBudget Currency calculationNSUM([CONN_ETC_BUDGET_REV])
EAC Cost Budget Curr PFINNBudget Currency calculationNSUM([EAC_BUDGET])
EAC Net Change Cost Budget Curr PFINNBudget Currency calculationNSUM([EAC_NET_CHANGE_BUDGET])
EAC Net Change Rev Budget Curr PFINNBudget Currency calculationNSUM([EAC_NET_CHANGE_BUDGET_REV])
EAC Rev Budget Curr PFINNBudget Currency calculationNSUM([EAC_BUDGET_REV])
ETC Cost Budget Curr PFINNBudget Currency calculationNSUM([ETC_BUDGET])
ETC Rev Budget Curr PFINNBudget Currency calculationNSUM([ETC_BUDGET_REV])
Earned Value Cost Budget Curr PFINNBudget Currency calculationNSUM([EARNED_VALUE_BUDGET])
Earned Value Rev Budget Curr PFINNBudget Currency calculationNSUM([EARNED_VALUE_BUDGET_REV])
Estimated Cost Budget Curr PFINNBudget Currency calculationNSUM([ESTIMATED_BUDGET])
Estimated Rev Budget Curr PFINNBudget Currency calculationNSUM([ESTIMATED_BUDGET_REV])
Planned Committed Cost Budget Curr PFINNBudget Currency calculationNSUM([PLANNED_COMMITTED_BUDGET])
Planned Cost Budget Curr PFINNBudget Currency calculationNSUM([PLANNED_BUDGET])
Planned Rev Budget Curr PFINNBudget Currency calculationNSUM([PLANNED_BUDGET_REV])
Posted Rev Budget Curr PFINNBudget Currency calculationNSUM([POSTED_BUDGET_REV])
Preliminary Rev Budget Curr PFINNBudget Currency calculationNSUM([PRELIMINARY_BUDGET_REV])
Previous EAC Cost Budget Curr PFINNBudget Currency calculationNSUM([PREVIOUS_EAC_BUDGET])
Previous EAC Rev Budget Curr PFINNBudget Currency calculationNSUM([PREVIOUS_EAC_BUDGET_REV])
Previous ETC Cost Budget Curr PFINNBudget Currency calculationNSUM([PREVIOUS_ETC_BUDGET])
Previous ETC Rev Budget Curr PFINNBudget Currency calculationNSUM([PREVIOUS_ETC_BUDGET_REV])
Unspread Cost Budget Curr PFINNBudget Currency calculationNSUM([UNSPREAD_AMOUNT_BUDGET])
Unspread Rev Budget Curr PFINNBudget Currency calculationNSUM([UNSPREAD_AMOUNT_BUDGET_REV])
Used Cost Budget Curr PFINNBudget Currency calculationNSUM([USED_BUDGET])
Actual Cost Proj Curr PFINNProject Currency calculationNSUM([ACTUAL_PROJECT])
Actual Rev Proj Curr PFINNProject Currency calculationNSUM([ACTUAL_PROJECT_REV])
Adjusted ETC Cost Proj Curr PFINNProject Currency calculationNSUM([ADJUSTED_ETC_PROJECT])
Adjusted ETC Rev Proj Curr PFINNProject Currency calculationNSUM([ADJUSTED_ETC_PROJECT_REV])
Budget Cost Proj Curr PFINNProject Currency calculationNSUM([BUDGET_PROJECT])
Budget Rev Proj Curr PFINNProject Currency calculationNSUM([BUDGET_PROJECT_REV])
Committed Cost Proj Curr PFINNProject Currency calculationNSUM([COMMITTED_PROJECT])
Connected ETC CCO Cost Proj Curr PFINNProject Currency calculationNSUM([CONNECTED_ETC_CCO_PROJECT])
Connected ETC CCO Rev Proj Curr PFINNProject Currency calculationNSUM([CONN_ETC_CCO_PROJECT_REV])
Connected ETC Cost Proj Curr PFINNProject Currency calculationNSUM([CONNECTED_ETC_PROJECT])
Connected ETC Rev Proj Curr PFINNProject Currency calculationNSUM([CONN_ETC_PROJECT_REV])
EAC Cost Proj Curr PFINNProject Currency calculationNSUM([EAC_PROJECT])
EAC Net Change Cost Proj Curr PFINNProject Currency calculationNSUM([EAC_NET_CHANGE_PROJECT])
EAC Net Change Rev Proj Curr PFINNProject Currency calculationNSUM([EAC_NET_CHANGE_PROJECT_REV])
EAC Rev Proj Curr PFINNProject Currency calculationNSUM([EAC_PROJECT_REV])
ETC Cost Proj Curr PFINNProject Currency calculationNSUM([ETC_PROJECT])
ETC Rev Proj Curr PFINNProject Currency calculationNSUM([ETC_PROJECT_REV])
Earned Value Cost Proj Curr PFINNProject Currency calculationNSUM([EARNED_VALUE_PROJECT])
Earned Value Rev Proj Curr PFINNProject Currency calculationNSUM([EARNED_VALUE_PROJECT_REV])
Estimated Cost Proj Curr PFINNProject Currency calculationNSUM([ESTIMATED_PROJECT])
Estimated Rev Proj Curr PFINNProject Currency calculationNSUM([ESTIMATED_PROJECT_REV])
Planned Committed Cost Proj Curr PFINNProject Currency calculationNSUM([PLANNED_COMMITTED_PROJECT])
Planned Cost Proj Curr PFINNProject Currency calculationNSUM([PLANNED_PROJECT])
Planned Revenue Proj Curr PFINNProject Currency calculationNSUM([PLANNED_PROJECT_REV])
Posted Rev Proj Curr PFINNProject Currency calculationNSUM([POSTED_PROJECT_REV])
Preliminary Rev Proj Curr PFINNProject Currency calculationNSUM([PRELIMINARY_PROJECT_REV])
Previous EAC Cost Proj Curr PFINNProject Currency calculationNSUM([PREVIOUS_EAC_PROJECT])
Previous EAC Rev Proj Curr PFINNProject Currency calculationNSUM([PREVIOUS_EAC_PROJECT_REV])
Previous ETC Cost Proj Curr PFINNProject Currency calculationNSUM([PREVIOUS_ETC_PROJECT])
Previous ETC Rev Proj Curr PFINNProject Currency calculationNSUM([PREVIOUS_ETC_PROJECT_REV])
Unspread Cost Proj Curr PFINNProject Currency calculationNSUM([UNSPREAD_AMOUNT_PROJECT])
Unspread Rev Proj Curr PFINNProject Currency calculationNSUM([UNSPREAD_AMOUNT_PROJECT_REV])
Used Cost Proj Curr PFINNProject Currency calculationNSUM([USED_PROJECT])
Actual Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_ACTUAL])/[Currency Rate]
Actual Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_ACTUAL_REV])/[Currency Rate]
Adjusted ETC Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_ADJUSTED_ETC])/[Currency Rate]
Adjusted ETC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_ADJUSTED_ETC_REV])/[Currency Rate]
Budget Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_BUDGET])/[Currency Rate]
Budget Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_BUDGET_REV])/[Currency Rate]
Connected ETC CCO Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_CONNECTED_ETC_CCO])/[Currency Rate]
Connected ETC CCO Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_CONN_ETC_CCO_REV])/[Currency Rate]
Connected ETC Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_CONNECTED_ETC])/[Currency Rate]
Connected ETC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_CONN_ETC_REV ])/[Currency Rate]
EAC Cost RC PFINYReporting Currency calculationNSUM([REP_CURR_EAC])/[Currency Rate]
EAC Net Change Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_EAC_NET_CHANGE])/[Currency Rate]
EAC Net Change Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_EAC_NET_CHANGE_REV])/[Currency Rate]
EAC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_EAC_REV])/[Currency Rate]
ETC Cost RC PFINYReporting Currency calculationNSUM([REP_CURR_ETC])/[Currency Rate]
ETC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_ETC_REV])/[Currency Rate]
Earned Value Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_EARNED_VALUE])/[Currency Rate]
Earned Value Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_EARNED_VALUE_REV])/[Currency Rate]
Estimated Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_ESTIMATED])/[Currency Rate]
Estimated Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_ESTIMATED_REV])/[Currency Rate]
Planned Committed Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_PLANNED_COMMITTED])/[Currency Rate]
Planned Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_PLANNED])/[Currency Rate]
Planned Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_PLANNED_REV])/[Currency Rate]
Posted Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_POSTED_REV])/[Currency Rate]
Preliminary Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_PRELIMINARY_REV])/[Currency Rate]
Previous EAC Cost RC PFINYReporting Currency calculationNSUM([REP_CURR_PREVIOUS_EAC])/[Currency Rate]
Previous EAC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_PREVIOUS_EAC_REV])/[Currency Rate]
Previous ETC Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_PREVIOUS_ETC])/[Currency Rate]
Previous ETC Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_PREVIOUS_ETC_REV])/[Currency Rate]
Unspread Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_UNSPREAD_AMOUNT])/[Currency Rate]
Unspread Rev RC PFIYYReporting Currency calculationNSUM([REP_CURR_UNSPREAD_AMOUNT_REV])/[Currency Rate]
Used Cost RC PFIYYReporting Currency calculationNSUM([REP_CURR_USED])/[Currency Rate]
Actual Cost Trans Curr PFINNNSUM([ACTUAL_TRANSACTION])
Actual Rev Trans Curr PFINNNSUM([ACTUAL_TRANS_REV])
Adjusted ETC Cost Trans Curr PFINNNSUM([ADJUSTED_ETC_TRANSACTION])
Adjusted ETC Rev Trans Curr PFINNNSUM([ADJUSTED_ETC_TRANSACTION_REV])
Budget Cost Trans Curr PFINNBudget Currency calculationNSUM([BUDGET_TRANSACTION])
Budget Rev Trans Curr PFINNBudget Currency calculationNSUM([BUDGET_TRANS_REV])
Committed Cost Trans Curr PFINNNSUM([COMMITTED_TRANSACTION])
Connected ETC CCO Cost Trans Curr PFINNNSUM([CONNECTED_ETC_CCO_TRANSACTION])
Connected ETC CCO Rev Trans Curr PFINNNSUM([CONN_ETC_CCO_TRANSACTION_REV])
Connected ETC Cost Trans Curr PFINNNSUM([CONNECTED_ETC_TRANSACTION])
Connected ETC Rev Trans Curr PFINNNSUM([CONN_ETC_TRANSACTION_REV])
EAC Cost Trans Curr PFINNNSUM([EAC_TRANSACTION])
EAC Net Change Cost Trans Curr PFINNNSUM([EAC_NET_CHANGE_TRANSACTION])
EAC Net Change Rev Trans Curr PFINNNSUM([EAC_NET_CHANGE_TRANS_REV])
EAC Rev Trans Curr PFINNNSUM([EAC_TRANS_REV])
ETC Cost Trans Curr PFINNNSUM([ETC_TRANSACTION])
ETC Rev Trans Curr PFINNNSUM([ETC_TRANS_REV])
Earned Value Cost Trans Curr PFINNNSUM([EARNED_VALUE_TRANSACTION])
Earned Value Rev Trans Curr PFINNNSUM([EARNED_VALUE_TRANS_REV])
Estimated Cost Trans Curr PFINNNSUM([ESTIMATED_TRANSACTION])
Estimated Rev Trans Curr PFINNNSUM([ESTIMATED_TRANS_REV])
Planned Committed Cost Trans Curr PFINNNSUM([PLANNED_COMMITTED_TRANSACTION])
Planned Cost Trans Curr PFINNNSUM([PLANNED_TRANSACTION])
Planned Rev Trans Curr PFINNNSUM([PLANNED_TRANS_REV])
Posted Rev Trans Curr PFINNNSUM([POSTED_TRANS_REV])
Preliminary Rev Trans Curr PFINNNSUM([PRELIMINARY_TRANS_REV])
Previous EAC Cost Trans Curr PFINNNSUM([PREVIOUS_EAC_TRANSACTION])
Previous EAC Rev Trans Curr PFINNNSUM([PREVIOUS_EAC_TRANS_REV])
Previous ETC Cost Trans Curr PFINNNSUM([PREVIOUS_ETC_TRANSACTION])
Previous ETC Rev Trans Curr PFINNNSUM([PREVIOUS_ETC_TRANS_REV])
Unspread Cost Trans Curr PFINNNSUM([UNSPREAD_AMOUNT_TRANSACTION])
Unspread Rev Trans Curr PFINNNSUM([UNSPREAD_AMOUNT_TRANS_REV])
Used Cost Trans Curr PFINNNSUM([USED_TRANSACTION])
Actual Cost PFINNNSUM([ACTUAL])
Actual Rev PFINNNSUM([ACTUAL_REV])
Adjusted ETC Cost PFINNNSUM([ADJUSTED_ETC])
Adjusted ETC Rev PFINNNSUM([ADJUSTED_ETC_REV])
Budget Cost PFINNBudget Currency calculationNSUM([BUDGET])
Budget Rev PFINNBudget Currency calculationNSUM([BUDGET_REV])
Committed Cost PFINNNSUM([COMMITTED])
Connected ETC CCO Cost PFINNNSUM([CONNECTED_ETC_CCO])
Connected ETC CCO Rev PFINNNSUM([CONN_ETC_CCO_REV])
Connected ETC Cost PFINNNSUM([CONNECTED_ETC])
Connected ETC Rev PFINNNSUM([CONN_ETC_REV])
EAC Cost PFINNNSUM([EAC])
EAC Net Change Cost PFINNNSUM([EAC_NET_CHANGE])
EAC Net Change Rev PFINNNSUM([EAC_NET_CHANGE_REV])
EAC Rev PFINNNSUM([EAC_REV])
ETC Cost PFINNNSUM([ETC])
ETC Rev PFINNNSUM([ETC_REV])
Earned Value Cost PFINNNSUM([EARNED_VALUE])
Earned Value Rev PFINNNSUM([EARNED_VALUE_REV])
Estimated Cost PFINNNSUM([ESTIMATED])
Estimated Rev PFINNNSUM([ESTIMATED_REV])
Planned Committed Cost PFINNNSUM([PLANNED_COMMITTED])
Planned Cost PFINNNSUM([PLANNED])
Planned Rev PFINNNSUM([PLANNED_REV])
Posted Rev PFINNNSUM([POSTED_REV])
Preliminary Rev PFINNNSUM([PRELIMINARY_REV])
Previous EAC Cost PFINNNSUM([PREVIOUS_EAC])
Previous EAC Rev PFINNNSUM([PREVIOUS_EAC_REV])
Previous ETC Cost PFINNNSUM([PREVIOUS_ETC])
Previous ETC Rev PFINNNSUM([PREVIOUS_ETC_REV])
Unspread Cost PFINNNSUM([UNSPREAD_AMOUNT])
Unspread Rev PFINNNSUM([UNSPREAD_AMOUNT_REV])
Used Cost PFINNNSUM([USED])

Time Intelligence Measures

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

USED BY MODEL(S)

Model Name

Data source Information

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 PFIFACT_PROJ_FORECAST_ITEM_PQ_BIFACT_PROJ_FORECAST_ITEM_PQOn Line