Slay Bad Data in Essbase • 43
2.4.2 Comparing Dimensionality
With ASOsamp’s dimensions in a table, SQL can be used to compare the extracted
dimensionality to the data to be loaded before the fact data is loaded, so there are no
data load errors. is is the referential integrity discussed previously with aer-the-fact
enforcement. If the fact data contains members that are not in Essbase, special suspense
or unassigned members can act as a temporary load location so that at least the data
gets counted at the total dimension level. It would be nice to know if this occurred, on
a dimension-by-dimension basis, and when, so an administrator can identify which
dimensions need attention (there really is a proper place for those missing members, ...