Oracle^® Business Intelligence Applications Installation and Configuration Guide > Oracle Business Analytics Warehouse for Life Sciences Data Considerations >

Oracle Business Analytics Warehouse for Life Sciences Overview

This section describes the key features and architecture of the Oracle Business Analytics Warehouse for Life Sciences Syndicated and Call Activity data.

• ETL for direct load of syndicated data.

  Syndicated data can be directly loaded into the Oracle Business Analytics Warehouse.

  A set of prebuilt processes against common external syndicated data types allows direct load of syndicated data, such as physician plan level Rx data, physician level Rx data, indirect sales data, and weekly Rx data.

• Syndicated data staging architecture.
  • Syndicated data is loaded against a staging architecture. The staging table architecture uses a denormalized time dimension that improves data loading by a factor of how many periods are loaded.
  • A set of cross-reference files for external key matching are supplied to resolve cross referencing and loading external syndicated data where the accounts, products, territories and contacts IDs are different from the Siebel IDs.
• Syndicated data and Call Activity data single grain fact tables.
  • Single grain syndicated data star schemas for power users and operational users.
  • Operational syndicated data star schemas for operational reporting.
  • Single grain call activity fact tables - account calls, account-attendee calls, and contact calls.
• Syndicated data Moving Annual Total (MAT) metrics calculated on ETL.
  • Calculation of rolling period calculations takes advantage of the syndicated data staging architecture to populate common pharmaceutical time aggregate metrics within the Oracle Business Analytics Warehouse.
• ETL for syndicated data market aggregation.
  • ETL process to load the Syndicated Data market fact tables based on aggregations on the product-market hierarchy. Minimizes the requirement to purchase preaggregated data by market.
• Set of prebuilt aggregation tables for high performance reporting.
  • Sales level aggregation tables for product-based syndicated data facts.
  • Sales level aggregation tables for market-based syndicated data facts.
  • Call activity aggregation tables for reports requiring top-level sales level activities.
  • De-duplication tables to de-duplicate data when the same contact is assigned to multiple territories for the district level for Physician Plan Level Rx syndicated data only.
• Mini dimensions.
  • Account and contact rank mini dimensions.
  • Representative specialty LOV dimensions.
  • W_POSTN_CON used only for contact primary address.