Introduction

This chapter is designed to show some of the differences we will need to consider when developing an Aggregate Storage Option (ASO) database in contrast to the classic Block Storage Option (BSO) database. In addition, we will also create a drill-through report in Essbase Studio to complete the tasks discussed in Chapter 3's list of development tasks.

Tip

There is one database type that we will not be discussing but is worth mentioning here for your information. The XOLAP (eXtended On-Line Analytic Processing) database has hierarchies and an outline, just like the ASO and BSO database types, but when a user requests data, a SQL Script is generated and the relational data source is queried. The process of designing the XOLAP database is similar to the database modeling we completed in the previous chapters, but it does have some differences in its work flow and user guidelines. Review the Oracle Essbase Studio User's Guide for more information on XOLAP.