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

Data Types Supported in the Oracle Business Analytics Warehouse


The Oracle Business Analytics Warehouse supports multiple data types defined by data source type and periodicity, as described in Table 128.

Table 128. Data Types Supported in Oracle Business Analytics Warehouse
Data Type
Description

Prescription data by contact

Monthly NRx and TRx data for client defined markets that include competitor products data by physician.

Indirect sales brick level

Monthly wholesaler sales and unit values data for client defined markets that include competitor products aggregated by brick.

Indirect sales account level

Monthly wholesaler sales and unit values for company products by pharmacy.

Indirect sales zip level

Monthly wholesaler sales and unit values for client defined markets that include competitor products aggregated by postal code.

Direct sales account level

Monthly direct factory sales data and unit values to wholesalers for company's products by wholesaler.

Direct sales brick level

Monthly direct factory sales data and unit values to wholesalers for company's products by brick.

Direct sales zip level

Monthly direct factory sales data and unit values to wholesalers for company's products by postal code.

Weekly prescription data

Weekly NRx and TRx data for client defined markets that include competitor products by physician.

Plan level prescription data

Monthly prescription data by managed care plan for client defined markets that includes competitor products.

Sales market

Incentives. Monthly incentive compensation data sourced from internal incentive compensation systems and loaded as a new data type in the Oracle Business Analytics Warehouse.

Sales market

Modified. Monthly incentive compensation data sourced from internal incentive compensation systems and loaded as a new data type in the Oracle Business Analytics Warehouse.

Physician plan level Rx data

Monthly prescription data for physicians associated with a managed care plan.

Prescription data by zip code

Monthly prescription data for client defined markets that includes competitor products aggregated by postal code.

Prescription data by brick

Monthly prescription data for client defined markets that include competitor products aggregated by brick.

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.