CHAPTER 4Building an Oracle OLAP Analytic Workspace

The previous chapter focused on designing OLAP applications. In this chapter, we walk you through the steps required to build an Oracle OLAP analytic workspace. Recall that an Oracle OLAP analytic workspace contains a collection of dimensions and a collection of cubes, where any given cube contains only the dimensions required to describe the measures in that cube. The analytic workspace also holds other multidimensional objects, such as folders and programs, that are required for an OLAP analysis.

The chapter starts with an overview of the components and files used in the demonstration. During the demonstration, we walk you through how to prepare data, create an analytic workspace, create and ...

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.