Making Source Fields as Small as Possible
Making fields in a data source smaller enables Essbase to read and load faster.
Make the fields in the data source as small as possible by performing the following tasks:
Remove excess white space in the data source. For example, use tabs instead of blank spaces.
Round computer-generated numbers to the precision you need. For example, if the data value has nine decimal points and you care about two, round the number to two decimal points.
Use #MI instead of #MISSING.