Billing Concepts

Hot Billing//Real Time Billing or Warm Billing//Near Real Time Billing
=================================================
1) Hot Billing //Real Time Billing :--> Processing CDRs within 1 minute of call completion.

2) Warm Billing//Near Real Time Billing :--> Processing CDRs within 5 minutes of call completion.

Telecom Products and offers

Products and Offers
====================
Products (Packages) and offers (promotions) can be assigned (or sold) to subscribers.
A Product is a way of charging a customer during a period and determines what the
customer gets charged at the end of a billing period.

Offers are similar to packages, except that they are valid only for a certain period
and are used to provide special services or rates to the subscriber.
A product /offer consists for following components.
a) One time charges
b) advance rentals
c) rentals
d) initial charges
e) discounts
f) services
g) variable tariffs
h) tariffs (attached with products only)
(Technical services//Profit_Cost centers also attached to offers and products)

Churn

Churn
------

Used in Telcos to describe the turnover rate in the number of
subscribers to a service or product. Churn rate indicates that
subscribers are swithcing to a different service or company,
or eliminating service altogether.Telcos need to keep current customers
happy and to reacquire previous subscribers.

Methods to elimiate customer churn.
-----------------------------------
1)Business promotions with a metric to track its success rate.
2)Loyalty programs

String manipulation using Excel Nested Functions

Convert number +91 (11) 2000-5658 to 20005658


=int(CONCATENATE(MID(B2,SEARCH("+91",B2)+9,4),MID(B2,SEARCH("-",B2)+1,4)))


Happy New Year 2010 to all Blog Readers.

How to enter a single quotation mark in Oracle SQL Output?

SELECT S.IMSI||','||CHR(39)||s.SIM||CHR(39)||','||s.STATUS FROM SRC_ESN1 S

Will create output like

404909090123,'02320E34',A

Summing of absolute values in a range using EXCEL

The sum of absolute values present in column AB1 to AB100.

At cell AB 101 enter command =sum(abs(ab1:ab100))
after entering the values type CTRL+SHIFT+ENTER at last. will execute the function as an array function and the function is changed as {=sum(abs(ab1:ab100))}

Another option to perform the same is
=sumproduct(abs(ab1:ab100))

Nested IF using EXCEL Function

=IF(D2=E2,"SAME",(IF(D2>E2,"TGT","SRC")))