image image







       imageimageimageimageimage

OLAP Solution

Online analytical processing, or OLAP is an approach to swiftly answer multi-dimensional analytical (MDA) queries. The core of any OLAP system is an multidimensional cube OLAP cube It consists of numeric facts called measures which are categorized by dimensions.The cube metadata is typically created from a star schema or snowflake schema of tables in a relational database. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.

Image below highlights the MultiDimensional nature of the OLAP Cube showing a list of Products purchased by a number of Customers and the Cost implication (Measure)across a Time Period

image

Image of Data contained within a Cube deployed through using a Microsoft OLAP Solution

image

Image showing Excel2007/2010 Reporting off OLAP Cube with built-in KPIs(Key Performance Indicators)

image