Creating a Queried Report
The report generation involves three required steps and several optional steps:
- Select report type
- Select record type: CDR, Summary or CPM.
- Select report category. Each report category provides answers to specific questions. The description of each report category is described in further topics.
- Optionality, you can set viewing options (depends on report category), data set filters, and name the report (the filename will use the name of the report).
- Create the report to save the dataset in a report file and view the result on the GUI. After the original report creation, you can recall the report from the saved file. (You don’t need to recreate it).
Understanding Record Type
The record type determines the data source for the queried report.
Call Detail Records (CDR)
The CDR data source includes all the detailed information about all calls.
The CDR data source provides the most reporting flexibility including reports requiring originating numbers/caller regions.
Typically, CDR records are kept for a few months.
A CDR record is generated only after the call is terminated (for any reason).
The CDRs are recoverable from your service provider generally for a 90-day period (check with your service provider for details).
Note: Certain CDR reports using originating number may yield some inaccuracies because of the call privacy feature. In this case, the last digits are replaced by 'XXXX'. In this case, report calculation cannot include these records.
Summary Records
The Summary Record table removes all caller information and summarizes the CDR information based on the dialed and terminating number.
It contains statistical information about calls to dialed/terminating numbers. The reports generation is much faster than CDR-based reports.
Typically, the summary records are kept for the longest duration (months/years)
Note: The report based on the summary records may not produce the same results as the similar reports based on CDR because the timestamp used for summary records is based on the call end time.
Call Progress Messages (CPM)
The CPM data source provides detailed information on each call including several records describing each step in any particular call. For example, start of call (ring time), call answer and call disposition(hang-up).
Typically, the CPM data tables keep records for a short duration (days).
For each call, Call Progress Messages (CPMs) are generated upon these events:
- When a call results in busy signal.
- When a call results in busy signal and is forwarded.
- When a call is answered.
- When a call is terminated.
- When a call is not answer and the caller hangs up.
Note: The Call ID is the field that links the CPMs of one given call.
Viewing the Report
The report will be shown in its own tab sheet upon creation. Queried reports are also automatically saved in a file of type "*.ABS". You can recall saved reports by navigating to "Reports > Select Saved Report".
To delete one or many saved reports, navigate to "Reports > Delete Saved Report", select one or many files and click "Delete".