Rejecting Records

Within data load and dimension build rules files, you can define one or more rejection criteria (string and number conditions) and, thus, reject the records that you do not want to load into the database.

  To define one or more rejection criteria to prevent a record from being loaded into the data source:

  1. Open or create a rules file.

  2. Select one or more fields.

  3. Select Record, then Reject.

  4. In the Reject Record dialog box, define a criterion.

  5. Optional: To apply another rejection criteria to the selected fields:

    1. Click New.

    2. Repeat step 4.

    3. Select AND (to reject a record only if all criteria are met) or OR to (to reject a record if any criterion is met).

  6. Optional: To create one or more rejection criteria on multiple fields, repeat steps 2–5 and specify how Essbase combines the criteria of the various fields.

Related Information