Services |Skills |Solutions |Support |Quality |News Center
Home
Clients
Company
Contact
Careers
Site Map
Solutions
Solution Details
Express Draw
Business Intelligence & Data Warehousing
Network Management System
Web Applications
Web Based Training
Engineering Centre
J D Edwards COE
BI (Business Intelligence) & DW (Data Warehouse)
Service Management System (SMS) Reports

Customers

  1. Otis Singapore

The challenge

Created managerial and user level reports to analyze the customer callbacks in various views.

The solution

The scope of the project consists design, develop, test and deployment of SMS solution at client site at OTIS-Singapore.

ISRC designed the warehouse for the better performance using the Data Integrator as the ETL Tool.

Based on the warehouse generated from the transactional database, several universes were created using Business Objects software. From the produced warehouse, about 100+ reports were generated.

All these reports offer the analysis features like drilling, filtering, slice-dice, prompting for required filter and various other types of customized reporting.

A security mechanism is implemented to allow the office level, group level and user level security.

The platform

Windows 2000, MS SQL Server 2000, Business Objects 6.1, Data Integrator 6.1

© 2005-2006 Information System Resource Centre Pvt. Ltd.
All rights reserved.