Cube - Project

Usage/Purpose
Overview Facts
Used Dimensions
Configurations
Limitations
Fact and Dimension Connections
Measures
Included Example Reports and Dashboards
Required Components

Usage/Purpose

Main analysis scenarios are:

Project performance according to standard project measures. E.g. earned value, progress, CV (Cost Variance) and SV (Schedule Variance).
Analysis on project, sub-project, activity and cost elements
Project budgeting and forecasting
Project reporting
Project invoicing plan

To see which dimensions that can be used with each fact in, for example Excel pivot analysis, see section Fact and Dimension Connections below.

Overview Facts

Cube Fact (DSV name)	Measure Group	Referenced Information Source	BI Access View	Access Type
FACT_ACTIVITY_CALCULATION	Project Activity Performance Analysis	FACT_ACTIVITY_CALCULATION	FACT_ACTIVITY_CALCULATION_BI	On Line
FACT_PROJECT_CONN_DET	Project Connections Detail	FACT_PROJECT_CONN_DET	FACT_PROJECT_CONN_DET_BI	On Line
FACT_PROJECT_HISTORY_LOG	Project History Details PHD	FACT_PROJECT_HISTORY_LOG	FACT_PROJECT_HISTORY_LOG_BI	On Line
FACT_REPORTING_CURRENCY_RATES	Reporting Currency Rate	FACT_CURRENCY_RATES	FACT_CURRENCY_RATES_BI_OPT	On Line
FACT_PROJ_FORECAST_ITEM	Project Forecast Item PFI	FACT_PROJ_FORECAST_ITEM	FACT_PROJ_FORECAST_ITEM_BI	On Line
FACT_PROJ_FRC_ITEM_PER	Project Forecast Item Period PFP	FACT_PROJ_FRC_ITEM_PER	FACT_PROJ_FRC_ITEM_PER_BI	On Line
FACT_PROJ_FRC_SNAP_SUM	Project Forecast Snapshot PFS	FACT_PROJ_FRC_SNAP_SUM	FACT_PROJ_FRC_SNAP_SUM_BI	On Line
FACT_PROJ_FRC_SNAPSHOT	Project Forecast Snapshot With Details PSD	FACT_PROJ_FRC_SNAPSHOT	FACT_PROJ_FRC_SNAPSHOT_BI	On Line
FACT_PROJECT_TRANSACTIONS	Project Transactions	FACT_PROJECT_TRANSACTIONS	FACT_PROJECT_TRANSACTIONS_BI	On Line
FACT_INVOICING_PLANS	Invoicing Plans	FACT_INVOICING_PLANS	FACT_INVOICING_PLANS_BI	On Line

Each measure in the facts is described in section Measures. Corresponding Information Sources are described below. Detailed information about Information Sources can be found in IFS Online Documentation.

ACTIVITY CALCULATION

Project Activity Performance Analysis information source is based on IFS/Project Performance Analysis. This information source can be used to design reports that display performance measures and ratios on IFS Engineering Projects.

Project Cost Analysis

Performance measure analysis

PROJECT CONNECTION DETAILS

Project Connection Details information source is based on project connection details of IFS engineering projects. This information source contains details of cost/revenue/hours reported from project connected objects.

Cost, revenue, Hours and progress analysis
Reporting object analysis

PROJECT HISTORY LOG

Project History Details information source is based on project history logs. This information source can be used to analyze how projects have progressed over time.

Project History Analysis

PROJECT FORECAST ITEM

Project Forecast Item information source is based on the item information of project budgets and forecasts. This information source can be used to analyze project cost/ revenue estimates and budgets.

Project Forecast Analysis
Project Budget Analysis
Time series analysis of project cost/revenue

PROJECT FORECAST ITEM PERIOD

Project Forecast Item Period information source is based on the information from forecast spreading. This information source contains the estimate to complete (ETC) values from each forecast spread in to accounting periods.

Analysis of ETC in future accounting periods

PROJECT FORECAST SNAPSHOT SUMMARY

Project Forecast Snapshot Summary information source is based on summary information of each snapshot in to project ID, subproject, activity, cost element, transaction currency and 10 code parts. This information source allows the analysis of project cost up to a specific cutoff date.

Cost and revenue analysis with respect to a specific cutoff date

PROJECT FORECAST SNAPSHOT

Project Forecast Snapshot information source is based on snapshots with details. This information source contains the details of cost reporting objects in addition to the cost/revenue reported from those objects.

