Tabular Model - Project

FACT_PROJECT_TRANS
Purpose of the Project Transaction information source is to retrieve information from the project reporting related transactions to enable reporting and analysis using IFS/Business Reporter.

• Gross margin reports per Employee, Customer, Company or Project (WBS)
• Overview Not Invoiceable Transactions
• Overview Not Invoiced Transactions
• Overview Not Approved Project Transactions

FACT_PROJ_FRC_ITEM_PER
The purpose of the Project Forecast Item Period information source is to facilitate reporting and analysis capabilities from IFS/ Project Budgeting and Forecasting on a forecast item period level. The information source may be used for instance when creating reports in IFS Business Reporter. All the amounts can be shown in base, transaction, budget and project currency.

• Periodic Budget and Forecast overview
• Periodic Budget and Forecast for different currencies

FACT_INVOICING_PLANS
Purpose of the Invoicing plan information source is to retrieve information from the project invoicing plan to enable reporting and analysis using IFS/Business Reporter.

• Overview Invoicing Plan on company and WBS level both in sales currency and accounting currency
• Invoiced sales per project, total and per month
• Remaining amounts to be invoiced per project
• Overview Not invoiceable transactions

FACT_ACTIVITY_CALCULATION
The Project Activity Performance Analysis information source is developed to facilitate the in-depth project performance analysis.The measure items selected in the Fact table are a numerous indicators which are calculated on the activity level. Note some of these indicators are interdependent and calculated based on each other. Examples on indicators are ACWP, BCWP (EV), BCWS CV, SV, CPI, SPI, VAC, IEAC, IETC, calculated progress both on hours and cost.

• Project Performance Analysis, may also be used for benchmarking
• Cost and Schedule variance reports
• Earned value analysis

FACT_PROJECT_HISTORY_LOG
The Project History Details information source, is aimed at providing historical project data to be used for reporting and analysis purposes for instance in IFS Business Reporter. The historical data can be fetched according to the connection details level. See also the general description on information source Project Connection Details. History data is created either through history logging or when a baseline is created.

• Project history analysis per history date
• Activity history analysis per history date

FACT_PROJ_FORECAST_ITEM
The purpose of the Project Forecast Item information source is to retrieve information from IFS/Project Budgeting and Forecasting on an item level for reporting and analysis purposes. All the amounts can be shown in base, transaction, budget and project currency. The reporting may be done based on the Work Breakdown Structures (WBS) or on cost elements and Cost Breakdown Structures (CBS).

• Budget and Forecast Overview
• Budget and Forecast WBS analyze
• Budget and Forecast CBS analyze
• Project Cost Follow-up - split by WBS
• Project Cost Follow-up - split by CBS
• Estimate to complete (ETC) and estimate at completion (EAC) reports
• Variance reports between forecast versions and original budget version

FACT_PROJ_FRC_SNAP_SUM
The purpose of the Project Forecast Snapshot information source is to retrieve information for creating reports and cubes, based on the project forecast detailed snapshot functionality in IFS/Project Budgeting and Forecasting. All the amounts can be shown in base, transaction, budget and project currency. The reporting may be done based on the Work Breakdown Structures (WBS) or on Cost Breakdown Structures (CBS). This information source can be used independent of the snapshot type but the amounts cannot be divided into different object types.

• Project Cost Follow up on snapshot version – split by WBS
• Project Cost Follow up on snapshot version – split by CBS

FACT_PROJ_FRC_SNAPSHOT
The purpose of the Project Forecast Snapshot information source is to retrieve information for creating reports and cubes, based on the project forecast snapshot functionality in IFS/Project Budgeting and Forecasting. All the amounts can be shown in base, transaction, budget and project currency. The reporting may be done based on the Work Breakdown Structures (WBS) or on Cost Breakdown Structures (CBS). This information source can only be used for snapshot taken with details. The amounts can be divided into different object types.

• Project Cost Follow up on snapshot version – split by WBS
• Project Cost Follow up on snapshot version – split by CBS

FACT_PROJ_ACTIVITY_INFO
The Project Activity information source facilitates reporting and analysis capabilities on progress, cost, hours and revenue figures on activity level. On Cost and Hours information about estimated, planned, baseline, planned committed, committed, used and actual values in addition to earned value and scheduled work may be retrieved. On Revenue estimated, planned, preliminary, posted and actual values may be analyzed.

• Cost, hours and revenue reports
• Progress reports on cost and hours
• Progress reports on cost and hours
• Earned value variance analysis

FACT_CURRENCY_RATES
Currency Rate information source is based on IFS\Accounting Rules\Currency. This information source can be used to design reports using Currency Rate information..

• Historical currency rates
• Currency rates by rate type