OLAP Dimensions and Measures

• Baseline Estimate Type

• Burden

• Calendar

• COC

• Cost Element Type

• EOC

• ETC Estimate Type

• OBS Performing Dept

• OBS Responsible Dept

• Overtime

• Project

• Resource

• Resource Dept

• WBS

• WBS – EOC – COC – Resource

• XREF-EST

Dimension

Fields

Baseline Estimate Type

These are Base Estimate Type fields, which are actually derived from the DM_EstimateType table through foreign key relationships.

• Estimate Type Description — Represented by the EstimateTypeDesc field.

• Estimate Type Value — Represented by the EstimateTypeValue field. This field displays the estimate type that was last used to create the resource estimate’s value. It has the following possible values:

• 1 - Standard Hours - Manual

• A - Standard Hours - Autospread

• 2 - Hours - Manual

• B - Hours - Autospread

• 3 - Prime Dollars - Manual

• C - Prime Dollars - Autospread

• 4 - Total Burdened - Manual

• D - Total Burdened - Autospread

• 5 - Total Cost - Manual

• E - Total Cost - Autospread

• 6 - Total Dollars - Manual

• F - Total Dollars - Autospread

• 7 - Total Price - Manual

• G - Total Price - Autospread

• 8 - EQP - Manual

• H - EQP - Autospread

• n/a - Person Months - Manual

• I - Person Months - Autospread

• 9 - Units - Manual

• J - Units - Autospread

• ! - Unknown

Burden

These are fields from the DM_Burden table and DM_Global table. Burdens are also specified as Indirect Costs.

There are four type of burden costs:

• Overhead (OH)

• General & Administrative (G&A)

• Cost of Money (COM)

• Fee (profit)

• Burden Code — Represented by the BurdenCode field. This is the identifier for each burden.

• Burden Type — Represented by the BurdenType field. It has the following possible values:

• O – Overhead

• G – G&A

• C – Cost of Money

• F – Fee

• R – Resource

• E – EOC

• Global – Burden – Hierarchy created that combines the DM_Global and DM_Burden tables.

Calendar

These are fields from the DM_Month table.

• Month — Represented by the Month field, which has a format of MMMYY.

• Quarter — Represented by the Quarter field.

• Year — Represented by the Year field.

• Calendar — DM_Month Hierarchy.

COC

COC means Class of Cost. These are fields from the DM_COC table.

• COC Code — Represented by the EOCClass field which is the Class of Cost Code.

• COC Description — Represented by the EOCClassDescription field, which is the Class of Cost Description.

• Global – EOC – COC — Hierarchy created that combines the DM_Global, DM_EOC and DM_COC tables.

Cost Element Type

• Cost Element Type Description — Represented by the CostElementTypeDesc field.

• Cost Element Type Value — Represented by the CostElementTypeValue, which has the following possible values:

• H - Hours/Units

• P - Prime

• O - OverHead

• G - Gen and Admin

• C - Cost of Money

• F - Fee

• S - Standard Hours

• E - Equivalent Persons

• ! - Unknown

EOC

EOC means Elements of Cost and are fields from the DM_EOC table.

• EOC Code — Represented by the EOCCode field which is a required field, for which actuals are being entered.

• EOC Description — Represented by the EOCDescription field.

ETC Estimate Type

These are fields from the DM_EstimateType table, DM_CostElementType,DM_Burden tables and FT_ResourceRollUpDetail.

• Estimate Type Description — Represented by the EtcEstimateTypeDesc field.

• Estimate Type Value — Represented by the EstimateTypeValue field. This field displays the estimate type that was last used to create the resource estimate’s value. It has the following possible values:

• 1 - Standard Hours - Manual

• A - Standard Hours - Autospread

• 2 - Hours - Manual

• B - Hours - Autospread

• 3 - Prime Dollars - Manual

• C - Prime Dollars - Autospread

• 4 - Total Burdened - Manual

• D - Total Burdened - Autospread

• 5 - Total Cost - Manual

• E - Total Cost - Autospread

• 6 - Total Dollars - Manual

• F - Total Dollars - Autospread

• 7 - Total Price - Manual

• G - Total Price - Autospread

• 8 - EQP - Manual

• H - EQP - Autospread

• n/a - Person Months - Manual

• I - Person Months - Autospread

• 9 - Units - Manual

• J - Units - Autospread

• ! - Unknown

OBS Performing Dept

These are fields from the DM_OBSPerformingDept and DM_BurdenTemplates.

• Burden Template Code — Represented by the BurdenTemplateCode field.

• Burden Template Description — Represented by the BurdenTemplateDescription.

• OBS Description — Represented by the OBSDescription field which is the Department Description.

• OBS Manager — Represented by the OBSManager field, which is the Department Manager.

• OBS Performing Parent — Represented by the OBSParent field, which is the Performing Department Parent ID, (This is the top level department represented by “Top Dept.”)

• Burden Templates — OBS Performing Dept – Hierarchy created between DM_Burden Templates and DM_OBSPerformingDept.

