Siebel Business Analytics Server Administration Guide > Pharma Mobile Analytics Administration Reference >

Data Sets for Pharma Mobile Analytics


Table 53 contains data set information for Oracle's Pharma Mobile Analytics. For more information, see the Pharma configuration file (Pharma.XML).

Table 53. Data Sets for Pharma Mobile Analytics
Data Set 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 Business Analytics Server Administration Guide