Project domain information

For the Project domain, various dimensions, facts, dashboards, and reports are available.

Bottom Up Budget

Project Bottom Up Budget is based on the Project Budget by Period (tpptc311) session in Infor LN CE. To time phase a bottom up budget, use the Generate Budget Cost Analysis (birst) (tpptc3211m000) session, which inserts the data into the table tpptc311. Time phasing is based on this data:

  • Bottom Up Budget
  • Active plan of the project
  • Latest approved baseline dates of the activity
  • Earned Value method of the activity
  • Active budget cost analysis version on the project

If any of the above settings are changed, the Generate Budget Cost Analysis Time Phased (Birst) (tpptc3211m000) session must be run to get the latest budget by period.

To distinguish between the latest active budget and all available budget versions, these Measure folders are available in Birst:

Project Bottom Up Budget
Shows the active bottom up budget time phased by period. This budget must be used when analyzing or monitoring project by Budget \ Earned Value \ Cost \ Revenue \ Forecast etc. Measures are configured by latest approved baseline, active plan and active budget analysis code.
Project Bottom Up Budget Version
Shows all versions of bottom up time phased budget by period. These measures must be used when comparing different versions of Bottom Up Budget. You must select Project Baseline and Project Bottom Up Budget.

After a project budget is deleted in LN, the deleted field is set in the fact table in Birst. These facts are hidden. Project budgets that are deleted with status Closed or Archived (when archiving orders) will not be hidden and remain available for analysis.

The Project Earned Value is based on the Project Bottom Up Budget fact in Birst. Project Earned Value calculations in Birst ETL are based on this data:

  • Project Bottom Up Budget fact
  • Latest approved baseline dates of the activity
  • Earned Value method of the activity

If any of the above setting are changed, the Earned Value must be processed. All Earned Value versions are stored in the Project Earned Value Version fact.

Earned Value Management (EVM)

EVM is the project management methodology that integrates the scope, schedule, and cost of the project. The framework allows project management professionals to monitor these three components. EVM provides an objective measure of progress while delivering early warning indicators through trends and estimates.

Earned Value calculations are based on these earned value types:

  • Start/End Percentage: Percentage values are assigned to the start and end of the activities. At the start of the activity, a percentage of the project is completed and the budget amounts are released based on these percentages.

    Example: For an activity, the Scheduled Start Date is 1 January 2012, Scheduled End Date is 20 March 2012 and the budget amount is 10000 EUR.

    • Start Percentage = 70%
    • End Percentage = 30%
    • Time Phase Budget in Period 1 (Jan 12) = 10000 * 70% = 7000 EUR
    • Time Phase Budget in Period 2 (Feb 12) = 10000 * 0 = 0 EUR
    • Time Phase Budget in Period 3 (Mar 12) = 10000 * 30% = 3000 EUR

    You can define the percentage for the start and end of the activities in LN.

  • Percentage Complete: The budget amounts are released in proportion to the progress percentage of the project. The budget must be equally divided across the time period of the activity start and end date.

    Example: For an activity, the Scheduled Start Date is 1 January 2012, Scheduled End Date is 20 March 2012 and the budget amount is 10000 EUR.

    As the EVM is percentage complete, you must time phase the budget proportionately over the duration of the activity.

    • Activity Duration: 31 Days (in Jan) + 29 Days (in Feb) + 20 Days (in March) = 80 Days
    • Time Phase Budget in Period 1 (Jan 12) = 10000 / 80 * 31 = 3875 EUR
    • Time Phase Budget in Period 2 (Feb 12) = 10000 / 80 * 29 = 3625 EUR
    • Time Phase Budget in Period 3 (Mar 12) = 10000 / 80 * 20 = 2500 EUR
  • Milestones: Milestones are attached to the activity and a percentage or amount of the budget is assigned to each milestone. When a milestone is reached, the assigned budget is released.

    Example: For an activity, the Scheduled Start Date is 1 January 2012, Scheduled End Date is 20 March 2012 and the budget amount is 10000 EUR.

    • The Activity is linked to Milestone M1 and M2
    • M1 (Scheduled Completion Date) = 12th Feb 2012
    • M2 (Scheduled Completion Date) = 20th March 2012
    • Percentage assigned to M1: = 40%
    • Percentage assigned to M2: = 60%
    • Time Phase Budget in Period 1 (Jan 12) = 0 = 0 EUR
    • Time Phase Budget in Period 2 (Feb 12) = 4000 = 4000 EUR
    • Time Phase Budget in Period 3 (Mar 12) = 6000 = 6000 EUR

    You can define the percentages for each milestone in LN.

  • Level of Effort: The earned value is equal to the schedule or Budget of the project. The budget amounts are released in proportion to the effort. If a project is completed in the specified time, the budget is released based on the effort made to complete the project.
  • Apportioned: The budget amounts are released based on the linked activities that use the same earned value method. This method is used for the distribution of the earned value across the activities.

    Example: Activity A2 is linked to activity A1.

    • Earned Value (EV) method of the activity A2 = Apportioned.
    • Earned Value (EV) method of the activity A1 = Percent Complete.
    • The activity A2 also must use the Earned Value (EV) method of A1, Percent Complete.

Project Cost Fact is based on Cost Transaction (tpppc200) in LN. All processed costs are considered for the analysis in Birst. It includes this data:

  • Soft Commitments
  • Hard Commitments
  • Actual Costs
  • See Posting Type of Costs for identifying the type of costs.

Forecast

The Project forecast is based on approved forecasts from:

  • Material Cost Forecast - tpppc216
  • Labor Cost Forecast - tpppc236
  • Equipment Cost Forecast - tpppc256
  • Subcontracting Cost Forecast - tpppc276
  • Sundry Cost Forecast - tpppc296
  • Overhead Cost Forecast - tpppc606