Operational Reporting Views

The following are the new views materialized or added for the Operational Reporting schema.

• Views materialized in OpenText PPM 9.10:

  • RPT_DIM_BUSINESS_OBJ_MV

  • RPT_DIM_FM_FCST_ACTUAL_LINE_MV

  • RPT_DIM_FM_FCST_ACTUAL_MV

  • RPT_DIM_FM_FIN_SUMMARY_MV

  • RPT_DIM_FM_KNTA_LOOKUPS_MV

  • RPT_DIM_ORG_UNITS_MV

  • RPT_DIM_PROGRAMS_MV

  • RPT_DIM_PROGRAM_CONTENT_MV

  • RPT_DIM_PROJECTS_MV

  • RPT_DIM_REGIONS_MV

  • RPT_DIM_TM_ACTIVITIES_MV

  • RPT_DIM_TM_CHARGE_CODES_MV

  • RPT_DIM_TM_PERIODS_MV

  • RPT_FCT_FM_FA_APPROVED_MV

  • RPT_PPM_AGGR_WRK_DAYS_MV

• Views materialized in OpenText PPM 9.12 Content Pack 1:

  • RPT_DIM_PM_DTL_CSTPARMS_IRS_MV

  • RPT_DIM_PM_HDR_CSTPARMS_IRS_MV

  • RPT_DIM_PM_PROJ_ISSUE_MV

  • RPT_DIM_PM_PROJ_RISK_MV

  • RPT_DIM_PM_PROJ_SCPCHG_MV

  • RPT_DIM_PM_PROJ_SETTINGS_MV

  • RPT_DIM_PM_WORKPLAN_MV

• Views materialized or added in Content Pack 2.0:

  • RPT_REQ_<Request_Type>
  • RPT_TC_<Table_Component>
  • RPT_DIM_PORTFOLIO_ MANAGERS_MV
  • RPT_DIM_WORKFLOW_ STEPS
  • RPT_DIM_PORTFOLIOS
  • RPT_DIM_FM_BENEFIT_MV
  • RPT_DIM_FM_BENEFIT_ LINE_MV
  • RPT_DIM_PROJECTS_MV
  • RPT_DIM_PROGRAMS_MV
  • RPT_FCT_FM_FA_ APPROVED_MV