• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 20. Multidimensional Reporting Agai... > Introduction to OLAP Concepts and OL...

Introduction to OLAP Concepts and OLAP Reporting

OLAP is an analysis-oriented technology that enables rapid analysis of large sets of aggregated data. Instead of representing information in the common two-dimensional row and column format of traditional relational databases, OLAP databases store their aggregated data in logical structures called hypercubesmore commonly referenced simply as cubes. These OLAP cubes are created around specific business areas or problems and contain an appropriate number of dimensions to satisfy analysis in that particular area of interest or for a specific business issue. OLAP is a technology that facilitates data viewing, analysis, and navigation. More than a particular storage technology, OLAP is a conceptual model for viewing and analyzing data. Table 20.1 highlights some common business areas and typical sets of related dimensions.

Table 20.1. Business Areas and Commonly Associated OLAP Dimensions
Business Area Associated Business and Common OLAP Dimensions
Sales Sales Employees, Products, Regions, Sales Channels, Time, Customers, Measures
Finance Company Divisions, Regions, Products, Time, Measures
Manufacturing Suppliers, Product Parts, Plants, Products, Time, Measures



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint