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 |
