Database Reference
In-Depth Information
The customer service manager wants to have a report of problem orders, meaning that the reps
have taken calls on these orders and the customer was not satisfied. This way the manager can
follow up later to check for resolution.
The list of problem orders keeps changing. The manager gets a new list in a file every day
from the call center. Currently, the call center database for customer complaints is not integrated
with the sales database, and the only way to get the list of orders to follow up with is to create a
prompted report and select all orders that are on the list.
Selecting such orders, of which there are always several dozen, from a long list of existing
orders is always tedious, and there is a big potential that some can be missed. The manager would
like to upload the list of orders he gets from the call center every day and run a report with the
information he needs about these orders only.
The final result we should look similar to Figure 6.5.
Figure 6.5
Completed problem order report
The report will utilize the new IBM Cognos 10 Report Studio's capability to allow advanced
report authors to import their own external data sources (e.g., text files and spreadsheets). We
will also use a Repeater Table object to achieve automatic paging though the order detail infor-
mation.
