Table 142. Sourcing Reports for Pharma Disconnected Analytics
|
|
|
Pharma Promotional Effectiveness |
Day Dimension |
W_DAY_D |
Pharma Promotional Effectiveness |
Product Ranking Dimension |
W_CON_RANK_D |
Pharma Promotional Effectiveness |
Brick Dimension |
W_AREA_D |
Pharma Promotional Effectiveness |
Geography Dimension |
W_GEO_D |
Pharma Promotional Effectiveness |
Payor Plan Dimension |
W_INS_PLAN_D |
Pharma Promotional Effectiveness |
Product Hierarchy |
W_PRODUCT_DH |
Pharma Promotional Effectiveness |
Position Hierarchy |
W_POSITION_DH |
Pharma Promotional Effectiveness |
Call Priority List of Value Dimension |
W_LOV_D |
Pharma Promotional Effectiveness |
Product Indication List of Value Dimension |
W_LOV_D |
Pharma Sales Effectiveness |
Period Type List of Value Dimension |
W_LOV_D |
Pharma Promotional Effectiveness |
Person Dimension |
W_PERSON_D |
Pharma Objective Achievement |
Plan Promotion Dimension |
W_PLAN_PROMO_D |
Pharma Customer Demographics |
Contact Primary Address Dimension |
W_POSTN_CON_D |
Pharma Promotional Effectiveness |
Contact Call Activity Fact |
W_CON_CALL_F |
Pharma Promotional Effectiveness |
Contact Call Activity Aggregate |
W_CON_CALL_N_A |
Pharma Objective Achievement |
Contact Objective Fact |
W_CON_OBJ_F |
Pharma Sales Effectiveness |
Indirect Sales Market Level Fact |
W_MARKET_IDS_F |
Pharma Sales Effectiveness |
Indirect Sales Market Level Aggregate |
W_MARKET_IDS_N_A |
Pharma Sales Effectiveness |
Prescription Market Level Fact |
W_MARKET_RX_F |
Pharma Sales Effectiveness |
Prescription Market Level Aggregate |
W_MARKET_RX_N_A |
Pharma Sales Effectiveness |
Direct Sales Fact |
W_SYND_DS_F |
Pharma Sales Effectiveness |
Direct Sales Aggregate |
W_SYND_DS_N_A |
Pharma Sales Effectiveness |
Indirect Sales Fact |
W_SYND_IDS_F |
Pharma Sales Effectiveness |
Indirect Sales Aggregate |
W_SYND_IDS_N_A |
Pharma Sales Effectiveness |
Prescription Sales Fact |
W_SYND_RX_F |
Pharma Sales Effectiveness |
Prescription Sales Aggregate |
W_SYND_RX_N_A |