|
Migration
and upgradation
When GE Supply required migration of a
business objects repository from Informix
to Oracle and upgradation of business
objects and web intelligence from version
4.1.5 to 5I, it turned to CMC
Project
Date warehouse: Global logistics management
system
Client
Ford Motor Company, Dearborn, Michigan,
USA
The
Ford Motor Company needed a data warehousing
solution for its global logistics management
system. Its size was to be 40 gigabytes
and it was to have over 100 users. CMC's
brief involved designing of the warehouse
to ensure compatibility to the business
objects reporting tool. This included
designing of the dimension tables, including
the plant, supplier, time, carrier, parts,
model, etc. CMC was also involved in designing
the fact tables like freight bill, vouchers,
shipments, shipping instructions, etc.
The system was designed to create various
canned reports like shipment frequency,
accrual, carrier performance, etc, and
supported users' ad hoc queries using
the business objects universe.
Features
|
|
User friendly interface: BO Universe |
|
|
Excellent security features |
|
|
Web
interface |
|
|
Compatibility
with most databases |
|
|
Good
performance |
|
|
Drilling,
slicing and dicing features |
|
|
Canned
reporting like operating plan report,
accrual report (amount not yet billed
or cheques not issued), premium vs
normal freight movement, plant-wise
production over a period of time,
etc |
Technical
architecture
Technical environment: Business Objects
5.0, WEBI, NCR Teradata database
|