Cost and revenue analysis with respect to a specific cutoff date
Object details analysis with respect to a cutoff date

PROJECT TRANSACTIONS

Project Transactions Information source is generated based on the IFS/Project Transactions. This information source allows the analysis of project transaction generated by time, cost and expense reporting.

Transaction analysis by report code
Transaction analysis by sales and cost values
Transaction analysis by employee

INVOICING PLANS

Invoicing Plans information source is generated based on IFS/project invoicing plan lines. This information source allows the analysis of invoiced and planned invoicing plan lines.

Invoice plan analysis

Overview Dimensions

Cube Dimension	Note
ACCOUNT DATE
ACCOUNT
ACCOUNTING PERIOD
ACTIVITY
ACTUAL FINISH DATE
ACTUAL START DATE
BASELINE FINISH DATE
BASELINE START DATE
CODE B
CODE C
CODE D
CODE E
CODE F
CODE G
CODE H
CODE I
CODE J
COMPANY
COMPANY REPORTING PERIOD
CURRENCY
CUSTOMER
EARLY FINISH DATE
EARLY START DATE
EMPLOYEE CATEGORY
EMPLOYEE
PROJECT ACTIVITY PERFORMANCE ANALYSIS
INVOICING PLANS
PROJECT FORECAST ITEM
PROJECT FORECAST ITEM PERIOD
PROJECT FORECAST SNAPSHOT
PROJECT FORECAST SNAPSHOT WITH DETAILS
PROJECT CONNECTIONS DETAIL
PROJECT HISTORY DETAILS
PROJECT TRANSACTIONS
FORECAST EARLY FINISH DATE
HISTORY DATE
LATE FINISH DATE
LATE START DATE
ORGANIZATION CODE
PLANNED INV DATE
POSITION
PRICE ADJUSTMENT
PRJREP START DATE
PROJ BILLING CATEGORY
PROJ CONN CREATED DATE
PROJ CONN MODIFIED DATE
PROJ END DATE
PROJ FCST CONN CCO
PROJ FCST CONN RFC
PROJ FORECAST TYPE
PROJ FORECAST
PROJ START DATE
PROJECT COST REVENUE ELEMENT
PROJECT COST STRUCTURE
PROJECT PROGRAM
PROJECT
REPORTING CURRENCY
REPORTING DATE
RESOURCE GROUP
SUB PROJECT
WORK LOCATION

Configurations

The cube supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.

Please Refer technical documentation for more information.

Limitations

The Project cube is using the Company Reporting Period dimension, which means that it is necessary to create a specific Reporting Period Definition to be used by this cube. The created/selected identity must also be defined in the lookup configuration for the ETL process, using Source = 'Project'.

Please Refer technical documentation for more information.

Fact and Dimension Connections

The following picture shows how different facts in the cube are connected to the available dimensions.

Measures

General

Aggregation of measures is based on SUM if not explicitly noted.

Basic Measures

This sections describes the basic measures in the cube. These are either measures defined in the core Information Source or in the ETL process. The columns have the following meaning:

Core Measure
A measure that has its origin in a core Information Source
ETL Measure
A measures defined the the ETL process, in most cases by using existing core measures as input.
Cube Measure
A measure specifically defined in the cube, e.g. count of rows etc.
Measure Expression
Specifies if a measure expression has been used in the cube to modify a general measure. One special case is amounts calculated in Reporting Currency, where a basic measure is divided by the Currency Rate from the fact REPORTING CURRENCY RATES. This means that by using a filter on dimension REPORTING CURRENCY dimension, it is possible to present amounts in different companies in a common currency.
Reporting Currency Measure
Specifies if a measure supports presentation in reporting currency.

