Page 48 - DCAP606_BUSINESS_INTELLIGENCE
P. 48

Sartaj Singh,  Lovely Professional University
                                                                                       Unit 4: Understanding OLAP




                             Unit 4: Understanding OLAP                                         Notes


             CONTENTS
             Objectives
             Introduction

             4.1  Basic Concepts of OLAP
                 4.1.1   Components of OLAP
             4.2  Advantages of OLAP

             4.3  Fast Response
             4.4  Metadata Based Queries
                 4.4.1   Anatomy of a Path Expression
                 4.4.2   Block Selection
             4.5  Spread Sheet Formulas

             4.6  Analysis Services Speed
             4.7  Metadata
                 4.7.1   Types of Metadata

                 4.7.2   Metadata Functions
                 4.7.3   Advantage of Metadata
             4.8  Summary
             4.9  Keywords
             4.10 Review Questions

             4.11 Further Readings

          Objectives

          After studying this unit, you will be able to:

               Recognize Basic Concepts of OLAP
               List the Advantages of OLAP
               Explain about the Fast Response
               Describe the Metadata Based Queries
               Construct the Spreadsheet Formulas

               Discuss about the Analysis Services Speed
               Discuss about Metadata

          Introduction

          Online Analytical Processing (OLAP) is a technology that is used to create decision support
          software. OLAP enables application users to quickly analyse information that has been



                                           LOVELY PROFESSIONAL UNIVERSITY                                   43
   43   44   45   46   47   48   49   50   51   52   53