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