Rules files specify how Essbase, during data loads and dimension builds, handles data-source data and metadata.
To open a rules file, you must have at least Read permissions for the database with which the file is associated.
To open rules files:
From Enterprise View or a custom view, locate the application or database with which the preferred rules file is associated.
Under the application or database node, expand the Rules Files node
The rules file opens in Data Prep Editor. Essbase Administration Server may prompt you to lock the script. If you plan to modify the script and save the modifications, you should lock the script so that other users cannot modify it while you are working on it. See Locking and Unlocking Objects.
Select View, then Data load fields or View Dimension build fields.
Open the data file or SQL database data source.