Sometimes, you can track down problems with dimension builds by understanding how Essbase initializes the rules file and processes the data source.
Essbase performs the following steps to initialize a rules file:
Then Essbase performs the following operations on each record of the data source during a data load or dimension build:
Applies field operations to the data in the order in which the operations are defined in the rules file.
Field operations include joins, moves, splits, and creating fields using text and joins. To see the order in which field operations are defined in the rules file, see Performing Operations on Fields.
Essbase applies all properties for each field, applying all properties to field1 before proceeding to field2. Essbase applies field properties in the following order:
Adds members, or member information, or both, to the outline
If you chose to skip lines, Essbase skips the number of lines that you specified; otherwise, Essbase proceeds to the first record.
Essbase performs selection or rejection criteria in the order in which the criteria are defined in the rules file. Essbase loads or rejects individual records of the data source based on the specified criteria.