• OBS Performing Dept Tree — DM_OBS PerformingDept Hierarchy.

• Project – OBS Performing Dept — Hierarchy created between DM_Project and DM_OBSPerformingDept.

OBS Responsible Dept

These are the fields from the DM_OBSResponsibleDept and DM_BurdenTemplates tables.

• Burden Template Code — Represented by the BurdenTemplateCode field.

• Burden Template Description — Represented by the BurdenTemplateDescription.

• OBS Description — Represented by the OBSDescription field, which is the Department Description.

• OBS Manager — Represented by the OBSManager field, which is the Department Manager.

• OBS Responsible Parent — Represented by the OBSResponsibleParent, which is the Responsible Department Parent ID, (This is the top level department represented by “Top Dept.”)

• Burden Templates — OBS Responsible Dept – Hierarchy created between DM_BurdenTemplates and DM_OBSResponsibleDept.

• OBS Responsible Dept Tree — DM_OBSResponsibleDept Hierarchy.

• Project – OBS Responsible Dept — Hierarchy created between DM_Project and DM_OBSResponsibleDept.

Overtime

These are fields from the DM_Overtime table.

• Overtime Value — Represented by the OvertimeValue field, which is the actual value of the overtime.

• Project – Overtime — Hierarchy created between DM_Project and DM_Overtime tables.

Project

These are fields from the DM_Project table and DM_Global tables.

• Actual Rate Table – Represented by the ActualRateTable field.

• Baseline Rate Table – Represented by the BaselineRateTable field.

• Burden Template Override – Represented by the BurdenTemplateOverride field.

• Calendar – Represented by the Calendar field.

• Contract End – Represented by the ContractEnd field.

• Contract No – Represented by the ContractNo field.

• Contract Start – Represented by the ContractStart field.

• Contract Type – Represented by the ContractType field.

• ETC Rate Table – Represented by the ETCRateTable field.

• Fee Calculation – Represented by the FeeCalculation field.

• Global Desc – Represented by the GlobalDesc field.

• Global ID – Represented by the GlobalID field.

• Global Path – Represented by the GlobalPath field.

• Program Manager – Represented by the ProgramManager field.

• Program Name – Represented by the ProjProgramName field. This will have the same value as the Program Name.

• ProgramType – Represented by the ProgramType field.

• Project ID – Represented by the ProjProjectID field.

• Project Path – Represented by the ProjPath which is the subdirectory path to project location.

• Proposal Manager – Represented by the ProposalManager field.

• Proposal No – Represented by the ProposalNo field.

• Rate Table Override – Represented by the RateTableOverride field.

• Site Name – Represented by the SiteName field.

Resource

These are fields from the DM_Resource table, DM_EOC, DM_COC and DM_Global table.

• Resource Code — Represented by the ResourceCode field.

• Resource Days Per Week — Represented by the ResourceDaysPerWeek field.

• Resource Description — Represented by the ResourceDescription field.

• Resource Hours Per Day — Represented by the ResourceHoursPerDay field.

• Global – EOC – COC – Resource — Hierarchy created between DM_Global, DM_EOC, DM_COC, and DM_Resource tables.

Resource Dept

These are fields from the DM_ResourceDept and DM_Project tables.

• Resource Dept Desc — Represented by the ResourceDescription field.

• Resource Dept ID — Represented by the ResourceDeptID field which Resource Department ID. (This is the top level department represented by “Top Dept.”)

• Resource Dept Parent — Represented by the ResourceDeptParent field which is the Resource Department Parent ID. (This is the top level department represented by “Top Dept.”)

• Project – Resource Dept — Hierarchy created between DM_Project and DM_ResourceDept tables.

WBS

These are fields from the DM_WBS and DM_CLIN tables.

• Alias — Represented by the WBSAlias, the Alternate WBS Alias Name.

• Apportioned Base WBS — Represented by the WBSAppBaseID field, which is the Apportioned Base WBS Key.

• BCWP Base — Represented by the WBSBCWPBase field. This is a WBS field that shows which unit will be used when calculating the BCWP for a WBS element. It has the following base unit values:

• Hours/Units

• Prime

• Total Burdened

• Total Cost

• Total Dollars

• Unknown

• Charge Number — Represented by the WBSChargeNo field. This is a 20-character internal accounting system identifier used to collect costs.

• CLIN Code — Represented by the ClinCode field which serves as a link to the DM_CLIN table. It is an optional 8 character field which identifies the Contract Line Item Number for a WBS.

• CLIN DD1921 — Represented by the DD1921 field which means Include on DD192. Its possible values are Yes and No.

• CLIN Description — Represented by the ClinDescription field.

• CLIN Element Code — Represented by the ElementCode field.

• CLIN Quantity — Represented by the Quantity field which is the quantity to be contracted.

• CLIN Reference Code — Represented by the ReferenceCode field.

• CLIN SF1411 — Represented by the SF1411, which means Include on SF1411. Its possible values are Yes and No.

• Complete — Represented by the WBScheduledEnd field.

• Description — Represented by the WBSDescription field.

