Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: