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