Items in a Data Source

As illustrated in Figure 62, Records and Fields, a data source comprises records, fields, and field delimiters.

Essbase reads data sources starting at the top and proceeding from left to right.

Figure 62. Records and Fields

This image illustrates the concept of records and fields in a data source, as described in the text preceding the image.

As illustrated in Figure 63, Kinds of Fields, data sources can contain dimension fields, member fields, member combination fields, and data fields.

Figure 63. Kinds of Fields

This image illustrates the types of fields, as described in the text preceding the image.

Data fields are used only for data loading; dimension builds ignore data fields.

The following sections describe each item in a data source.