While processing data source records for loading values into aggregate storage databases, Essbase processes source data records only for the level 0 dimension intersections where the member does not have a formula.
The following example shows a data source with records for only level 0 intersections. The last field contains data values; the other fields are level 0 members of their respective dimensions.
Jan, Curr Year, Digital Cameras, CO, Original Price, 10784 Jan, Prev Year, Camcorders, CO, Original Price, 13573
Essbase ignores records that specify upper-level members and, at the end of the data load, displays the number of skipped records.
For example, the following record would be skipped because member Mid West is a level 1 member:
Jan, Curr Year, Digital Cameras, Mid West, Original Price, 121301
Sorting data sources is unnecessary because Essbase Server reads and sorts records internally before committing values to the database.