Converting Spaces to Underscores
You can convert spaces in fields of the data source to underscores to make the field values match the member names of the database.
To change spaces to underscores, see “Converting Spaces to Underscores” in the Oracle Essbase Administration Services Online Help.