To open Data Prep Editor, from the console menu bar, select File, then Editors, then Data Prep Editor.
You use Data Prep Editor to create and modify rules files for loading data to an Essbase application. In Data Prep Editor, you can open data sources such as text files, spreadsheet files, and SQL data sources. Data Prep Editor displays the data source, enabling you to see what needs to be changed in order to load the data successfully.