PMO Accelerator Advanced Reporting Content

The PMO Accelerator add-in includes a collection of Advanced Reporting content. The PMO Accelerator is a required prerequisite of the Advanced Reporting content. Many of the reports reference items that are delivered through the PMO Accelerator.
ccppmod156
The PMO Accelerator add-in includes a collection of Advanced Reporting content. The PMO Accelerator is a
required
prerequisite of the Advanced Reporting content. Many of the reports reference items that are delivered through the PMO Accelerator.
The Advanced Reporting content includes the following items:
  • Data Sources
  • Domains
  • Input Controls
  • Reports
  • Roles
  • Templates
PMO Accelerator Attributes and Data Warehouse
The majority of attributes installed by the PMO Accelerator have the
Include
in the Data Warehouse
field checked. Do not uncheck this field because reports depend upon it. The PMO Accelerator attribute IDs are renamed when their respective columns are created in the data warehouse (DWH).
A complete list of the PMO Accelerator attributes and their corresponding Data Warehouse column names is included in the following tables.
Object: Benefit Plan
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Benefit Class
obj_benefit_class
Yes
dwh_fin_benefit_plan
benefit_class_key
dwh_lkp_benefit_class
 
Benefit Subclass
obj_benefit_subclass
Yes
dwh_fin_benefit_plan benefit_subclass_key
dwh_lkp_benefit_subclass
 
Object: Idea
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Business Owner
obj_business_owner
Yes
dwh_inv_idea
business_owner_key
 
No lookup table is required because it should be joined to the DWH_RES_RESOURCE table.
Idea Category
obj_request_category
Yes
dwh_inv_idea idea_prj_category_key
dwh_lkp_idea_prj_category
The same lookup table is available for Idea and Project.
Idea Type
obj_request_type
Yes
dwh_inv_idea
idea_prj_type_key
dwh_lkp_idea_prj_type
The same lookup table is available for Idea and Project.
Fast Track
obj_fast_track
Yes
dwh_inv_idea
is_fast_track
 
 
Objective
obj_objective
Yes
dwh_inv_idea
objective
 
 
Object: Investment
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Architectural Fit
obj_align_factor3
Yes
dwh_inv_investment
align_architectural_key
dwh_lkp_align_factor1_4
 
Business Alignment
obj_alignment
Yes
dwh_inv_investment business_alignment
 
This is a calculated attribute and does not have a lookup table with the display mappings.
Business Unit Priority
obj_align_factor2
Yes
dwh_inv_investment
align_business_unit_key
dwh_lkp_align_factor1_4
 
Commercial Value
obj_align_factor4
Yes
dwh_inv_investment
align_commercial_key
dwh_lkp_align_factor1_4
 
Corporate Priority
obj_align_factor1
Yes
dwh_inv_investment
align_corporate_key
dwh_lkp_align_factor1_4
 
Portfolio Category 1
obj_pfl_category1
Yes
dwh_inv_investment
portfolio_cat1_key
dwh_lkp_portfolio_cat1
 
Portfolio Category 2
obj_pfl_category2
Yes
dwh_inv_investment
portfolio_cat2_key
dwh_lkp_portfolio_cat2
 
Portfolio Category 3
obj_pfl_category3
Yes
dwh_inv_investment
portfolio_cat3_key
dwh_lkp_portfolio_cat3
 
Portfolio Category 4
obj_pfl_category4
Yes
dwh_inv_investment
portfolio_cat4_key
dwh_lkp_portfolio_cat4
 
Regulatory Compliance
obj_align_factor5
Yes
dwh_inv_investment
align_regulatory_key
dwh_lkp_align_factor5
 
Technology Compliance
obj_align_factor6
Yes
dwh_inv_investment
align_technology_key
dwh_lkp_align_factor6
 
Work Status
obj_work_status
Yes
dwh_inv_investment
work_status_key
dwh_lkp_work_status
 
Object: Project
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Business Owner
obj_stakeholder1
Yes
dwh_inv_project
business_owner_key
 
No lookup table is required because it should be joined to the DWH_RES_RESOURCE table.
Cost Variance %
obj_ev_cv_pct
No
dwh_inv_summary_facts
ev_cost_var_pct
 
This attribute is not enabled because it already exists in the facts table.
Estimating Factor 1
obj_est_factor1
Yes
dwh_inv_project
estimating_factor_1
 
 
Estimating Factor 2
obj_est_factor2
Yes
dwh_inv_project
estimating_factor_2
 
 
Finance and Governance
obj_stakeholder3
Yes
dwh_inv_project
finance_governance_key
 
