Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Importing Syndicated Data Into the Siebel Data Warehouse >

Analytics Data Loading Matrix for Syndicated Data


The Data Loading Matrix, shown in Table 25, and the Attribute by Data Source Matrix, shown in Table 26, are provided to facilitate loading sales and Rx data. The following list explains the table headings:

Table 25.  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
 

 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004