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 Data Warehouse (SDW)

Customers

  1. Otis-LG, Korea

The challenge

Store OTIS service related information and make it available for effective reporting and analysis.

The solution

The scope of the project consists design, develop, test and deployment of SDW solution at client site at Otis-LG, Korea.

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 80+ 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.

All SDW reports can also be viewed on the Intranet using Internet Explorer IN Business Objects Web Intelligence software. Some of the reports are automatically refreshed and distributed to the users using the Broadcast Agent on scheduled basis.

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.