Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > The Siebel ePharma 6.3 to 7.5 Analytics Bridge >

Siebel ePharma 6.3 To 7.5 Star Matrix

---

Table 14 shows the Fact and Dimension tables that are populated in the Siebel Data Warehouse by the Analytics Bridge.

Table 14.  Siebel ePharma 6.3 to 7.5 OLAP Star Matrix

Stars

Fact Tables

Dimension Tables

W_DAY_D

W_PERSON_D

W_ORG_D

W_GEO_D

W_PRODUCT_D

W_POSTN_CON_D

W_INS_PLAN_D

W_OBJECTIVE_D

W_LOV_D

W_MED_EVT_D

W_MED_PLAN_D

W_PLAN_PROMO_D

W_PRODCAT_DH

W_AREA_D

W_PROD_RANK_D

W_ALIGNMT_DH

W_POSITION_D

Activity Product Star

W_ACT_PROD_F

X

X

X

X

X

X

X

X

X

X

X

X

Medical Education Star

W_MED_ED_F

X

X

X

X

X

X

X

X

X

X

X

X

X

Objective Star

W_OBJECTIVE_F

X

X

X

X

X

X

X

X

X

X

X

X

X

Profile Rank Star

W_PER_RANK_F

X

X

X

X

X

X

X

Syndicated Data Star

W_SYND_DATA_F

X

X

X

X

X

X

X

X

X

X

X

Bookshelf Home | Contents | Index | Search | PDF