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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.