Process for Creating Dimension Build Rules Files

To create a dimension build rules file:

  1. Determine whether to use the same rules file for data loads and dimension builds.

    See Combining Data Load and Dimension Build Rules Files.

  2. Create a rules file.

    See Creating Rules Files.

  3. Set the file delimiters for the data source.

    See Setting File Delimiters.

  4. If you are creating a dimension, name the dimension.

    See Naming New Dimensions.

  5. Select the build method.

    See Selecting a Build Method.

  6. If necessary, change or set the properties of members and dimensions you are building.

    See Setting and Changing Member and Dimension Properties.

  7. If necessary, set record and field operations to change the members in the data source during loading.

    See Using a Rules File to Perform Operations on Records, Fields, and Data.

  8. Set field type information, including field type, field number, and dimension.

    See Setting Field Type Information.

  9. Validate and save the rules file.

    See Setting Dimension Build Operational Instructions.