Measure	Measure Group	Core Measure	ETL Measure	Cube Measure	Measure Expression	Reporting Currency Measure	Aggr. Method	Note
BAC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
BCWS	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
BCWP	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
ACWP	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
ETC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
EAC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
VAC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
CV	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
SV	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
IETC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
IEAC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
IVAC	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Planned Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Released Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Completed Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Closed Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Cancelled Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Late Planned Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
Count Late Released Activity	Project Activity Performance Analysis	YES	NO	NO	NO	NO	SUM
EAC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	EAC in rerporting currency
BCWP RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	BCWP in reporting currency
IEAC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	IEAC in reporting currency
BAC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	BAC in reporting currency
IVAC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	IVAC in reporting currency
IETC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	IETC in reporting currency
BCWS RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	BCWS in reporting currency
ETC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	ETC in reporting currency
VAC RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	VAC in reporting currency
ACWP RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	ACWP in reporting currency
SV RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	SV in reporting currency
CV RC	Project Activity Performance Analysis	NO	YES	NO	YES	YES	SUM	CV in reporting currency
Count Projects	Project Activity Performance Analysis	NO	NO	YES	YES	YES	SUM	Distinct count of Projects
Actual Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Actual Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Actual Rev	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Revenue
Baseline Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Baseline Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Committed Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Committed Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Earned Value Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Earned Value Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Estimated Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Estimated Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Estimated Rev	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Revenue
Planned Committed Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Planned Committed Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Planned Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Planned Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Planned Rev	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Revenue
Posted Rev	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Preliminary Revenue
Preliminary Rev	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Scheduled Work Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Scheduled Work Hours	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Used Cost	Project Connections Detail	YES	NO	NO	NO	NO	SUM
Actual Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Cost in Transaction Currency
Actual Rev Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Revenue in Transaction Currency
Committed Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Committed Cost in Transaction Currency
Estimated Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Cost in Transaction Currency
Estimated Rev Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Transaction Currency
Planned Committed Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Transaction Currency
Planned Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Cost in Transaction Currency
Used Cost Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Used Cost in Transaction Currency
Planned Rev Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Revenue in Transaction Currency
Preliminary Rev Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Transaction Currency
Posted Rev Trans Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Posted Revenue in Transaction Currency
Actual Rev Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Revenue in Project Currency
Actual Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Cost in Project Currency
Committed Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Committed Cost in Project Currency
Estimated Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Cost in Project Currency
Estimated Rev Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Project Currency
Planned Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Cost in Project Currency
Planned Rev Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Revenue in Project Currency
Planned Committed Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Project Currency
Posted Rev Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Posted Revenue in Project Currency
Preliminary Rev Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Project Currency
Used Cost Project Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Used Cost in Project Currency
Actual Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Cost in Budget Currency Rate
Actual Rev Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Actual Revenue in Budget Currency Rate
Committed Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Committed Cost in Budget Currency Rate
Estimated Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Cost in Budget Currency Rate
Estimated Rev Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Budget Currency Rate
Planned Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Cost in Budget Currency Rate
Planned Rev Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Revenue in Budget Currency Rate
Planned Committed Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Budget Currency Rate
Posted Rev Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Posted Revenue in Budget Currency Rate
Preliminary Rev Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Budget Currency Rate
Used Cost Budget Curr	Project Connections Detail	YES	NO	NO	NO	NO	SUM	Used Cost in Budget Currency Rate
Earned Value Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Earned value cost in reporting currency
Planned Committed Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Planned committed cost in reporting currency
Actual Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Actual cost in reporting currency
Posted Revenue RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Posted revenue in reporting currency
Baseline Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Baseline cost in reporting currency
Estimated Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Estimated cost in reporting currency
Scheduled Work Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Scheduled work cost in reporting currency
Planned Revenue RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Planned revenue in reporting currency
Planned Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Planned cost in reporting currency
Used Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Used cost in reporting currency
Actual Revenue RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Actual revenue in reporting currency
Preliminary Revenue RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Prelimninary revenue in reporting currency
Estimated Revenue RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Estimated revenue in reporting currency
Committed Cost RC	Project Connections Detail	NO	YES	NO	YES	YES	SUM	Committed cost in reporting currency
Actual Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Actual Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Baseline Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Baseline Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Committed Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Committed Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Earned Value Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Earned Value Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Estimated Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Estimated Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Planned Committed Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Planned Committed Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Planned Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Planned Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Scheduled Work PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Scheduled Hours PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Used Cost PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty
Estimated Rev PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Revenue
Planned Rev PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Revenue
Preliminary Rev PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Preliminary Revenue
Posted Rev PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Posted Revenue
Actual Rev PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Revenue
Actual Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Cost in Transaction Currency
Committed Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Committed Cost in Transaction Currency
Estimated Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Cost in Transaction Currency
Planned Committed Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Committed Cost in Transacton Currency
Planned Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Cost in Transaction Currency
Used Cost Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Used Cost in Transaction Currency
Estimated Rev Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Revenue in Transaction Currency
Planned Rev Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Revenue in Transaction Currency
Preliminary Rev Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Preliminary Revenue in Transaction Currency
Posted Rev Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Posted Revenue in Transaction Currency
Actual Rev Trans Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Revenue in Transaction Currency
Actual Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Cost in Budget Currency Rate
Committed Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Committed Cost in Budget Currency Rate
Estimated Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Cost in Budget Currency Rate
Planned Committed Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Committed Cost in Budget Currency Rate
Planned Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Cost in Budget Currency Rate
Used Cost Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Used Cost in Budget Currency Rate
Estimated Rev Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Revenue in Budget Currency Rate
Planned Rev Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Revenue in Budget Currency Rate
Preliminary Rev Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Preliminary Revenue in Budget Currency Rate
Posted Rev Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Posted Revenue in Budget Currency Rate
Actual Rev Budget Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Revenue in Budget Currency Rate
Actual Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Cost in Project Currency
Committed Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Committed Cost in Project Currency
Estimated Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Cost in Project Currency
Planned Committed Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Committed Cost in Project Currency
Planned Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Cost in Project Currency
Used Cost Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Used Cost in Project Currency
Estimated Rev Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Estimated Revenue in Project Currency
Planned Rev Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Planned Revenue in Project Currency
Preliminary Rev Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Preliminary Revenue in Project Currency
Posted Rev Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Posted Revenue in Project Currency
Actual Rev Project Curr PHD	Project History Details PHD	YES	NO	NO	NO	NO	LastNonEmpty	Actual Revenue in Project Currency
Currency Rate	Reporting Currency Rate	YES	YES	NO	NO	NO	SUM	Currency rate used to calulate amounts to reporting currency. The core measure is modified in ETL
EAC Net Change Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Revenue in Budget Currency Rate
Posted Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Posted Revenue
Estimated Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Cost in Transaction Currency
Unspread Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Revenue
ETC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Revenue in Project Currency
Previous EAC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Previous Estimate At Completion Cost in Reporting Currency
Unspread Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Revenue in Transaction Currency
Unspread Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Cost in Project Currency
Committed Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Committed Cost in Project Currency
Posted Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Posted Revenue in Project Currency
Adjusted ETC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Cost in Transaction Currency
Connected ETC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Revenue in Budget Currency Rate
Earned Value Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Revenue in Budget Currency
Estimated Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Cost in Budget Currency
Adjusted ETC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Revenue in Transaction Currency
Estimated Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Transaction Currency
Previous EAC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Cost in Transaction Currency
Budget Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Revenue in Budget Currency Rate
ETC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Cost
Budget Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Revenue
Adjusted ETC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Cost
Budget Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Revenue in Project Currency
Previous EAC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Revenue in Project Currency
Previous ETC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Cost
Actual Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Cost in Budget Currency Rate
Planned Committed Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Unspread Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unsprtead Cost in Budget Currency Rate
Adjusted ETC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Revenue
Unspread Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Unspread Cost in Reporting Currency
Earned Value Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Cost in Project Currency
Used Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Used Cost in Budget Currency Rate
EAC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Cost in Budget Currency Rate
Previous EAC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Cost in Budget Currency Rate
Previous ETC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Cost in Budget Currency Rate
Connected ETC CCO Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Cost
ETC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Cost in Transaction Currency
Actual Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Actual Cost in Reporting Currency
Connected ETC CCO Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Cost in Transaction Currency
Actual Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Revenue in Transaction Currency
EAC Net Change Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Cost in Transaction Currency
EAC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Revenue in Transaction Currency
Estimated Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Esimated Cost in Reporting Currency
EAC Net Change Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Revenue in Transaction Currency
EAC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Cost in Project Currency
Planned Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Revenue
EAC Net Change Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Cost in Project Currency
Planned Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Cost in Transaction Currency
Estimated Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Cost in Project Currency
Used Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Actual Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Revenue
Earned Value Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Revenue in Transaction Currency
Adjusted ETC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Cost in Project Currency
Previous ETC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Previous Estimate To Complete Cost in Reporting Currency
Posted Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Posted Revenue in Transaction Currency
Connected ETC CCO Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Cost in Project Currency
EAC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Revenue in Budget Currency Rate
Budget Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Budget Cost in Reporting Currency
Preliminary Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Transaction Currency
Previous EAC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Cost in Transaction Currency
Connected ETC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Cost in Transaction Currency
Previous ETC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Revenue
Previous ETC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Revenue in Budget Currency Rate
EAC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Cost in Transaction Currency
EAC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Cost
EAC Net Change Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Cost
Connected ETC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Cost
Used Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Used Cost in Reporting Currency
EAC Net Change Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Revenue in Project Currency
Planned Committed Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Project Currency
Previous ETC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Revenue in Project Currency
Connected ETC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Cost in Budget Currency Rate
Earned Value Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Revenue
Budget Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Cost in Project Currency
EAC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Revenue
Preliminary Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Preliminary Revenue
Actual Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Revenue in Budget Currency Rate
Estimated Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Budget Currency Rate
EAC Net Change Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate At Completion Net Change Cost
Actual Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Cost in Project Currency
Connected ETC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Revenue in Project Currency
Committed Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Committed Cost in Transaction Currency
Estimated Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Project Currency
Preliminary Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Budget Currency Rate
Planned Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Revenue in Transaction Currency
EAC Net Change Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Cost in Budget Currency Rate
Connected ETC CCO Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Cost in Budget Currency Rate
EAC Net Change Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Net Change Revenue
Actual Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Cost in Transaction Currency
Connected ETC CCO Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Revenue in Budget Currency Rate
Connected ETC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Cost in Project Currency
ETC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Revenue in Transaction Currency
EAC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate At Completion Revenue
ETC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Revenue in Budget Currency Rate
Previous EAC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Revenue
Connected ETC CCO Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Revenue in Transaction Currency
Unspread Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Earned Value Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Cost in Budget Currency Rate
ETC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate To Complete Cost in Reporting Currency
Previous EAC Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Cost
Budget Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Cost in Transaction Currency
Budget Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Revenue in Transaction Currency
Previous EAC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Revenue in Budget Currency Rate
Estimated Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
ETC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Cost
Committed Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
EAC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate At Completion Cost
Actual Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Used Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Used Cost in Project Currency
Planned Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Revenue in Budget Currency Rate
Earned Value Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Earned Value Cost in Reporting Currency
Previous ETC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Revenue in Transaction Currency
Planned Committed Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Budget Currency Rate
Budget Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Budget Cost in Budget Currency Rate
Budget Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Connected ETC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Revenue in Transaction Currency
Previous ETC Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Cost in Transaction Currency
Planned Committed Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Planned Committed Cost in Reporting Currency
ETC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Cost in Project Currency
Previous ETC Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate To Complete Cost in Project Currency
Previous EAC Rev Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Previous Estimate At Completion Revenue in Transaction Currency
Adjusted ETC Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Revenue in Budget Currency Rate
ETC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimate To Complete Revenue
Connected ETC CCO Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Revenue in Project Currency
Connected ETC Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Revenue
Adjusted ETC Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Cost in Budget Currency Rate
Earned Value Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Revenue in Project Currency
Connected ETC CCO Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Connected Estimate To Complete Contract Change Order Revenue
Unspread Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Revenue in Project Currency
Earned Value Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Preliminary Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Project Currency
Actual Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Actual Revenue in Project Currency
Planned Cost Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Cost in Project Currency
Unspread Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Cost in Transaction Currency
Committed Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Committed Cost in Budget Currency Rate
Adjusted ETC Rev Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Adjusted Estimate To Complete Revenue in Project Currency
Planned Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Planned Cost in Reporting Currency
Estimated Rev PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Estimated Revenue
Planned Committed Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Transaction Currency
Posted Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Posted Revenue in Budget Currency Rate
Unspread Rev Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Unspread Revenue in Budget Currency Rate
Used Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Used Cost in Transaction Currency
Planned Cost PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM
Earned Value Cost Trans Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Earned Value Cost in Transaction Currency
Planned Cost Budget Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Cost in Budget Currency Rate
Planned Revenue Proj Curr PFI	Project Forecast Item PFI	YES	NO	NO	NO	NO	SUM	Planned Revenue in Project Currency
ETC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate To Complete Revenue in Reporting Currency
Earned Value Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Earned Value Revenue in Reporting Currency
Adjusted ETC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Adjusted Estimate To Complete Revenue in Reporting Currency
Actual Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Actual Revenue in Reporting Currency
Unspread Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Unspread Revenue in Reporting Currency
Estimated Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimated Revenue in Reporting Currency
Posted Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Posted Revenue in Reporting Currency
Previous EAC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Previous Estimate At Completion Revenue in Reporting Currency
Connected ETC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Connected Estimate To Complete Cost in Reporting Currency
Connected ETC CCO Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Connected Estimate To Complete Contract Change Order Cost in Reporting Currency
Preliminary Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Preliminary Revenue in Reporting Currency
Previous ETC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Previous Estimate To Complete Revenue in Reporting Currency
Connected ETC CCO Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Connected Estimate To Complete Contract Change Order Revenue in Reporting Currency
Planned Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Planned Revenue in Reporting Currency
Budget Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Budget Revenue in Reporting Currency
Adjusted ETC Cost RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Adjusted Estimate To Complete Cost in Reporting Currency
Connected ETC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Connected Estimate To Complete Revenue in Reporting Currency
EAC Net Change Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate At Completion Net Change Revenue in Reporting Currency
EAC Rev RC PFI	Project Forecast Item PFI	NO	YES	NO	YES	YES	SUM	Estimate At Completion Revenue in Reporting Currency
Connected Cost Trans Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Cost in Transaction Currency
Rev PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Revenue
Connected Cost Proj Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Cost in Project Currency
Cost Budget Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Cost in Budget Currency Rate
Cost Proj Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Cost in Project Currency
Connected Rev Proj Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Revenue in Project Currency
Cost PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM
Rev Trans Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Revenue in Transaction Currency
Connected Rev Trans Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Revenue in Transaction Currency
Rev Proj Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Revenue in Project Currency
Connected Cost Budget Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Cost in Budget Currency Rate
Connected Cost RC PFP	Project Forecast Item Period PFP	NO	YES	NO	YES	YES	SUM	Connected Cost in Reporting Currency
Cost Trans Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Cost in Transaction Currency
Connected Cost PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM
Rev Budget Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Revenue in Budget Currency Rate
Connected Rev RC PFP	Project Forecast Item Period PFP	NO	YES	NO	YES	YES	SUM	Connected Revenue
Connected Rev Budget Curr PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Revenue in Budget Currency Rate
Rev RC PFP	Project Forecast Item Period PFP	NO	YES	NO	YES	YES	SUM	Revenue in Reporting Currency
Cost RC PFP	Project Forecast Item Period PFP	NO	YES	NO	YES	YES	SUM	Cost in Reporting Currency
Connected Rev PFP	Project Forecast Item Period PFP	YES	NO	NO	NO	NO	SUM	Connected Revenue
Preliminary Rev Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Budget Currency Rate
Planned Committed Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Planned Rev Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Revenue in Budget Currency Rate
Preliminary Rev PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Preliminary Revenue
Actual Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Cost in Budget Currency Rate
Estimated Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Cost in Project Currency
Estimated Rev Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Project Currency
Planned Rev Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Revenue in Project Currency
Actual Rev Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Revenue in Transaction Currency
Committed Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Committed Cost in Project Currency
Planned Committed Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Transaction Currency
Estimated Rev Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Budget Currency Rate
Estimated Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Estimated Rev PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Revenue
Posted Rev Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Posted Revenue in Budget Currency Rate
Posted Rev Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Posted Revenue in Project Currency
Planned Committed Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Project Currency
Preliminary Rev Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Transaction Currency
Used Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Used Cost in Budget Currency Rate
Actual Rev Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Revenue in Project Currency
Actual Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Cost in Transaction Currency
Posted Rev Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Posted Revenue in Transaction Currency
Actual Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Estimated Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Cost in Budget Currency Rate
Planned Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Preliminary Rev Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Project Currency
Planned Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Cost in Budget Currency Rate
Planned Committed Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Budget Currency Rate
Planned Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Cost in Project Currency
Committed Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Committed Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Committed Cost in Transaction Currency
Planned Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Cost in Transaction Currency
Posted Rev PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Posted Revenue
Planned Rev Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Revenue in Transaction Currency
Actual Rev PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Revenue
Used Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Used Cost in Transaction Currency
Actual Rev Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Revenue in Budget Currency Rate
Used Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Used Cost in Project Currency
Planned Rev PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Planned Revenue
Used Cost PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM
Estimated Cost Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Cost in Transaction Currency
Estimated Rev Trans Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Transaction Currency
Actual Cost Proj Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Actual Cost in Project Currency
Committed Cost Budget Curr PFS	Project Forecast Snapshot PFS	YES	NO	NO	NO	NO	SUM	Committed Cost in Budget Currency Rate
Planned Rev RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Planned Revenue in Reporting Currency
Planned Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Planned Cost in Reporting Currency
Used Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Used Cost in Reporting Currency
Planned Committed Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Planned Committed Cost in Reporting Currency
Estimated Rev RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Estimated Revenue in Reporting Currency
Posted Rev RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Posted Revenue in Reporting Currency
Committed Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Committed Cost in Reporting Currency
Actual Rev RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Actual Revenue in Reporting Currency
Actual Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Actual Cost in Reporting Currency
Preliminary Rev RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Preliminary Revenue in Reporting Currency
Estimated Cost RC PFS	Project Forecast Snapshot PFS	NO	YES	NO	YES	YES	SUM	Estimated Cost in Reporting Currency
Planned Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Cost in Budget Currency Rate
Planned Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Cost in Project Currency
Estimated Rev Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Project Currency
Preliminary Rev Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Transaction Currency
Actual Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Estimated Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Cost in Project Currency
Planned Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Cost in Transaction Currency
Planned Rev Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Revenue in Budget Currency Rate
Planned Committed Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Estimated Rev Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Transaction Currency
Posted Rev Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Posted Revenue in Project Currency
Preliminary Rev Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Budget Currency Rate
Used Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Used Cost in Transaction Currency
Estimated Rev PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Revenue
Preliminary Rev Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Preliminary Revenue in Project Currency
Estimated Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Used Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Used Cost in Project Currency
Actual Rev Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Revenue in Budget Currency Rate
Planned Committed Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Transaction Currency
Committed Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Committed Cost in Budget Currency Rate
Planned Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Estimated Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Cost in Budget Currency Rate
Posted Rev Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Posted Revenue in Budget Currency Rate
Preliminary Rev PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Preliminary Revenue
Committed Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Committed Cost in Project Currency
Planned Committed Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Budget Currency Rate
Planned Committed Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Committed Cost in Project Currency
Used Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Posted Rev Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Posted Revenue in Transaction Currency
Used Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Used Cost in Budget Currency Rate
Actual Rev Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Revenue in Transaction Currency
Actual Cost Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Cost in Budget Currency Rate
Actual Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Cost in Transaction Currency
Planned Rev PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Revenue
Actual Rev Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Revenue in Project Currency
Estimated Rev Budget Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Revenue in Budget Currency Rate
Actual Cost Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Cost in Project Currency
Planned Rev Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Revenue in Transaction Currency
Estimated Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Estimated Cost in Transaction Currency
Committed Cost Trans Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Committed Cost in Transaction Currency
Planned Rev Proj Curr PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Planned Revenue in Project Currency
Actual Rev PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Actual Revenue
Committed Cost PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM
Posted Rev PSD	Project Forecast Snapshot With Details PSD	YES	NO	NO	NO	NO	SUM	Posted Revenue
Committed Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Committed Cost in Reporting Currency
Used Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Used Cost in Reporting Currency
Planned Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Planned Cost in Reporting Currency
Planned Committed Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Planned Committed Cost in Reporting Currency
Preliminary Rev RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Preliminary Revenue in Reporting Currency
Actual Rev RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Actual Revenue in Reporting Currency
Estimated Rev RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Estimated Revenue in Reporting Currency
Estimated Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Estimated Cost in Reporting Currency
Planned Rev RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Planned Revenue in Reporting Currency
Actual Cost RC PSD	Project Forecast Snapshot With Details PSD	NO	YES	NO	YES	YES	SUM	Actual Cost in Reporting Currency
Sales Amount Base	Project Transactions	YES	NO	NO	NO	NO	SUM
Sales Amount Basis	Project Transactions	YES	NO	NO	NO	NO	SUM
Sales Price Basis	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Total Internal Price	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Markup Amount	Project Transactions	YES	NO	NO	NO	NO	SUM
Internal Amount	Project Transactions	YES	NO	NO	NO	NO	SUM
Sales Price Base	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Internal Price	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Alternative Cost	Project Transactions	YES	NO	NO	NO	NO	SUM
Sales Quantity	Project Transactions	YES	NO	NO	NO	NO	SUM
Overhead Price	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Markup Price	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Sales Amount	Project Transactions	YES	NO	NO	NO	NO	SUM
Sales Price	Project Transactions	YES	NO	NO	NO	NO	AverageOfChildren
Internal Quantity	Project Transactions	YES	NO	NO	NO	NO	SUM
Markup Amount RC	Project Transactions	NO	YES	NO	YES	YES	SUM	Markup Amount in Reporting Currency
Alternative Cost RC	Project Transactions	NO	YES	NO	YES	YES	SUM	Alternative Cost in Reporting Currency
Sales Amount RC	Project Transactions	NO	YES	NO	YES	YES	SUM	Sales Amount in Reporting Currency
Internal Amount RC	Project Transactions	NO	YES	NO	YES	YES	SUM	Internal Amount in Reporting Currency
Invoicing Plan Sales Amount	Invoicing Plans	YES	NO	NO	NO	NO	SUM
Planned Sales Amount Base	Invoicing Plans	YES	NO	NO	NO	NO	SUM
Invoiced Sales Amount Base	Invoicing Plans	YES	NO	NO	NO	NO	SUM
Planned Sales Amount RC	Invoicing Plans	NO	YES	NO	YES	YES	SUM	Planned Sales Amount in Reporting Currency
Invoiced Sales Amount RC	Invoicing Plans	NO	YES	NO	YES	YES	SUM	Invoiced Sales Amount in Reporting Currency

