This appendix provides an overview and examples of Oracle Communications Data Model business use case scenarios.
This appendix includes the following sections:
The sample business use case for Oracle Communications Data Model includes the following:
A Multi-play telecom Carrier, including:
The SuperTelco Communications organization comprises two business units:
Broadband: The broadband unit, named SuperData, is an acquired company; this organization has a different hierarchy. The broadband unit includes both video and broadband data services.
Their Product Offering includes (among others):
Broadband Services for B2C and B2B
Video on Demand
Mobile (for example 3G) services
Their prospects and then customers will be Tom Daniels and his family (Mary Daniels and their children) and some companies.
This business use case, describes how to build up the organization SuperTelco as a PARTY in the data model. In particular, the two main business units (Mobile with SuperTelco and Broadband with SuperData) will be modeled into Oracle Communications Data Model corresponding Subject Area, shown in Figure C-1.
Figure C-1 Organization Business Units in Sample Use Case
Oracle Communications Data Model should capture the following administrative functions for the Mobile and Broadband business units:
HQ, HQ Mobile/HQ Broadband, Customer Care, Sales Marketing
Related geographic information (for state, county, City, Dealers/Shops and Web Service)
The people involved, in particular all employees (who is a manager from whom in which organization)
To work with the sample use case you build up the organization SuperTelco as a PARTY in the Oracle Communications Data Model:
Using a standard pre-defined hierarchy
Using a flexible hierarchy
ORGANIZATION BUSINESS UNIT: this is the smallest "independent" unit of an organization which can contain several sales channels and/or customer contact possibilities, such as call centers (stored in CALL CENTER), a website (stored in "Service Web Site"), and shops (in RETAIL STORE). The business unit is of a specified type, as detailed in the ORGANIZATION BUSINESS UNIT TYPE. All the information relative to this business unit, such as the business address or the company registry number is stored in the ORGANIZATION BUSINESS UNIT. It is a sub-type of PARTY.
This business unit is geographically (and somehow "administratively") situated in a district, region, and area. The geographic entity is stored as specified in the entities: ORGANIZATION DISTRICT, ORGANIZATION REGION, and ORGANIZATION AREA.
To understand the notion of "organizational chain" above the organization area, consider for example that the SuperTelco stores are located inside a given supermarket chain. SuperTelco may have a part of the organization related to this chain of supermarket, which would then be stored in the ORGANIZATION CHAIN table.
The ORGANIZATION CHAIN belongs to a company; in this example, the company SuperTelco is stored in the ORGANIZATION COMPANY table, itself member of a group whose information is stored in ORGANIZATION CORPORATE.
When you use a "banner" for a given sales channel, store the banner in the ORGANIZATION BANNER table, linking the business unit to the corporate level.
A Business Unit is an ORGANIZATION BUSINESS ENTITY: This entity is a reference that allows a flexible definition for the hierarchy level and the attributes you choose per level (see next line).
The ORGANIZATION LEVEL defines the levels of the flexible hierarchy (whose level attributes and possible values as stored in the entities ORGANIZATION LEVEL ATTRIBUTES and ORGANIZATION LEVEL ATTRIBUTE VALUE).
The hierarchy between levels is defined in ORGANIZATION HIERARCHY LEVEL, which belongs to a given ORGANIZATION HIERARCHY. Thus, for a given organization several hierarchies can be defined (administrative, geographic, and so on.
A hierarchy has a version, defined in ORGANIZATION HIERARCHY VERSION. This allows you to change the hierarchy, depending on the historical development of the organization.
A Business entity is assigned to a given level through the ORGANIZATION HIERARCHY LEVEL ASSIGNMENT table.
Of these two choices: simple hierarchy and flexible hierarchy, the SuperTelco sample use case uses the flexible hierarchy. This is the preferred hierarchy for this sample because the historic growth of SuperTelco specifies that the hierarchy changes over time. To deal with the geographical organization of the SuperTelco stores dispatched in the country however, the standard hierarchy could be used. Such a hierarchy would support a detailed analysis of the local and geographical differences for the impact of a national marketing campaign.
For the sample use case, let us assume that a father (Tom Daniels) goes to a SuperTelco dealer and asks for a Family Plan offering with the following features:
One main mobile phone postpaid (his)
One secondary mobile phone postpaid (wife)
Two additional mobile phones prepaid (children)
One Friends and Family option that allows calls between these users to be free of charge
The father is moving his service from a competitor and wants to keep his current mobile number (number portability required). This example provides details on the information stored in the various agreement, account, customer, and party entities. The actions covered in this area include the following, as shown in Figure C-2.
Party Interaction (Customer - Dealer)
Contract setup (Customer, Account, Billing, and others)
Phone number and equipment associations
Figure C-2 Customer Acquisition: Family Plan Model
New Customer with Family Plan Data:
After Tom purchased the family plan, made the payment, and the customer order was generated, the provisioning engine takes over.
The service implementation is stored with Oracle Communications Data Model as shown in Figure C-3.
Figure C-3 Service Implementation
For the service implementation, the provisioning engine does the following:
After Tom Daniels has got his phone, and after the phones for his wife and children are activated, Tom Daniels regularly calls his family and friends. Tom Daniels uses the phone primarily to make voice calls and to send SMS messages; he rarely uses the data or MMS services.
The customer call information is stored with Oracle Communications Data Model as shown in Figure C-4.
Figure C-4 Customer Call Data Model
The call data can be saved in Oracle Communications Data Model:
Note: Depending on where the source Call Detail Record (CDR) is taken, the CDR may contain a charge for the following:
In case of Roaming, the (base) charge is set by the other operator (raw or mediated CDRs level), while the carrier itself usually adds a surcharge (fixed percentage or fixed price per minute - normally higher than the roaming charge).
In case of Value Added Service, the charge is set by the vendor (raw or mediated CDRs).
In case the CDR source is the billing system, after rating has taken place (rated CDRs). This is also true for CDRs from the IN Platform which is doing the rating (typically for Prepaid).
Depending on the type of analysis, it is usually recommended for revenue assurance to check at least both mediated (before the billing system) and rated or billed CDRs (from the billing). The raw CDRs, direct input from the network, are usually more complex to deal with (binary type of data, a potential factor 100 in number of CDRs and additional signaling information) but are very interesting from a network operation and revenue assurance point of view.
At the end of each bill cycle period (usually a specific day of the month for a given bill cycle), SuperTelco runs the billing process over the calling records for the customer and generates an invoice. In our example, Tom Daniels receives an invoice of $100 for all the phone numbers (Postpaid only normally, but one could think that he could also have agreed to pay by default every month some Recharges for his children "Prepaid" phones). Tom Daniels has to pay SuperTelco within a month or the service could be suspended.
Oracle Communications Data Model stores the customer billing, invoice, and payment information as shown in Figure C-5.
Figure C-5 Billing and Payment Data Model (simplified and missing some entities)
Billing Data in Oracle Communications Data Model:
Note: for the revenue assurance sub-area and its corresponding reports, it is important to store the itemized bill in Oracle Communications Data Model. The usage items (detailed call list) can then be compared, one by one, with the rated CDRs and using this method you can find the difference between rated and billed CDRs.
The section, Sample Use Case 7: Targeted Promotion for Video-on-Demand Services" shows a campaign set-up with the prospect choice. For this campaign, a measure of the campaign success could be obtained by analyzing the number of subscribers who contacted the call center and requested a product change based on the promotion, as a factor of time, in hours or days, between sending the promotion and customer call-back.
SuperTelco launches a campaign to promote a package with converged broadband and mobile services. Tom Daniels sees the promotion message, delivered through an SMS campaign, and decides to take advantage of the promotion. He calls the call center and asks to change his product package to obtain the new converged family plan that includes broadband services. Later, using the SuperTelco Web Self-Service Interface he changes his billing address.
The section, Sample Use Case 7: Targeted Promotion for Video-on-Demand Services shows a campaign set-up with the prospect choice. For this campaign, a measure of the campaign success could be obtained by analyzing the number of subscribers who contacted the call center and requested a product change based on the promotion, as a factor of time, in hours or days, between sending the promotion and customer call-back.
SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure C-6 and as outlined in the corresponding steps.
Figure C-6 Changing Plan and Billing Address
The call center agent, stored in CALL CENTER AGENT, as well as the team and department, in CALL CENTER table, are uniquely identified in Oracle Communications Data Model. The call center agent may be an employee (stored then in EMPLOYEE) of SuperTelco or an employee of a partner company that runs the call center for SuperTelco. For this example the CALL CENTER AGENTis a subtype of EMPLOYEE. All INTERACTION CHANNELs need to be configured, such as the CALL CENTER and any Web or Online business system, or a counter (in a shop), to make sure that one can trace the interaction with the customer at any time.
A thread will be defined by the first interaction of the chain in EVENT PARTY INTERACTION to store the reason for the customer call. A thread groups all interactions having to do with the same list of requests, inquiries and issues the customer deals with. This information is aggregated in the CALL CENTER CASE MONTH AGGR for further analysis.
The first event is a cancellation for the existing PRODUCT SUBSCRIPTION ("PKG_Mobile_300"). The
effective_to_date attribute changes to the current date.
The second event for the PRODUCT SUBSCRIPTION is a new product subscription for the converged package (as described in "Sample Use Case 1: Setting Up the Business Unit Organization").
The third event involves creating the link between the two subscriptions and uses the table PRODUCT SUBSCRIPTION ASSIGNMENT to store their relationship.
The fourth would require a (Product) Subscription Change Event EVENT SUBSCRIPTION CHANGE to keep track of the migration. Note: If this action is omitted, it will not appear in the data marts associated with migration.
If as part of the commercial process for this offering defined by the Service Provider the AGREEMENT requires changes, then do the following:
Close the old agreement with a "cancellation reason" specified (find the cancellation reason in the lookup table AGREEMENT STATUS REASON).
Create a new agreement with the corresponding AGREEMENT TERM supplied.
If the AGREEMENT does not need to be replaced and the new product uses the same agreement, then one case either:
a) Close the Agreement Item with the old PRODUCT SUBSCRIPTION.
b) Create a new Agreement Item with the new PRODUCT SUBSCRIPTION.
c) You may also change the product assignment for the existing agreement in the table AGREEMENT PRODUCT SPECIFICATION ASSIGNMENT with a specific assignment code.
A product change impacts several other tables on the next automatic data movement (and their corresponding reports).
The CANNIBALIZATION DETAIL DAY DRVD table which captures the individual record related to the tariff and package change. This table fills the Cross and Up-sell mining model.
The customer Lifetime Value associated table is also updated. The agreement or product has changed and this change impacts the likelihood to churn.
The Revenue Forecast OLAP cube also changes for this customer.
Note: the Oracle Communications Data Model does not rate, from the monetary perspective, any kind of event (no "shadow billing" as such), although one could customize Oracle Communications Data Model for this purpose.
The customer table, using the entity CUSTOMER and the attribute Billing Address Location Code, stores the customer's billing address. This attribute links to the actual address entity ADDRESS LOCATION. The billing address is one type with a value from the ADDRESS TYPE for the new address. For example, when Tom Daniels changes the billing address, using the SuperTelco Web Self-Service Interface, the change is captured by the ETLs (from the CRM or from the web interface) and is stored in Oracle Communications Data Model as a the non-network event (from the source Web Interface, the Web based customer self-care system, typically where you login to obtain your offer).
When Tom Daniels has given the new address, the two addresses are linked with the ADDRESS RELATED entity. With more than one address, changes are required in the ADDRESS RELATED and CUSTOMER entities:
The current billing address in ADDRESS RELATED has the value "Old Billing Address" as reason.
The new billing address reason is assigned: if this is a new home address the new address exists in Oracle Communications Data Model and becomes the new billing address.
In the CUSTOMER table, the new billing address location is overwritten and the billing address effective date is updated to the correct date.
The change of address may impact the customer profiling mining model.
Additionally, the PARTY STATUS HISTORY could be updated (depending on what information the Service Provider requires).
SuperTelco analyzes the current customer base to identify the customers who are most likely to purchase the Video-On-Demand service. The Marketing department would also like to increase the number of customers in the loyalty program (this can help limit churn). Using the Data Mining tool for target promotion, the business analyst in the SuperTelco Marketing generates a list of customers that are likely to be interested in this service and that are not currently members of a loyalty program ("supervised" mining).
A sample of the target list of customers is selected to test the promotion. Customer Tom Daniels is among the target list of customers. SuperTelco sends the target customers an email. In order to collect customer feedback, SuperTelco decides that the test promotion customers must contact the call center to get the Video-On-Demand service and one free DVD.
SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure C-6 and as outlined in the corresponding steps.
Figure C-7 Targeted Promotion Data Model
Tom Daniels decides to buy the service and calls the CALL CENTER to get the new promotion, including:
A month of Video-On-Demand service for ten dollars.
Five films per month free and one free DVD.
During the call he is offered the option to be added to the loyalty program with 500 Loyalty bonus points.
The section, "Sample Use Case 6: Changing Plan and Billing Address" covers the impact of a product change.
The business analyst prepares the campaign, selects the prospects, and measures the campaign success as follow:
The marketing manager determines the number of customers that are members of the loyalty program. Membership in the loyalty program seems to be a factor in reducing churn and increasing SuperTelco's knowledge of a customer's preferences. To increase the number of customers in the loyalty program the marketing manager decides to contact existing customers to proposing a new offering, the Video-On-Demand product, and bind the offering to the loyalty program membership. The loyalty program membership is proposed whether the customer takes advantages of the Video-On-Demand promotion or not. Thus, the promotion includes two promotions:
Service Offering: Video-On-Demand
Loyalty Program Membership
The product setting for Video-On-Demand is specified in the PRODUCT SPECIFICATION and PRODUCT OFFERING tables. The purpose and summary information for each promotion is specified in the PROMOTION table. Some PROMOTIONs may serve a single strategic purpose (the CAMPAIGN tracks the promotion purpose).
The business analyst for this campaign has the following requirements:
Prospects for Video-On-Demand should have an active broadband service.
Prospects for the loyalty program should not yet be a member of the loyalty program.
Prospects should only be individuals.
Prospects should not be in a campaign or have recently, within the last three months, been contacted for a promotional offering.
Prospect revenue should be at least in the middle range.
Prospect payment should be on-time, debt aging at zero or near zero, and the prospect should have had no service suspension for bad payments.
Before proposing the promotion on a large scale the business analyst should select a list of two hundred sample customers to test the campaign.
Because of the information received the business analyst uses the "supervised" method for targeted promotion data mining, using the specified criteria to find the prospect list.
The business analyst determines that there are two possibilities to generate the prospect list contacts:
The operator can buy a CONTACT LIST from an external marketing data provider. The SOURCE SYSTEM contains possible sources for this type of data. The marketing department can also design criteria based on which customers to select from a CONTACT LIST. The customer information may not be in the operator's customer database yet. In this case the customer information is recorded in PARTY and PARTY CONTACT LIST PARTICIPATION that associate the PARTY and a CONTACT LIST. The PROMOTION CONTACT LIST UTILIZATION records which promotion utilizes which CONTACT LIST.
The operator can run data mining, provided with Oracle Communications Data Model including the "Targeted Product Promotion", or "Customer Segmentation". This corresponds to a Mining result table whose name is "DWD_CUST_PROD_AFFLTN". The output from the mining model CUSTOMER SEGMENTATION MODEL is specified in the entity CUSTOMER SEGMENT.
For more information, see Oracle Communications Data Model Data Mining Models and "Model 4: Targeted Promotion".
For the sample use case the customer Tom Daniels is part of the two hundred customer test sample. He is tagged as a prospect for this campaign and will appear in the table PROSPECT. Tom Daniels can be a prospect of only one campaign at a time. This is strictly necessary to correctly measure the campaign response. Because Tom Daniels is an individual, the table PROSPECT INDIVIDUAL is filled; in addition, some data may be collected during the promotion customer interaction.
Following Tom Daniels's interaction with the CALL CENTER, as specified in the PARTY INTERACTION THREAD, the tables INITIATIVE RESULT TYPE, PARTY PROMOTION RESPONSE, and PROSPECT, field
Prospect Result Code, are updated:
Tom Daniels bought the service as specified in the promotion and the video chosen by Tom Daniels is recorded for further analysis (for billing and because the interest is saved information on "Tom Daniels's interest" and on most successful "Videos" type and name).
Tom Daniels accepts membership in the loyalty program, stored in the LOYALTY PROGRAM entity, thus increasing the number of loyalty program members and the knowledge of Tom Daniels's interests.
Each response from a targeted customer is recorded in PARTY PROMOTION RESPONSE. A positive response is stored as part of the mining result to the campaign, thus providing a better score to individual customers in a similar segment as Tom Daniels. The scoring table is reused to calculate the likelihood of a positive answer to the campaign when the campaign is broadened beyond the test to other customers.
Note: A customer email triggered this initiative and the initiative was completed by the call center. Thus, Tom Daniels's CALL CENTER call was triggered by the email so the medium of this targeted promotion is email while the sales channel is the CALL CENTER.
As a consequence of the new loyalty program membership and the associated 500 bonus points, a "CRM" event of type Loyalty is created and stored in the LOYALTY MEMBERSHIP ENROLL table. A new MEMBERSHIP ACCOUNT is created. A membership account is an account of type Loyalty. It is specifically tracked separately and should never be part of the standard ACCOUNT BALANCE. The 500 Bonus point shall also appear in the EVENT LOYALTY PROGRAM table and also in ACCRUAL EVENT, in both cases associated with Tom's membership account. Tom Daniels also appears in the MEMBERSHIP ACCOUNT BALANCE HISTORY table (LOYALTY MEMBER POINT DAY DRVD and LOYALTY PROGRAM MO AGGR) coming from the previously defined CALL CENTER entity. The PARTY STATUS HISTORY is changed and some fields of CUSTOMER are updated (for example,
Initiative Number and
Note: Earning Loyalty point events (“accrual" events) are expected to come from a Billing System (or equivalent, as long as the loyalty balance is tracked), whatever their origin (purchase, retail transaction, payment, usage and so on).
After a period as a customer, Tom Daniels's agreement and plan ends. Before the agreement ends SuperTelco notices that he is likely to churn, according to the socio-demographic data, the subscriptions he has, the usage and revenue pattern (based on comparisons with the customer segment).
The call center proposes that this customer continue with a new offering:
Video-On-Demand and Phone
The new generation phone as equipment
A special 12% Discount for 12 months (12 month sign up)
SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure C-8 and as outlined in the corresponding steps.
Figure C-8 Retention of Terminating Contract Model
The terminating agreement and call center retention involves the following steps:
Do nothing: In this case the agreement renews itself automatically when it is not actively canceled (assume that the customer will not churn). This is typically the case for a "sleeping" customer" that does not take the latest cheaper offering.
Actively contact the customer: In this case, contact the customer before the customer is sent an end agreement term letter (do this if it appears that the probability of customer churn is high and this customer is worth the investment). This action is particularly true for short-term churn-conditions. For example, when a communication is indicated up to one month before the end of the agreement where the customer may get an offer from a competitor. If the agreement ended automatically an action of the Service Provider is required for a renewal.
Renew the agreement with no changes: this is possible but usually after several years this option in not attractive, due to competition.
Proposing a new offering.
Renewing the agreement with new hardware and a discount if the customer engages for more than twelve months.
For the sample use case with Tom Daniels, agreement renewal with new hardware might be a good offering when the handsets for all the family members are old, over two years old, as specified in the information from HANDSET INSTANCE (subtype of EQUIPMENT INSTANCE). By offering a agreement renewal with new hardware, you could allow the customer to use-up some loyalty points he has earned (by selecting different equipment). Additionally, binding the customer to twelve more months according to his ARPU Band could be worth a 12% discount.
When you offer a new handset, this could provide new capabilities. For example, applications to download that could generate additional revenue for SuperTelco. This expectation can be reinforced due to the age of the children.
This use case expands the details for customer information, as described in the section, "Sample Use Case 2: Acquiring a New Customer (with Family Plan)". This use case provides details for how sales information from a dealer is stored. Recall that in Use Case 2, the customer Tom Daniels asked for a family plan offering with the following features:
Four numbers: two Postpaid mobile and two PrePaid
One Friends and Family option
During the interaction the customer calls the call center to get the phone and broadband offering and the Video On Demand Service. Assuming that SuperTelco rewards dealers depending on customer revenue, the number of services and the customer loyalty, one shall consider the commissions and costs spending for dealers and for a given campaign:
Actions for the dealer and employee sales commission use case include the following:
Party interaction, customer, and dealer
Impact on commission and cost
Loyalty campaign cost
SuperTelco uses Oracle Communications Data Model to store this dealer and customer interaction as shown in Figure C-9 and as outlined in the corresponding steps.
Figure C-9 Dealer and Employee Sales Commission Data Model
The information for the customer and account setup is described in "Sample Use Case 2: Acquiring a New Customer (with Family Plan)".
A SALES CHANNEL and a channel to identify the dealer. The SALES CHANNEL is an abstracted umbrella that unifies both an external DEALER and the internal sales agents as an EMPLOYEE. The JOB ROLE for each employee is in EMPLOYEE JOB ROLE ASSIGNMENT. For example, the job role for a Sales Employee should be "Sales Agent".
An organization structure or a relationship to individuals (ORGANIZATION BUSINESS UNIT).
A discount group in the DISCOUNT GROUP entity within the DEALER DISCOUNT GROUP ASSIGNMENT table. All the discounts the provider allows for a dealer are defined in DEALER DISCOUNT GROUP ASSIGNMENT (as a group). This entity feeds the dealer cost and customer cost table.
As an employee in sales, John Dealer is associated with a sales commission plan code from the SALES COMMISSION PLAN table (using JOB ROLE). The details of the plan SALES COMMISSION PLAN DETAIL or the type of commission COMMISSION TYPE are stored in associated entities so that the full commissions and rewards for the item, equipment, services, and product market plan sold are set-up. The EMPLOYEE JOB ROLE ASSIGNMENT.
The Party interaction between John Dealer and Tom Daniels generates a new CUSTOMER ORDER. The customer order is generated in the BOSS/OSS system and loaded into Oracle Communications Data Model. For each customer order the SALES COMMISSION DETAIL is loaded to track how much commission should be granted to the DEALER in this sales transaction. Once the CUSTOMER ORDER is fulfilled in the provisioning system, an agreement is settled with four activations, four handsets (ITEM SPECIFICATIONs) and probably five products (one per mobile and the shared Friends and Family offering (even if there is only one agreement). This has the following consequences in Oracle Communications Data Model:
John Dealer generated revenue increases and the number of customer and subscriptions: the revenue is compared to the quota the dealer had at the beginning of the month on each of these items, revenue, number of customers, and subscriptions, for the calculation of the dealer's commission and potential bonus and for the final dealer report.
John Dealer "costs" increase correspondingly, as he wins a percentage of the generated revenue.
The number of handsets available at John's shop is reduced by four (two Postpaid and two Prepaid). The out-of-stock forecast mining model is automatically fed and correspondingly updated.
The commission associated with the handsets through the commission indicator attribute ("Commission Ind") will trigger the calculation of an extra commission for the items sold, aggregated on the monthly basis (using COMMISSION DRVD and SALES CAMPAIGN SUMMARY MONTH AGGR).
Assuming SuperTelco rewards on the effective revenue generated by the customer, depending on the ARPU band of the account associated with the customer, the special bonus for John Dealer is updated with Tom Daniel's profile and added as a supplementary cost for the dealer and for the customer. Often at this stage a fraud detection mechanism is applied to limit dealer or customer fraud.
As Tom Daniels changes the package to the convergent offering, due to a campaign, SuperTelco does not reward John Dealer. The campaign cost may be increased by the cost of creating and sending the SMS, in general, and by the cost of the call center agent interaction. The customer cost could also only be increased by the cost of the call center agent interaction (assuming the SMS sent to Tom Daniels is not considered). The fact that Tom Daniels changes his package will probably impact the Band ARPU that could also change the bonus for John Dealer.
As Tom Daniels's agreement comes to an end SuperTelco may decide to reward only the call center as a successful clawback action rather than granting further John Dealer with a bonus for the loyalty of the customer, as the later was not involved at all in the action. The customer cost for Tom Daniels would still increase. The employee and call center cost would also correspondingly increase (here, probably only the employee cost, as the call center cost must be considered to be the sum of the labor, employee, costs and other costs). For example the rent for the building or of the call center service is typically associated with the location of the call center only. Note that its total margin, due to the revenue generation through the agreement renewal, is increasing even if the relative margin will probably decrease over the month.
At each end of month when the sales agent commissions are paid by payroll, the information in SALES COMMISSION PAYROLL is populated.
Sometimes certain dealers may commit fraud when bringing in new customers. For example, a dealer may have friends sign agreements to win a gift but then terminate the agreement. The new customers brought in by the fraudulent dealer may be identified by SUBSCRIPTION STATISTIC MONTH AGGR. In this table some statistical functions are applied to find a high churn rate by a possibly cheating DEALER, compared to all other dealers.
The Network Monitoring System detects a failure at a switch. SuperTelco wants to understand how many customers are affected by the incident. The Network Monitoring System queries the Network Inventory to get the resource ID of the faulty element. The Network Monitoring System then generates a "network failure" event and Oracle Communications Data Model captures this event.
SuperTelco uses Oracle Communications Data Model to handle a network fault, as shown in Figure C-10 and as outlined in the corresponding steps.
SuperTelco includes the full network structure as specified in Oracle Communications Data Model and both the network operating and the network inventory applications provide information to Oracle Communications Data Model once a day.
This model has been strongly extended to better fit the TeleManagement Forum Shared Information Model (TMF SID) ResourceAlarm and ServiceProblem Aggregate Business Entities.
Figure C-10 Handling a Network Fault Data Model
Consider the case and steps required to handle a network fault:
The first questions for the manager after identifying the issue are:
Where is the cell located?
Whose qualified team is in charge now?
Which services are impacted?
Which customers may be impacted?
What is the average revenue impact if nothing is done?
"Where is my network element ID xxx?"
To answer the question:
"Who is in charge according to the maintenance plan?"
Oracle Communications Data Model can supply this information with a customization of the model (this information is not available out-of-the-box). If the network fault happens to multiple RESOURCEs, all the faulted network elements are tracked in RESOURCE FAULT ASSIGNMENT. We assume that corresponding RESOURCE ALARMs are triggered.
Circuit Component Codeattribute that allows you to use the table CIRCUIT COMPONENT to get the NETWORK TOUCHPOINT concerned, the CELL SITE being a sub-table of NETWORK TOUCHPOINT. Consequently, a simple query on all subscriptions whose circuit component is tied to the cell ID that failed provides a list all the customer information associated with the given cell.
The network cell ID (near real-time).
The abnormally limited geographic distribution of origin of some complaints (most probably the next two days).
The abnormally increase of churn in a limited region (a month later).
The CFO requests that the SuperTelco IT manager (Susan) has to implement all the billing related reports of Oracle Communications Data Model
For simplification, assume that:
The CFO wants to get the value as quickly as possible, so that Susan is not supposed to customize anything unless strictly necessary.
SuperTelco uses Oracle Business Intelligence Suite Enterprise Edition as the reporting tool.
Oracle Communications Data Model is installed but all tables are completely empty.
Despite the fact that some DWHs exist, on customers and products, Susan goes forward as for a "greenfield" implementation. But she will reuse part of the work that was done before, either directly from the DWH tables, used as a source to Oracle Communications Data Model or using the ETLs to directly feed Oracle Communications Data Model tables.
In a second phase, the CFO requests a special report to take the customers that are diplomats and hence do not pay any VAT. A special customer code must be created and the CFO wants a report only for these specially coded customers. Thus, Susan decides she needs to enhance the customer table with a column
Tax Rate Amount and introduce a new Customer Type:
Diplomat. These changes should be done in parallel in the CRM, in the Customer DWH, and in the billing system.
To implement these steps, the IT manager, Susan, does the following:
The project follows a typical DWH project plan with one important exception: because Oracle Communications Data Model is a "DWH-out-of-the-box", with an optimized design and an automatic data movement, intra-ETL provided, the main challenges for Susan are:
Limiting the Scope of the project to quickly deliver value to the CFO:
Identifying the reports associated with the chosen business area.
Identifying the OLAP cubes and Mining needed or wanted by the business.
Identifying the input tables required to fulfill the expectations.
Identifying from the source systems the data needed to fill the tables.
Identifying the gaps between the organization needs and Oracle Communications Data Model out-of-the-box delivery. In Susan's case, one could assume these are reduced to a minimum. If it has not been a "greenfield" implementation, the gap analysis between the existing reports and underlying DWH structure with Oracle Communications Data Model should also be run.
Identifying and writing down the difference in semantics between the various terms (normally, this should be quickly done after training with Oracle Communications Data Model). Mapping the source systems (in this case, only the billing and maybe the Product and Customer DWH) to Target Data Element.
Design and Development:
ETL (Billing to Oracle Communications Data Model and other DWH toOracle Communications Data Model).
Logical Data Model and Reports Design Enhancement
Training and Testing:
Scenarii creation and run
Acceptance Testing with some (trained) power-users
Initial / history data load
Within a given business area, Susan will find the reports available out-of-the-box (directly looking at the reports themselves or in the associated documentation) and discuss those the CFO wants to see absolutely.
Once with the list of reports to feed, Susan checks the documentation to find out the entities from which these reports are filled and the programs used. She first turns to the Oracle Metadata dashboard (visible in Oracle Business Intelligence Suite Enterprise Edition): for each report, she finds all the tables that need to be filled (Dashboard Report-Entities) and gets also access to the Intra-ETLs that access these tables (Dashboard Entities-Programs).
Going down to the entity description, she can decide which attributes (columns) per table she needs to fill and compare those with the data she can get out of its different sources. Note that Susan will be able to find which KPIs is associated to which column in the Excel file
Finally, it is Susan's decision to determine the source and then create the ETLs that load the corresponding information. In this case, she has two possibilities, the choice between the two being rather an architecture/process decision:
She uses the Product and Customer DWHs as the base for true and up-to-date customer and product information (product and customer "hubs" principle). If she used the standard DWH principles, those are probably in 3NF format, thus easing the mapping process to Oracle Communications Data Model base tables for customers, products and services.
She uses the ETLs that were feeding the Product and Customer DWHs and adapt them to feed Oracle Communications Data Model directly.
Important for Susan is that, as soon as some data are available in Oracle Communications Data Model, it will be automatically pushed to reporting level, in the OLAP cubes and to the various mining models (following the plan agreed at implementation time). She can therefore cross-check the data at each Oracle Communications Data Model level (reference, base, derived, aggregation,…) and compare them with previous reports she has. The difference in definitions (what is a subscriber, a customer, an offering, a service,…?) must have been run upfront to be able to compare the data and clarify any differences appearing.
On the second phase, adding a new type costs nothing but adding one line in the corresponding lookup table (CUSTOMER TYPE). The ETLs should be able to reference correctly the new customer type.
For the tax customization, Susan will check in the Oracle Metadata dashboard the list of all intra-ETLs and programs hit by a customization of the customer table: in principle, there are a lot impacted. However, with a new attribute, most of them won't need any changes; only those that need to aggregate the result of any facts according to this new column must be extended.
With this information, Susan will access and adapt the code of each intra-ETL she needs to. She will then adapt Oracle Business Intelligence Suite Enterprise Edition repository and the sample reports to present the new dimension.