Siebel Analytics Server Administration Guide > Pharma Analytics Administration Reference >

Data Sets for Pharma Analytics Data

Please refer to the Pharma configuration file (Pharma.XML) for details.

Table 40.  
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
 Published: 11 March 2004