My Oracle Support Banner

How The Data Of A Measure Is Stored In A 10g Analytic Workspace (Doc ID 563310.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle OLAP - Version 10.1.0.2 and later
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

In Analytic Workspace Manager (AWM) we define the logical objects: dimensions, cubes, measures of an Analytic Workspace (AW).
A measure belongs to a cube, which is dimensioned by dimensions.
Depending on the implementation details that we specify when we define a cube, the objects created in the AW in order to store the data of the measures varies.
This document describes the AW objects where the data of the measures are stored.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 NOTE: In the images and/or the document content below, the user information and data used represents fictitious
 Introduction
 Non compressed, non partitioned cube
 Non compressed, partitioned cube
 Compressed, non partitioned cube
 Compressed, partitioned cube

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.