Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Storing, Extracting, and Loading Additional Data > About Adding More Metrics to the Data Model >

Storing Additional Metrics in the Data Warehouse

Siebel Customer-Centric Enterprise Warehouse comes with several prepackaged metrics. Because you may want to store additional metrics to the data warehouse, this section provides instructions for storing Quantity and Amount metrics.

There are a variety of scenarios that occur when incorporating a new metric. Depending on where the data resides, you can take particular steps to incorporate the new metrics and make them available in your data warehouse and front-end schema. Generally speaking, there are three major areas where data resides—source database, staging table, and Siebel Customer-Centric Enterprise Warehouse. Figure 44 illustrates the three scenarios and the components that are affected when trying to store the new data.

Figure 44. Scenarios for Storing New Metrics

In the sections that follow, you can find procedures for storing new metrics given each of these three scenarios. Each of the steps in the procedure correspond to larger topics discussed in later sections of this chapter. The steps provide you with a high-level overview, and the larger topics provide the details.

To store additional metrics from the source system

1. Modify the existing extract mapping or create a new extract mapping to extract this new information from the source system.

   For information on modifying the existing Business Component mapplet of an extract mapping, see Process of Creating and Modifying Business Adapters. For information on creating a new extract mapping, see Creating an Extract Mapping.

   TIP:   You can perform calculations in the Business Component mapplet of the extract mapping or in the Source Adapter mapplet of the load mapping. However, it is not recommended that you perform large calculations in the extract. This protects you from interfering with your source transaction system. For these types of calculations, it is recommended that you perform them in the Source Adapter mapplet in the load mapping. One of the major reasons why Siebel Customer-Centric Enterprise Warehouse splits the extract process from the load process into two separate mappings is to minimize the amount of time tying up the source transaction system.

2. Modify the existing load mapping to take the data from the staging table and load it into the data warehouse.

   For information on modifying the existing Source Adapter mapplet of a load mapping, see Process of Creating and Modifying Business Adapters. For information on creating a new load mapping, see Creating a Load Mapping.

   TIP:   If you map the data to a staging table's extension column, you must determine the type of extension column to use. For explicit information on the type of extension column to use for attribute data, see Determining the Type of Extension Column to Use for Metrics.

3. Incorporate the new metric into your front-end schema.

NOTE:  You can also store additional metrics derived from other staging area tables or from data warehouse objects. The steps for these tasks are identical to those for storing new attributes. See the procedures in Storing Additional Attributes in the Data Warehouse.