Dimensional Warehouse Model Data Model

Entity

Entity Product Development KPI For Growth Analysis

Description

Analysis of the key performance indicators for the product development processes, to grow revenue.

Attributes
Average Product Concept Development Time
Average Product Launch Time
Average Product Manufacture Time
Calendar Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Market Share
Market Share Growth
Number Of New Members Acquired
Number Of New Product Concepts Developed
Number Of New Products Developed
Number Of New Products Launched
Number Of New Products Manufactured
Organization Dk
Percentage Revenue From New Products
Product Concept Development Time
Product Launch Time
Product Manufacture Time
Revenue Amount
Revenue From New Products Amount
Time To Market For New Products

Relationship
Product Development KPI For Growth Analysis_Calendar Dimension_FK
Product Development KPI For Growth Analysis_Geographic Area Dimension_FK
Product Development KPI For Growth Analysis_Group Dimension_FK
Product Development KPI For Growth Analysis_Health Plan Product Dimension_FK
Product Development KPI For Growth Analysis_Organization Dimension_FK

Primary Key
Product Development KPI For Growth Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Product Concept Development Time

Description	The average actual time spent on product concept development. Average per product concept developed. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

Average Product Launch Time

Description	The average actual time spent on product launch activities. Average per product launched. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
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

Average Product Manufacture Time

Description	The average actual time spent on product manufacturing. Average per product manufactured. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

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

Market Share

Description	The market share held by an organization or product at the reference date or the average market share during the measurement 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

Market Share Growth

Description	The increase (or decrease) in market share over comparative periods expressed as a percentage of the market share in the earlier period. Formula: [((A current period / A prior period) -1)*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 Members Acquired

Description	The number of members who bought through the campaign and who did not own active products beforehand. May be applied to group or individual members as appropriate to the campaign.
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 Product Concepts Developed

Description	The total number of new concepts for products that was developed. This relates to the planning of product development and measures the total number of new product opportunities that are identified and for which the initial concept is developed.
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 Developed

Description	The total number of new products that was developed in the reference period. This counts the products for which the full development cycle was completed, from product concept development, over product manufacturing, until product launch.
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 Manufactured

Description	The total number of new products that was manufactured. This relates to the design of the product starting from an initial concept (draft) until completion of the product specification (defined).
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

Percentage Revenue From New Products

Description	The proportion of the revenue that is produced by selling new products expressed as a percentage of the revenue generated by sales of all products. 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 Time

Description	The actual time spent on product concept development.
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

Product Launch Time

Description	The actual time spent on product launch activities.
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

Product Manufacture Time

Description	The actual time spent on product manufacture.
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

Revenue Amount

Description	The total amount of revenue generated by the activities of the organization during the period.
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

Revenue From New Products Amount

Description	The total income that is generated by new 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

Time To Market For New Products

Description	The total cycle time to bring new products 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 KPI For Growth Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development KPI For Growth 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 KPI For Growth Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development KPI For Growth 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 KPI For Growth Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development KPI For Growth 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 KPI For Growth Analysis_Health Plan Product Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development KPI For Growth 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 KPI For Growth Analysis_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	Product Development KPI For Growth 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

Primary Key Details

Product Development KPI For Growth 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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model