Data Storage

Each data value in a multidimensional database is stored in one cell. A particular data value is referenced by specifying its coordinates along each standard dimension.

Note:

Essbase does not store data for attribute dimensions. Essbase dynamically calculates attribute dimension data when a user retrieves the data.

Consider the simplified database shown in Figure 15, A Multidimensional Database Outline. This database has three dimensions: Accounts, Time, and Scenario:

Figure 15. A Multidimensional Database Outline

This image shows an outline with three dimensions, as described in the text preceding the image.