16-09-2016, 11:00 AM
[attachment=71077]
INTRODUCTION TO OLAP
OLAP (online analytical processing) is a processing tool that enables a user to easily and selectively extract and view data from different points of view.
OLAP allows users to analyze database information from multiple database systems at one time.
OLAP data is stored in multidimensional databases.
OLAP processing is often used for data mining.
OLAP products are typically designed for multiple-user environments, with the cost of the software based on the number of users.
Some popular OLAP server software programs include:
Oracle Express Server
Hyperion Solutions Essbase
HISTORY OF OLAP
1725 – 2oth century: Punch Cards
1962: Kenneth Iverson Introduces Foundation of OLAP
1975: First OLAP Product—Express
1979: First Spreadsheet Program—VisiCalc
1982:OLAP for Financials—System W
1983: Lotus 1-2-3
1985: Excel 1.0
1993: Introduction of the term OLAP
1997: Power OLAP -PARIS Technologies
1998: Hyperion Solutions launched
2012: PARIS Technologies releases OLATION
FEATURES OF OLAP
Multi-dimensional views
Managers must be able to analyze data across any dimension, at any level of aggregation, with equal functionality and ease
Calculation intensive capabilities
Complex calculations such as forecasting, trend analysis such as moving average and percentage growth, complex algebraic equations are performed in procedural and quick manner
Time intelligence
Year to date, period over period comparisons are possible with OLAP
OLAP OPERATIONS
Slice & Dice:
A slice is a subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset.
The dice operation is a slice on more than two dimensions of a data cube (or more than two consecutive slices).
Drill Down/Up: Drilling down or up is a specific analytical technique whereby the user navigates among levels of data ranging from the most summarized (up) to the most detailed (down).
Roll-up: A roll-up involves computing all of the data relationships for one or more dimensions. To do this, a computational relationship or formula might be defined.
Pivot: To change the dimensional orientation of a report or page display.
The output of an OLAP query is typically displayed in a matrix (or pivot) format. The dimensions form the row and column of the matrix; the measures, the values.
INTRODUCTION TO OLAP
OLAP (online analytical processing) is a processing tool that enables a user to easily and selectively extract and view data from different points of view.
OLAP allows users to analyze database information from multiple database systems at one time.
OLAP data is stored in multidimensional databases.
OLAP processing is often used for data mining.
OLAP products are typically designed for multiple-user environments, with the cost of the software based on the number of users.
Some popular OLAP server software programs include:
Oracle Express Server
Hyperion Solutions Essbase
HISTORY OF OLAP
1725 – 2oth century: Punch Cards
1962: Kenneth Iverson Introduces Foundation of OLAP
1975: First OLAP Product—Express
1979: First Spreadsheet Program—VisiCalc
1982:OLAP for Financials—System W
1983: Lotus 1-2-3
1985: Excel 1.0
1993: Introduction of the term OLAP
1997: Power OLAP -PARIS Technologies
1998: Hyperion Solutions launched
2012: PARIS Technologies releases OLATION
FEATURES OF OLAP
Multi-dimensional views
Managers must be able to analyze data across any dimension, at any level of aggregation, with equal functionality and ease
Calculation intensive capabilities
Complex calculations such as forecasting, trend analysis such as moving average and percentage growth, complex algebraic equations are performed in procedural and quick manner
Time intelligence
Year to date, period over period comparisons are possible with OLAP
OLAP OPERATIONS
Slice & Dice:
A slice is a subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset.
The dice operation is a slice on more than two dimensions of a data cube (or more than two consecutive slices).
Drill Down/Up: Drilling down or up is a specific analytical technique whereby the user navigates among levels of data ranging from the most summarized (up) to the most detailed (down).
Roll-up: A roll-up involves computing all of the data relationships for one or more dimensions. To do this, a computational relationship or formula might be defined.
Pivot: To change the dimensional orientation of a report or page display.
The output of an OLAP query is typically displayed in a matrix (or pivot) format. The dimensions form the row and column of the matrix; the measures, the values.