Dropping Leading and Trailing Spaces
You can drop leading and trailing spaces from around fields of the data source. A field value containing leading or trailing spaces does not map to a member name, even if the name within the spaces is an exact match.
By default, Essbase drops leading and trailing spaces.
To drop spaces around a field, see “Dropping Spaces Around Fields” in the Oracle Essbase Administration Services Online Help.