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.
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:
The Accounts dimension has four members: Sales, COGS, Margin, and Margin%.
The Time dimension has four quarter members, and Qtr1 has three month members
The Scenario dimension has two child members: Budget for budget values and Actual for actual values.
Figure 15. A Multidimensional Database Outline