About Field Operations

Within data-load and dimension-build rules files, Essbase can operate on one field as one unit. While loading data or building dimensions, you can ignore, manipulate, or rename fields:

You can ignore a field in the following ways:

Ignore all fields in a column.
Ignore fields based on string matches.

You can change the position of a field in the following ways:

Move fields to a new location.
Join fields together.
Create a new field by joining two existing fields.
Create a new field by adding a field with a text value.
Split a field into two fields.
If desired, you can undo each position change.

You can change the name of a field in the following ways:

Map the field name to a member name in the outline.
Replace text strings in a field name.
Change the case of the field name.
Drop extra spaces around the field name.
Convert spaces in a field name to underscores.
Add prefixes and/or suffixes to a field name.

Related Information

About Data Loading or Dimension Building
Creating a Data Load Rules File
Creating Dimension Build Rules Files
About Data Operations
About Record Operations
Selecting Multiple Fields