Calculated Measures

Calculated measures are in the cube calculated with respect to other measures. The table below defines the general meaning/definition of each calculated measure.

Measure	Meaning
Project Margin	Actual Revenue - Actual Cost
Project Margin RC	Actual Revenue RC - Actual Cost RC
Project Margin %	Project Margin / Actual Revenue
Project Margin % RC	Project Margin RC / Actual Revenue RC
Cost Progress %	Earned Value Cost / Planned Cost (excluding activities not part of progress calculation)
Cost Progress % RC	Earned Value Cost RC / Planned Cost RC (excluding activities not part of progress calculation)
CPI	If ACWP > 0 then ROUND(BCWP/ACWP),2) else if BCWP > 0 then 1 else NULL
Hours Progress %	Earned Value Hours / Planned Hours (excluding activities not part of progress calculation)
Completed Activities %	Count Completed Activity / Count Activity
Actual vs Scheduled %	ACWP / BCWS
Actual vs Scheduled % RC	ACWP RC / BCWS RC
CPI RC	If ACWP RC > 0 then ROUND(BCWP RC/ACWP RC),2) else if BCWP RC > 0 then 1 else NULL
SPI	If BCWS > 0 then ROUND(BCWP/BCWS),2) else if BCWP > 0 then 1 else NULL
SPI RC	If BCWS RC > 0 then ROUND(BCWP RC/BCWS RC),2) else if BCWP RC > 0 then 1 else NULL
Cost Progress % PHD	Earned Value Cost PHD / Planned Cost PHD (excluding activities not part of progress calculation)
Cost Progress % RC PHD	Earned Value Cost RC PHD / Planned Cost RC PHD (excluding activities not part of progress calculation)
Hours Progress % PHD	Earned Value Hours PHD / Planned Hours PHD (excluding activities not part of progress calculation)

