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