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

What Is OLAP?

To understand how OLAP data and Analysis Services work, you need to understand a little bit of what happens behind the scenes, as well as some of the terminology used to describe portions of the data and the summarizations that are generated in OLAP.

To help introduce the principles of OLAP, a small sample database is provided in the form of an Excel workbook, named CarSales.xls, in the Chap07 folder. This sample database lists the sales of 1000 cars over two years’ time for a regional specialty automotive dealership. The first 10 records of the database are shown in Figure 7-1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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