Time Based 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 defined in the table below.

Measure	Meaning
YTD	Year to Date Aggregated value for current month in current year. E.g. for period 201210 Ytd represents sum of periods 201201-201210. Based on [REPORTING_DATE].[Month Hierarchy]
R12	Rolling 12 (completed) Months For a given period, the sum all months from one year back up to the previous month. E.g. Rolling 12 for 201210 is the sum of months 201110 - 201209 Based on [REPORTING_DATE].[Month Hierarchy]
PY	Previous Year The value of the corresponding month one year back. E.g. for month 201210, the value of month 201110. Based on [REPORTING_DATE].[Month Hierarchy]
YTD PY	Year to Date Previous Year Aggregated value for corresponding month one year back. E.g. for month 201210 YTD Previous Year represents sum of months 201101-201110. Based on [REPORTING_DATE].[Month Hierarchy]
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 201210 the sum of month 201010-201109 Based on [REPORTING_DATE].[Month Hierarchy]
Avg XXX Ytd	Sum XXX Ytd/Count XXX Ytd
Avg XXX Rolling 12	Sum XXX Rolling 12/Count XXX Rolling 12
XXX % Ytd	Count XXX Ytd/Count YYY Ytd
XXX % Rolling 12	Count XXX Rolling 12/Count XXX Rolling 12

