Valid Formatting Characters

Essbase views some characters in the data source as formatting characters only. Essbase ignores the characters listed in Table 39:

Table 39. Valid Formatting Characters

Formatting Character

Description

==

Multiple equal signs, such as for double underlining

--

Multiple minus signs, such as for single underlining

_ _

Multiple underscores

==

Multiple IBM PC graphic double underlines (ASCII character 205)

_ _

Multiple IBM PC graphic single underlines (ASCII character 196)

Ignored fields do not affect the data load or dimension build.

For example, Essbase ignores the equal signs in the following data source and loads the other fields normally.

East  Actual  "100-10"
      Sales   Marketing
      =====   =========
Jan   10      8
Feb   21      16