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

Chapter 16. Multidimensional Reporting A... > OLAP Concepts and OLAP Reporting

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 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 16.1 highlights some common business areas and typical sets of related dimensions.

Table 16.1. Business Areas and Commonly Associated OLAP Dimensions
Business AreaAssociated Business and Common OLAP Dimensions
SalesSales Employees, Products, Regions, Sales Channels, Time, Customers, Measures
FinanceCompany Divisions, Regions, Products, Time, Measures
ManufacturingSuppliers, 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