Included Example Reports and Dashboards

This section lists dashboards and reports in the example content for the BI Analysis Package that is using this cube:

UI Name	Type
Project Analysis	Excel Dashboard
Project Cost - Revenue Analysis	Excel Dashboard
Unfinished Activities	Report
CPI - SPI	APC - Analysis Panel Component
Cost Variance	APC - Analysis Panel Component
Schedule Variance	APC - Analysis Panel Component

Required Components

The BI specific and also related core components listed in this section are required, i.e. they must along with other dependent components, be part of the customer installation to successfully use this cube.

Note: that only directly used components are listed. Each such component can have its own list of dependent components. Please refer to the Component Deployment Profile File for each component to get the full picture.

Component	Type	Component Name	Product
BISEDI	BI	BI Services Dimensions	Business Intelligence
APTOOL	BI	Common scripts and utilities, BI Anapac	Business Intelligence
APPSDI	BI	Application Services Analysis Package Dimension	Business Intelligence
ENTEDI	BI	Enterprise Analysis Package Dimensions	Business Intelligence
ACCRDI	BI	Accounting Rules Analysis Package Dimensions	Business Intelligence
ACCRFT	BI	Accounting Rules Analysis Package Fact	Business Intelligence
PROJDI	BI	Project Analysis Package Dimensions	Business Intelligence
PROJFT	BI	Project Analysis Package Facts	Business Intelligence
PJCOMC	BI	Project Common Cube	Business Intelligence
ENTERP	CORE	Enterprise	Financials
ACCRUL	CORE	Accounting Rules	Financials
PROJ	CORE	Project	Projects

BI Component: PJCOMC