CHAPTER 1Introduction to OLAP

Online analytical processing (OLAP) uses a multidimensional approach to organize and analyze business data. By storing data in highly optimized structures, businesses can very quickly explore the data and uncover important insights that would otherwise remain hidden. As a result, OLAP enables companies to achieve key organizational goals, including wide-ranging business intelligence.

We begin this chapter by defining OLAP within the larger context of business intelligence. Then we review the benefits you can expect to see by implementing OLAP technology in an organization. Next, we have an OLAP primer—a short introduction to what makes up an OLAP system and what kinds of OLAP implementations are possible. This foundation ...

Get Oracle Essbase & Oracle OLAP now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.