ONLINE
Analytical Processing (OLAP) allows users to analyze database
information from multiple database systems at one time. An OLAP Cube is
a data structure that allows fast analysis of data according to the
multiple Dimensions that define a business problem. OLAP in a data
warehouse enables companies to organize information in multiple
dimensions, which makes it easy for businesses to understand and use
data. Since OLAP contains multidimensional data usually obtained from
different and unrelated sources, it requires a special method of storing
that data. OLAP tools enable users to analyze different dimensions of
multidimensional data using self-service.
In our research and implementation scope, we have used OLAP method to
provide corporate level multidimensional data to the business users.
Corporate Information Models (CIMs) provide trusted and qualified data
from multiple sources for everyone to build their own business
intelligence reports and dashboards.
Corporate Information Models are Online Analytical Processing (OLAP)
Cubes – a data structure that enables simple and rapid analysis of data
by the multiple dimensions that define a business problem. A
multidimensional cube for reporting composed of multiple Dimension e.g.
Customers, Product Lines, business units and Date. By storing data using
OLAP cubes, data is pre-calculated and ready-to-use, eliminating
long-running data queries and enabling self-service business
intelligence. A portal has been developed to provide and display the CIM
detail. The CIM catalog links to over 60 CIMs categorized by the seven
main categories called Value streams.