Siebel Analytics Installation and Configuration Guide > Siebel Industry Applications Analytics Metadata > Metadata Requirements for Siebel Life Sciences Analytics Applications >

Configuring Dimensions Specific to Life Sciences Subject Areas

This section discusses the subject areas used by Pharma Analytics.

Pharma Sales Effectiveness

This subject area is focused on syndicated data analytics.

The specific configuration required for the S_SYND_DATA table depends on your data types, and the Analytics application and reports that you have licensed. The Data Loading Matrix table in Siebel Data Warehouse Installation and Administration Guide is the basis of prebuilt reports. The syndicated data loading matrix populates both base and derived metrics used in pharmaceutical sales analytics.

Product Categories

Siebel Pharma Analytics supports custom and prebuilt product category trees to allow rollup of syndicated data by alternative hierarchies. To populate a custom category, first create a Catalog in Catalogue Administration, and create categories and subcategories as part of the catalogue. Table 37 lists the categories that need to have the Usage Type field populated in the Catalog Admin Category Detail Applet.

Table 37.  Hierarchy Categories to be Populated in Pharma Analytics
Usage Type Code
Hierarchy Category
Anatomical Therapeutic Class
Application Form
Product application
User-defined codes and custom hierarchies

Pharma Promotional Effectiveness

This subject area combines call activity data with syndicated data to analyze effectiveness of call activity.

Call Activity analysis records are derived from submitted call activity records stored in S_EVT_ACT in the Siebel transactional database, where they are stamped with the ZIP Code or brick where the activity took place—that is, the Contact primary address's ZIP code/brick or the Account ZIP Code/brick. Allocation of these ZIP Code/brick records should be done by Assignment Manager rules to make sure that they are correctly allocated. Assignment Manager rules must match the Contact or Account primary address ZIP Codes or bricks. Otherwise, data integrity is not maintained.

Only calls that have status Submitted on the Pharma Professional Call Form Applet are brought over from the Siebel transactional database to the Siebel Data Warehouse.

Pharma Medical Education Effectiveness

This subject area combines measures from MedEd and Syndicated Data to measure effectiveness of medical education events used on medical education analytics.

Only MedEd events with the status Completed on the Pharma ME Event List Applet are extracted from Siebel transactional database to populate the Siebel Data Warehouse.

MedEd Event costs are based on costs of activities in the Pharma ME Event Activity List Applet. Costs are allocated based on MedEd Team cost allocation, and promoted products Cost Allocation on the MedEd event.

Costs are solely based on physician invitees with the status Attended in the Pharma ME Event Professional Invitee Session List Applet.

Control groups are based on physicians who have the same contact ranking as attendee physicians within the same sales territory at the time of the event, but who did not attend the event.

Pharma Customer Demographics

This subject area supplies denormalized tables for contact and account profiling. It is typically loaded from external sources and contains the master contact list. Prebuilt ETL extracts the contact list from Siebel.

Pharma Objectives Achievement

This subject is used to measure achievement and results for pharma call activity and Rx/sales targets. It is based on Pharma Objectives.

Objectives need to have a Unit populated in Retail Objective Form Applet. Actual target numbers per contact and account need to be populated in the Pharma Campaign Target Account List Applet or the Pharma Campaign Target Professional List Toggle Applet.

 Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A 
 Published: 11 March 2004