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