• Early Finish Date — Represented by the EarlyFinishDate field.

• Early Start Date — Represented by the EarlyStartDate field.

• Element Type — Represented by the WBSCostAccountFlag. It describes the element’s position and function in the WBS Tree. The available element types are:

• Control Account

• Work Package

• Planning Package

• Other Package

• Unknown

• ETC Complete Date — Represented by the WBSEtcEndDate field.

• ETC Start Date — Represented by the WBSEtcStartDate field.

• EVM — Represented by the WBSEVMCode field. This field has the following possible values:

• No EVM Required — No earned value computation is required.

• % Start / % Complete — There are four different % Start / % Complete EVMS available: 0/100 or 100/0, 25/75, 40/60, and 50/50

• % Complete — Lets you manually enter a cumulative percentage for the WBS element.

• Level of Effort (LOE) — Monthly budget value is earned with the passage of time and is equal to the monthly scheduled amount (BCWP=BCWS).

• Earned Standards — Earned standards is used to determine earned value for tasks whose budget value was derived using standard hours.

• Milestone Weights — Budget value is earned based on the proportional weight you assign to each milestone.

• BCWP Entry — Select this option when you will be entering BCWP as a cumulative lump sum.

• Apportioned — The apportioned EVM is used to calculate earned value for tasks that are related in direct proportion to some other work package.

• Milestone Weights with % Complete — This is the same as Milestone Weights except you can enter a percent complete for each individual milestone instead of just the WBS element.

• Key Event — The Key Event is a variation on Level of Effort (LOE).

• Unknown

• Fee Limit — Represented by the WBSFeeLimitAmount field.  This is an optional field where you can enter the fee limit (up to 16 digits) for a WBS element.

• Fee Percent — Represented by the WBSFeePct field. It is an optional field where you can enter the percentage of the fee that can be allocated to each WBS element and its children.

• Last Statused Date — Represented by the WBSLastAsOfDate field.

• Late Finish Date — Represented by the WBSLateFinishDate field.

• Late Start Date — Represented by the WBSLateStartDate field.

• Level — Represented by the WBSLevel field. This field shows the hierarchical level of the WBS element and the relationship of the element to its parent. The top element in the WBS has a Level value of 1.

• Manager — Represented by the WBSManager field. The Manager field is an optional 20-character field used to specify the WBS manager’s name.

• Parent — Represented by the WBSParent field. The Parent field positions the WBS element hierarchically within the WBS Tree.

• Percent Complete — Represented by WBSPercentComplete field, which is the Technical Percent Complete and is used in NASA 533-P Report.

• Recur —  Represented by the WBSRecur field. It is an optional field that identifies a WBS element as an activity that is repeated (recurring) or an activity that is done only once (nonrecurring).

• Rev Letter Date — Represented by the WBSRevLetterDate field. This field shows that date when this WBS was last revised. It can be edited only on control accounts.

• Schedule Ref Date — Represented by the WBSScheduledRefDate field.

• Start — Represented by the WBSScheduledStart field.

• Task Description — Represented by the TaskDescription field.

• WBS ID — Represented by the WBSID field.

• XREF1 through XREF10 — These fields are represented by the WBSXREF1 through WBSXREF10 fields.

These are optional 20-character user-defined fields provided as additional identifiers that can be used for reporting, exporting, or onscreen filtering. You can define the field names for these fields in the Project Maintenance window. You can use these fields as wild cards, to match a specific group of data.

XREF-1 is used for identifying distributed WBS’s. If XREF-1 is changed to DISTRIBUTED then it cannot be a parent WBS.

• CLIN - WBS — Hierarchy created between DM_CLIN and DM_WBS tables.

• WBS Tree — WBS Hierarchy.

WBS – EOC – COC – Resource

This is a derived dimension that is constructed by combining several tables:

• DM_WBS

• DM_EOC

• DM_COC

• DM_Resource

WBS – EOC – COC – Resource Tree - Hierarchy created between DM_WBS, DM_EOC, DM_COC, and DM_Resource tables.

XREF-EST

These are fields from the DM_XREF_EST table.

• XREF-EST Value — Represented by the XrefEstValue field.

• Project – XREF-EST — Hierarchy created between DM_Project and DM_XREF_EST tables.

Measure

Description

ACWP

This represents the Actual Cost of Work Performed.

BCWP

This represents Budgeted Cost of Work Performed.

BCWS

This represents the Budgeted Cost of Work Scheduled.

ETC

This represents the Estimate to Complete or estimate of remaining work.

LRE

This stands for Last Revised Estimate, which can be calculated for any WBS element or any WBS level.

CPI

This stands for Cost Performance Index and it can be calculated using the following formula: BCWP/ACWP.

CV

This stands for Cost Variance and it represents the variance between the cost of work performed and actual costs (BCWP-ACWP)

SPI

This stands for Schedule Performance Index and it can be calculated using the following formula: BCWP/BCWS.

SV

This stands for Schedule Variance and it represents the variance between the work performed and the work schedule (BCWP-BCWS).