Siebel Life Sciences Guide > Configuring Data for Oracle Pharma Sales Analytics >

Transactional Data Requirements

Oracle Pharma Sales Analytics is a set of prebuilt analytical applications to support the analysis and reporting needs of sales and marketing users. The Oracle Pharma Sales Analytics applications are built on top of the Oracle Business Analytics Warehouse, which is a unified data repository for all customer-centric data to support the analytical requirements of Siebel Pharma Applications.

The Oracle Business Analytics Warehouse contains a number of Business Analytics Warehouse tables that are specific to Oracle Pharma Sales Analytics. These tables support the analysis of data stored in the Siebel Pharma application, as well as data from external syndicated data sources. The Oracle Business Analytics Warehouse contains a set of ETL (extract-transform-load) processes that take data from the Siebel Business Applications transactional data (OLTP) and loads this data into the Oracle Business Analytics Warehouse tables.

To implement Oracle Pharma Sales Analytics successfully you must understand the key entities and relationships in Oracle's Siebel Pharma application that Oracle Pharma Sales Analytics uses.

The Pharma Sales Analytics ETL processes impose some requirements on how the data must be configured and populated in the Siebel Pharma application in order to minimize the need for configuring data entities, relationships, and hierarchies within the Oracle Pharma Sales Analytics application.

The Oracle Pharma Sales Analytics ETL rules are configured to source data from specific, standard Siebel Pharma transactional database tables and columns. These database tables and columns are mapped to standard Siebel Pharma business components, screens and views. The Pharma Sales Analytics ETL rules require that data is populated in a standard way to make sure that data is successfully loaded into the Oracle Business Analytics Warehouse tables without the need for additional configuration.

The following key entities must be configured and populated correctly in the Siebel Pharma transactional system:

• Product hierarchies and product costs
• Product catalog and category hierarchies
• Sales objectives