There is a significant difference in the way Advanced Relational Access and Essbase perform data loads in ragged hierarchies. Because of this difference, separate queries made against a ragged hierarchy can display different consolidation totals.
Essbase loads values in the upper-level members of a ragged hierarchy only when the level 0 members are non-null. Advanced Relational Access, however, loads values in the upper level members of the ragged hierarchy regardless of the value in the level 0 member.