Olap operations

WHAT IS OLAP, FEATURES OF OLAP , NEED FOR OLAP, DIFFERENT OLAP FUNCTIONS.

1. Olap operations Name – Rohan jaiswal Roll no : Bwu/Bba/16/042 Sub code: bba 405

2. Online Analytical Processing , or OLAP , is a powerful data discovery tool designed to enable users to perform multidimensional analysis of data.

3. FEATURES OLTP OLAP

4. THE NEED FOR OLAP Business-Focused Multidimensional Data Business-Focused Calculations   consistency of informa tion predictive advantages

5. Roll up / Drill up The roll-up operation performs aggregation on a data cube , either by climbing up a concept hierarchy for a dimension or by climbing down .

6. Roll down / Drill down The roll down operation is the reverse of roll up . It navigates from less detailed data to more detailed data.

7. Slic ing The   slice operation  performs a selection on one dimension of the given cube , resulting in a subcube . Reduces the dimensionality of the cubes .

8. Dicing The   dice operation  defines a sub-cube by performing a selection on two or more dimensions .

9. P ivoting Pivot is also known as rotate . It Rotates the data axis to view the data from different perspectives .

10. BIBLIOGRAPHY https://techdifferences.com http://www.lastnightstudy.com

11. Thank you ! & have a nice day !