You can use rules files to specify how Essbase, during data loads and dimension builds, handles data-source data and metadata.
To create rules files:
From Enterprise View or a custom view, select an application or database.
Select File, then New to open the New dialog box.
Select Rules file, and click OK.
The new rules file opens in Data Prep Editor.
Select View, then Data load fields or View, then Dimension build fields.
Open the data file or SQL database data source.