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

Configuring Product Hierarchies and Product Costs

This topic details the tasks performed by application administrators to configure product hierarchies and product costs. Oracle Pharma Sales Analytics provides a prebuilt product hierarchy that allows users to analyze and roll up call activity, medical events, sales and Rx data at the form strength, brand, submarket, and market levels. Oracle Pharma Sales Analytics also allows users to analyze sales and Rx data of competitor brands.

Table 97 shows the required relationships between each of the levels in the Product Level column.

Oracle Pharma Sales Analytics also allows users to analyze ROI of call detailing and sampling. The underlying cost information used in these ROI calculations is sourced from the product cost fields within the Siebel Pharma application.

To configure product hierarchies and product costs

1. Navigate to the Administration - Product screen, then the Products view.
2. In the Products list, create a new record, and complete the following fields.

3. Drill down on the product.
4. Click the More Info view tab.
5. In the Level field, select the correct numerical value for the level as listed in Table 97.
6. If the Product Type is Sample, then in the Sample Cost field enter the appropriate sample cost. If the Product Type is Detail, then in the Promo Cost field enter the appropriate promotional cost.
7. Repeat Step 2 through Step 6 for the remaining products in the product hierarchy.

For more information about managing products, see Managing Products for Life Sciences.