Bookshelf Home | Contents | Index | PDF     

Siebel Data Warehouse Installation and Administration Guide > Siebel Data Warehouse for Life Sciences Data Considerations > Importing Syndicated Data into Siebel Data Warehouse >

Siebel Analytics Data Loading Matrix for Syndicated Data

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

  • Screen. Name of the Siebel Analytics screen.
  • View. Name of the Siebel Analytics view.
  • Data Source. Value that determines which view displays the data stored in the record. The valid values are RXPrf, SlsIndBrk, SlsIndAct, SlsIndZip, SlsDirAct, SlsDirBrk, SlsDirZip, RXEVM, RXPT, RXSMI, RXSMM, RXXPT, RXZip, and RXBrk.
  • Mandatory Id. Value that indicates the ID field that must be non-NULL for a database record to be displayed in the corresponding view. There are four key ID fields: Account Id, Contact Id, Territory Id, and Zip Id. For each view listed in the table, one of these ID fields is required and the other three must be NULL.
  • Plan Type. Value that indicates the type of plan ID a database record must have to be displayed in the view.
Table 62.  Siebel Analytics 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