Vertica for PPM Views

The following are the new views for the Vertica for PPM schema.

  • DIM_RESOURCE_POOLS_DRILL_UP_V
  • DIM_RESOURCE_POOLS_DRILL_DOWN_V
  • DIM_ROLES_V
  • BRIDGE_RESOURCE_ROLES_V
  • DIM_ASSETS_V
  • DIM_PROPOSALS_V
  • BRIDGE_ASSET_MANAGERS_V
  • BRIDGE_PROJECT_MANAGERS_V
  • DIM_RESOURCE_POOLS_V
  • BRIDGE_SKILL_PROFICIENCY_V
  • FACT_RESOURCE_ALLOCATION_V
  • BRIDGE_ORG_UNIT_MEMBERS_V
  • BRIDGE_RESOURCE_POOL_MANAGERS_V
  • DIM_TASKS_V
  • DIM_RESOURCES_V
  • DIM_SKILLS_V
  • DIM_POSITIONS_V
  • FACT_POSITIONS_V
  • BRIDGE_RESOURCE_POOL_RESOURCES_V
  • DIM_PROJECTS_V
  • BRIDGE_PROPOSAL_MANAGERS_V
  • FACT_RESOURCE_DEMAND_V
  • FACT_RESOURCE_CAPACITY_V
  • FACT_RESOURCE_ACTUAL_EFFORT_V

Dynamic views

The following views are dynamic.

  • DIM_CONTACTS_<Infix>_V
  • DIM_ORG_UNITS_<Infix>_V
  • DIM_ORG_UNITS_<Infix>_DRILL_DOWN_V
  • DIM_ORG_UNITS_<Infix>_DRILL_UP_V
  • DIM_REQUESTS_<Infix>_V

The value of <Infix> is decided by the MDL_VIEW_NAME_ROOT column of the KNTA_PARAMETER_SET_CONTEXTS table in PPM. That is, if the corresponding value of the MDL_VIEW_NAME_ROOT column is not null, the value of <Infix> is the same as MDL_VIEW_NAME_ROOT. If the corresponding value of the MDL_VIEW_NAME_ROOT column is null, the value of <Infix> is the same as the value of the USER_DATA_SET_CONTEXT_ID column of the corresponding PPM table.

The corresponding PPM tables of the dynamic views are listed below.

Dynamic View Vertica for PPM Table PPM Table
DIM_CONTACTS_<Infix>_V DIM_CONTACTS KCRT_CONTACTS
DIM_ORG_UNITS_<Infix>_V DIM_ORG_UNITS KRSC_ORG_UNITS
DIM_ORG_UNITS_<Infix>_DRILL_DOWN_V DIM_ORG_UNITS ORG_UNIT
DIM_ORG_UNITS_<Infix>_DRILL_UP_V DIM_ORG_UNITS ORG_UNIT
DIM_REQUESTS_<Infix>_V DIM_REQUESTS KCRT_REQUESTS