Siebel Business Analytics Applications Installation and Administration Guide > Configuring Metadata for Analytics Applications > Analytics Metadata Requirements for Siebel Industry Applications >

Siebel CME Analytics

Siebel Communications, Media and Energy (CME) makes use of order management functionality configured for CME. For Siebel CME Analytics to fully reflect the information collected by CME order management functionality, some extensions to the Siebel CME Analytics application may be required. This topic explains these potential extensions.

Siebel Sales Orders include complex products and simple products.

Complex Products. A series of products related by a product hierarchy. The highest product in the hierarchy is the root product, and the lower level products are the child products. In complex products, revenue figures are summed and roll up to the root product using the ROLLUP_NET_PRI field. For a complex product, Siebel Business Analytics examines only the root product when computing revenue. Child products are disregarded because their revenue is already reflected in the root.

Simple Products. A root product. Siebel Business Analytics examines this root product when computing revenue, and nothing more.

Siebel Communications, Media and Energy order management functionality supports products which have recurring charges over time (for example, $20 per month for 12 months), one-time charges (for example, one-time purchase price of equipment), and usage charges (for example, 15 cents per minute).

The revenue attributed to a product with recurring charges is valued by taking the product's net price and multiplying it by the number of months that product is anticipated to be active, as represented by the Number of Revenue Occurrences field. This field, contained in Quote Item and Order Item records, is contained in the Siebel Data Warehouse by the following fields:

• W_QUOTEITEM_F.NUM_OCCURRENCE
• W_ORDERITEM_F.NUM_OCCURRENCE

In Siebel CME Analytics, revenue metrics do not automatically account for all recurring charges, and do not consider the NUM_OCCURRENCE fields. Instead, Siebel CME Analytics revenue metrics incorporate one-time charges, one-month's worth of recurring charges, and no usage charges. To incorporate the anticipated value of all recurring charges, the W_QUOTEITEM_F.NUM_OCCURRENCE and W_ORDERITEM_F.NUM_OCCURRENCE fields may need to be incorporated into revenue calculations made during the Extraction, Transformation and Load (ETL) process for order item and line item records.

Alternatively, these fields in the Siebel transactional database, representing the aggregated recurring and one-time product charges, may be used and incorporated into the ETL processes:

• S_ORDERITEM.PER_MTH_CHG_SUBTOT
• S_ORDERITEM.ONETIME_CHG_SUBTOT
• S_QUOTEITEM.PER_MTH_CHG_SUBTOT
• S_QUOTEITEM.ONETIME_CHG_SUBTOT

Each CME Order line item and Quote line item contains an Action Type of Add, Update, or Delete. Because Siebel Business Analytics only looks at root product line items, only the Action Types associated with the root product are considered during analysis. Therefore, while all line items for a complex product may collectively include a combination of various Action Types, only the Action Type for the root product are considered during analysis. This is of special importance if a filter or query criteria in analysis is based on the Action Type field, which it is for most Account Management and Revenue Management dashboard reports.

Similarly, each CME Order line item and Quote line item is associated with a product of a particular Price Type. Because Siebel Business Analytics considers root products only, only the Price Type associated with the root product is considered during analysis. Again, this is important if a filter or query criteria is based on Price Type. Such filter criteria apply to most Account Management and Revenue Management dashboard reports.

NOTE:  For more information, see release notes documentation for Siebel Communication, Media and Energy Analytics, and Siebel Interactive Selling Suite Analytics.