Dimensional Warehouse Model Data Model

Entity

Entity Product Development Optimization And Expense Analysis

Description

Analysis of the product development processes to monitor expenditure, optimize capital efficiency and manage enterprise risk.

Attributes
Average Cost To Bring New Product To Market Amount
Calendar Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Incremental Member Service Cost For New Products Amount
Incremental Processing Cost For New Products Amount
Job Dk
Launched Products Percentage
Number Of New Products Developed On Time
Number Of New Products Launched
Number Of New Products Planned
Number Of Product Concepts Developed On Time
Number Of Product Development Iterations
Number Of Products Launched On Time
Number Of Products Manufactured On Time
Organization Dk
Party Role Dk
Product Concept Development Cost Amount
Product Concept Development On Time Percentage
Product Concept Development Personnel Utilization
Product Development Cost Amount
Product Development Cost Forecast Accuracy Ratio
Product Development Forecast Cost Amount
Product Development On Time Percentage
Product Development Personnel Utilization
Product Launch Cost Amount
Product Launch On Time Percentage
Product Launch Personnel Utilization
Product Manufacturing Cost Amount
Product Manufacturing On Time Percentage
Product Manufacturing Personnel Utilization
Time To Market For New Product

Relationship
Product Development Optimization And Expense Analysis_Calendar Dimension_FK
Product Development Optimization And Expense Analysis_Geographic Area Dimension_FK
Product Development Optimization And Expense Analysis_Group Dimension_FK
Product Development Optimization And Expense Analysis_Health Plan Product Dimension_FK
Product Development Optimization And Expense Analysis_Organization Dimension_FK
Product Development Optimization And Expense Analysis_Party Role Dimension_FK
Product Development Optimization And Expense Analysis_Job Dimension_FK

Primary Key
Product Development Optimization And Expense Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Cost To Bring New Product To Market Amount

Description	This is the average of total product development cost that is required to bring a new product to the market. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Geographic Area Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Group Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Health Plan Product Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Incremental Member Service Cost For New Products Amount

Description	Total costs of the member service activities related to the new product.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Incremental Processing Cost For New Products Amount

Description	Total of all costs related to the processing of the new product. This includes costs like policy administration, billing and collection and claim handling.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Job Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Launched Products Percentage

Description	Percentage of products that go from 'product concept development' to 'product launch'. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of New Products Developed On Time

Description	The number of new products developed by the planned date.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of New Products Launched

Description	Total number of new products that was brought to the market.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of New Products Planned

Description	The number of new products the organization planned to launch in the period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Product Concepts Developed On Time

Description	The number of product concept development projects completed on time.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Product Development Iterations

Description	Number of times that the product development process was iterated before reaching a successful completion for a product. Counts the number of times changes were applied to the product design.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Products Launched On Time

Description	The number of products launched by their originally planned date.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Products Manufactured On Time

Description	The number of planned new product projects whose manufacturing phase was completed on time.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Party Role Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Product Concept Development Cost Amount

Description	Total cost of developing the product concept.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Concept Development On Time Percentage

Description	Percentage of product concept development projects that gets completed on time. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Concept Development Personnel Utilization

Description	Actual utilization of human resources (personnel) for the development of a new product concept expressed in full time equivalents (FTE).
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Development Cost Amount

Description	The actual costs associated with the development of products.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Development Cost Forecast Accuracy Ratio

Description	The accuracy of the forecasting of process development costs, expressed as the ratio between actual and planned product development cost. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Development Forecast Cost Amount

Description	The amount provided for the development of products in the original or revised forecast.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Development On Time Percentage

Description	Percentage of product development projects that get completed on time. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Development Personnel Utilization

Description	Actual utilization of human resources (personnel) for the full new product development cycle expressed in full time equivalents (FTE).
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Launch Cost Amount

Description	Total cost of launching a product.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Launch On Time Percentage

Description	Percentage of successful product launch projects that gets completed on time. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Launch Personnel Utilization

Description	Actual utilization of human resources (personnel) for the launch of a new product expressed in full time equivalents (FTE).
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Manufacturing Cost Amount

Description	Total cost of manufacturing a product. This excludes the cost for developing the initial product concept.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Manufacturing On Time Percentage

Description	Percentage of product manufacturing projects that gets completed on time. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Manufacturing Personnel Utilization

Description	Actual utilization of human resources (personnel) for manufacturing a new product expressed in full time equivalents (FTE).
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Time To Market For New Product

Description	The total cycle time to bring a new product to the market. This is the total time that elapses between the first introduction of a product idea and it's first availability in the market.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Product Development Optimization And Expense Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Health Plan Product Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Health Plan Product Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Party Role Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Party Role Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product Development Optimization And Expense Analysis_Job Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development Optimization And Expense Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Job Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Product Development Optimization And Expense Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk
Key Attribute	Health Plan Product Dk
Key Attribute	Organization Dk
Key Attribute	Party Role Dk
Key Attribute	Job Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model