Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Conformed Dimensions >

Defining Services at the Package or Component Level

The Service Provisions dimension, IA_SRVC_PRVSNS, stores information about service or account packages, as well as the components that comprise these packages. When the Siebel Customer-Centric Enterprise Warehouse reports your product or service count, by default, they report it at the lower level of granularity—the individual service level. Therefore, if you have two service packages, Package1 and Package2, each consisting of ten components, your product count is twenty (at the component level), rather than only two (at the package level). You can change this logic to the higher level of granularity—the service package level.

To configure the granularity of the your services definition, use the Package Product ID instead of the Component Product ID to populate the Product ID column of your Service Provisions dimension.

To define the granularity of the Service Provisions dimension

1. Configure the contents of the file_srvc_prvsns.csv flat file that is used in the M_F_SRVC_PRVSNS_EXTRACT mapping.

   The M_F_SRVC_PRVSNS_EXTRACT mapping is found in the Configuration for Universal Source folder in PowerCenter Designer.

2. If you want the Service Provisions dimension to be configured at the package level of granularity, use the value of the PACKAGE_PROD_ID to populate the PRODUCT_ID column.