Data warehousing infrastructure for web based reporting tool

A method for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application comprising the steps of:

• generating a current customer list on a daily basis comprising customers entitled to receive daily telecommunications call detail data;
• receiving customer's daily raw telecommunications call detail data records from one or more telecommunications network switch mechanisms, and extracting those call detail data records for only those customers entitled to receive said call detail data;
• receiving said extracted call detail data records and replacing one or more call detail data items therein with a corresponding dimension key found in a dimension build table associated with said call detail item;
• and,
• generating an output fact table comprising customer records having said unique key structures for enabling consolidated storage of specific customer call detail data;
• implementing a secure server to manage client sessions over the Internet, the secure server supporting secure communication of customer request messages between the browser application client and the secure server;
• and,
• receiving said customer requests from said secure server and generating corresponding database queries implementing said dimension keys for application against said output fact table to obtain a specific customer's call detail data, said call detail data being transmitted back to said client web browser via said secure server,
• whereby expedient and updated web/Internet-based access to said customer's daily call detail data is assured.

A Web/Internet based reporting system for providing timely delivery of a customer's priced telecommunications call detail data to a client workstation running a web browser application, said system comprising:

• a data warehousing infrastructure comprising:
• a traffic component to receive raw telecommunications call detail records from one or more telecommunications switches and to sort the call detail records into billing detail records;
• a billing system to perform pricing in connection with one or more billing detail records;
• an extraction component to extract selected customer billing detail records;
• a harvesting component to transform the selected billing detail records based on a set of business rules into transformed billing detail records;
• a data store component to store the transformed billing detail records into one or more data marts;
• at least one secure server for managing client sessions over the Internet, the secure server supporting secure communication of customer requests between the browser application client and the secure server;
• and,
• a device for receiving the customer requests from the secure server and generating corresponding database queries to obtain a specific customer's call detail data, the call detail data being transmitted back to said client web browser via the secure server.