Making Source Fields as Small as Possible

To improve performance of Essbase block storage data load, you can make fields in the source data 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.