No lookup table is required because it should be joined to the DWH_RES_RESOURCE table.
Objective
obj_objective
Yes
dwh_inv_project
objective
 
 
Project Category
obj_request_category
Yes
dwh_inv_project
idea_prj_category_key
 
 
Project Management Office
obj_stakeholder2
Yes
dwh_inv_project
project_mgmt_office_key
 
No lookup table is required because it should be joined to the DWH_RES_RESOURCE table.
Project Template
obj_methodology
No
 
 
This attribute is not enabled for this release.
Project Type
obj_request_type
Yes
dwh_inv_project
idea_prj_type_key
 
 
Projected Cost Variance
obj_cost_amt_var
No
dwh_inv_summary_facts
eac_base_cost_var
 
This attribute is not enabled because it already exists in the facts table.
Projected Cost Variance %
obj_cost_pct_var
No
dwh_inv_summary_facts
eac_base_cost_pct
 
This attribute is not enabled because it already exists in the facts table.
Projected Effort Variance
obj_effort_amt_var
No
dwh_inv_summary_facts
eac_base_hours_var
 
This attribute is not enabled because it already exists in the facts table.
Projected Effort Variance %
obj_effort_var
No
dwh_inv_summary_facts
eac_base_hours_pct
 
This attribute is not enabled because it already exists in the facts table.
Schedule to Baseline
obj_schedule_var
No
 
 
 
Schedule Variance %
obj_ev_sv_pct
Yes
dwh_inv_summary_facts
ev_schedule_var_pct
 
This attribute is not enabled because it already exists in the facts table.
Status Reporting
obj_status_reporting
Yes
dwh_inv_project
status_reporting_key
dwh_lkp_status_reporting
 
Object: Status Report
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Change Explanation
cop_scope_exp
Yes
dwh_inv_status_report
change_explanation
 
 
Cost and Effort Explanation
cop_effort_exp
Yes
dwh_inv_status_report
cost_effort_explanation
 
 
Cost and Effort Status
cop_cost_eft_status
Yes
dwh_inv_status_report
sr_cost_effort_status_key
dwh_lkp_sr_status
 
Current Phase
cop_phase
No
 
 
 
Deliverable Scope Changed
cop_scope_deliver
Yes
dwh_inv_status_report
is_deliverable_scope_change
 
 
Key Accomplishments
cop_key_accomplish
Yes
dwh_inv_status_report
key_accomplishments
 
 
Next Milestone on Track
cop_sched_milestone
Yes
dwh_inv_status_report
is_next_milestone_on_track
 
 
Overall Status
cop_overall_status
Yes
dwh_inv_status_report
overall_status
 
This is a calculated attribute and does not have a lookup table with the display mappings.
Project Affected by External Factors?
cop_cost_effort_ext
Yes
dwh_inv_status_report
is_project_external_factors
 
 
Project ID
cop_project_id
No
 
 
This is a virtual attribute. Virtual attributes are not enabled.
Project Manager
cop_project_manager
No
 
 
This is a virtual attribute. Virtual attributes are not enabled.
Project Name
cop_project_name
No
 
 
This is a virtual attribute. Virtual attributes are not enabled.
Project Objective Changed
cop_scope_obj
Yes
dwh_inv_status_report
is_project_objective_change
 
 
Report Date
cop_report_date
Yes
dwh_inv_status_report
report_date
 
 
Report Status
cop_report_status
Yes
dwh_inv_status_report
sr_report_status_key
dwh_lkp_sr_report_status
 
Review Approval Problems?
cop_cost_effort_rev
Yes
is_review_approval_problems
 
 
Schedule Status
cop_schedule_status
Yes
dwh_inv_status_report
sr_schedule_status_key
dwh_lkp_sr_status
 
Scope Change Required
cop_scope_change
Yes
dwh_inv_status_report
is_scope_change_required
 
 
Scope Status
cop_scope_status
Yes
dwh_inv_status_report
sr_scope_status_key
dwh_lkp_sr_status
 
Staffing/Availability Issues?
cop_cost_eft_staff
Yes
dwh_inv_status_report
is_staff_avail_issues
 
 
Status Report Update
cop_report_update
Yes
dwh_inv_status_report
report_update
 
 
Upcoming Activities
cop_upcoming_act
Yes
dwh_inv_status_report
upcoming_activities
 
 
Variance Explanation
cop_schedule_exp
Yes
dwh_inv_status_report
variance_explanation
 
 
Object: Task
Attribute
Attribute ID
DWH
Enabled
Table
Column
Lookup Table
Notes
Cost Variance %
obj_ev_cv_pct
No
dwh_inv_task_summary_facts
ev_cost_var_pct
 
This attribute is not enabled because it already exists in the facts table.
Schedule Variance %
obj_ev_sv_pct
No
dwh_inv_task_summary_facts ev_schedule_var_pct
 
This attribute is not enabled because it already exists in the facts table.