Siebel Analytics Server Administration Guide > Pharma Field Analytics Administration Reference >

Data Sets for Pharma Field Analytics


For more details, see the Pharma configuration file (Pharma.XML).

Table 44.  
Dataset Name
Sourcing Report Name
Target Table

Day

Day Dimension

W_DAY_D

ProductRanking

Product Ranking Dimension

W_CON_RANK_D

Geography

Brick Dimension

W_AREA_D

Geography

Geography Dimension

W_GEO_D

PayorProductPosition

Payor Plan Dimension

W_INS_PLAN_D

PayorProductPosition

Product Hierarchy

W_PRODUCT_DH

PayorProductPosition

Position Hierarchy

W_POSITION_DH

CallPriorityLov

Call Priority List of Value Dimension

W_LOV_D

ProductIndicationLov

Product Indication List of Value Dimension

W_LOV_D

PeriodTypeLov

Period Type List of Value Dimension

W_LOV_D

Person

Person Dimension

W_PERSON_D

SalesObjective

Plan Promotion Dimension

W_PLAN_PROMO_D

ContactPrimaryAddress

Contact Primary Address Dimension

W_POSTN_CON_D

ContactCallActivity

Contact Call Activity Fact

W_CON_CALL_F

ContactCallActivity

Contact Call Activity Aggregate

W_CON_CALL_N_A

ContactObjective

Contact Objective Fact

W_CON_OBJ_F

SyndicateData

Indirect Sales Market Level Fact

W_MARKET_IDS_F

SyndicateData

Indirect Sales Market Level Aggregate

W_MARKET_IDS_N_A

SyndicateData

Prescription Market Level Fact

W_MARKET_RX_F

SyndicateData

Prescription Market Level Aggregate

W_MARKET_RX_N_A

SyndicateData

Direct Sales Fact

W_SYND_DS_F

SyndicateData

Direct Sales Aggregate

W_SYND_DS_N_A

SyndicateData

Indirect Sales Fact

W_SYND_IDS_F

SyndicateData

Indirect Sales Aggregate

W_SYND_IDS_N_A

SyndicateData

Prescription Sales Fact

W_SYND_RX_F

SyndicateData

Prescription Sales Aggregate

W_SYND_RX_N_A

Siebel Analytics Server Administration Guide