OLAP – On – Line Analytical Processing

_ Coined by – E. F. Codd – 1993

_ Used in wide variety of business areas…

_ Sales & marketing analysis

_ Financial repairing

_ Quality tracking

_ Profitability analysis

_ Manpower & pricing applications

_ 12 Rules of OLAP

_ Arbor Software, Santa Clara, CA

1 Multidimensional conceptual views 7 Dynamic sparse matrix handling

2 Transparency 8 Multi user support

3 Accessibility 9 Unristricted cross dimensional

4 Consistent reporting performance 10 Intuitive data manipulation

5 Client / server architecture 11 Flexible reporting

6 Generic dimensionality 12 Unlimited dimensional &

aggregation levels

Uses of OLAP

Financial Department Budgeting

Activity based costing

Financial performance analysis

Financial modeling

_ Applications of OLAP

1 Marketing department Market research analysis

Sales fore casting

Promotion analysis

Customer analysis

Market / customer segmentation

2 Manufacturing OLAP

Application

Production planning

Defect analysis

Key Features of OLAP

_ Multidimensional views of data

_ Calculation intensive capabilities

_ Time intelligence