In India, many of the post offices are functioning manually while the database related to the
various kinds of postal services is very long, therefore, present work is an attempt to create
OLAP cube for storing a large database and one can perform various queries and get result within
a few seconds. Implementation of the present work requires the computerization of all the
branches of Indian postal services. Now days the system is using relational database management
system but using the proposed UML model, one can also use the Object Oriented database stored
in the form of OLAP cube, which is more powerful incomplex situation and queries.