Table 10. Data Loading Matrix
Screen
|
View
|
Dashboard
|
Page
|
Source OLAP table
|
OLTP Data Source from S_SYND_DATA to populate Source Star
|
S_SYND_ DATA Mandatory ID
|
Plan Type
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Market Share
|
W_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Product Growth
|
W_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Sales Force Index
|
W_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Market Share (Brick)
|
W_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Product Growth (Brick)
|
W_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Analytics
|
Pharma Sales
|
Sales Force Index (Brick)
|
W_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Objectives Analytics
|
Pharma Objectives
|
Contact Frequency & Reach
|
W_OBJECTIVE_F
|
RxPrf (NRx, TRx Objectives)SlsIndZip (Indirect Sales Objectives)
|
Contact IDZip ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Objectives Analytics
|
Pharma Objectives
|
Account Frequency & Reach
|
W_OBJECTIVE_F
|
RxPrf (NRx, TRx Objectives)SlsIndZip (Indirect Sales Objectives)
|
Contact IDZip ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Objectives Analytics
|
Pharma Objectives
|
Contact Frequency & Reach (Brick)
|
W_OBJECTIVE_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Rx Sales Analytics
|
Sales Objectives Analytics
|
Pharma Objectives
|
Account Frequency & Reach (Brick)
|
W_OBJECTIVE_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Call Activity Analytics
|
Contact Call Analytics
|
Pharma Contact Call Effectiveness
|
Contact Effort vs. Potential
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Call Activity Analytics
|
Contact Call Analytics
|
Pharma Contact Call Effectiveness
|
Contact Priority & Indication
|
W_ACT_PROD_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Call Activity Analytics
|
Contact Call Analytics
|
Pharma Contact Call Effectiveness
|
Contact Effort vs. Potential (Brick)
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Call Activity Analytics
|
Contact Call Analytics
|
Pharma Contact Call Effectiveness
|
Contact Priority & Indication (Brick)
|
W_ACT_PROD_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Call Activity Analytics
|
Account Call Analytics
|
Pharma Account Call Effectiveness
|
Account Effort vs. Potential
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
SlsIndZip
|
Zip ID or Account ID
|
TOTAL
|
Call Activity Analytics
|
Account Call Analytics
|
Pharma Account Call Effectiveness
|
Account Priority & Indication
|
W_ACT_PROD_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Call Activity Analytics
|
Account Call Analytics
|
Pharma Account Call Effectiveness
|
Account Effort vs. Potential (Brick)
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Call Activity Analytics
|
Account Call Analytics
|
Pharma Account Call Effectiveness
|
Account Priority & Indication (Brick)
|
W_ACT_PROD_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Pharma ROI Analytics
|
Call Activity Profit & Loss Analytics
|
Pharma Call Activity Profit & Loss
|
Call Activity Profit & Loss
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Pharma ROI Analytics
|
Call Activity Profit & Loss Analytics
|
Pharma Call Activity Profit & Loss (Brick)
|
Call Activity Profit & Loss (Brick)
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
SlsIndBrk
|
Area ID
|
TOTAL
|
Medical Education Analytics
|
MedEd Analytics
|
Pharma Medical Education
|
Event Analysis
|
W_MED_ED_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Medical Education Analytics
|
MedEd Analytics
|
Pharma Medical Education
|
Speaker Analysis
|
W_MED_ED_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Medical Education Analytics
|
MedEd Analytics
|
Pharma Medical Education
|
Budget Analysis
|
W_MED_ED_F
|
Not Applicable
|
Not Applicable
|
Not Applicable
|
Medical Education Analytics
|
MedEd Analytics
|
Pharma Medical Education
|
Event ROI
|
W_MED_ED_FW_SYND_DATA_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Activity
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Sales
|
W_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Customer
|
W_SYND_DATA_FW_SYND_MKT_F
|
RxPrf
|
Contact ID
|
TOTAL
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Sales Rep Analytics
|
Objective
|
W_OBJECTIVE_F
|
RxPrf (NRx, TRx Objectives)SlsIndZip (Indirect Sales Objectives)
|
Contact IDZip ID
|
TOTAL
|
Pharma Executive Analytics
|
Sales Executive Analytics
|
Pharma Sales Executive Analytics
|
Sales Overview Page
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_FW_OBJECTIVE_FW_MED_ED_F
|
RxPrfSlsIndZip
|
Contact IDZip ID
|
|
Pharma Executive Analytics
|
Sales Executive Analytics
|
Pharma Sales Executive Analytics
|
Sales Overview Page (Brick)
|
W_ACT_PROD_FW_SYND_DATA_FW_SYND_MKT_FW_OBJECTIVE_FW_MED_ED_F
|
RxPrfSlsIndBrk
|
Contact IDArea ID
|
|