Entering Properties

  To enter properties:

  1. Do one of the following, depending on whether you are entering properties for a flat file or for a Data Relationship Management application.

    • If you are entering properties for a flat file:

      1. In File Properties, select a column delimiter.

        You can select semicolon (;), comma (,), pipeline (|), space, or tab. Semicolon is the default.

        Note:

        The delimiter you select must be found in the file.

      2. Optional: To remove double quotes from a string, select Remove Double Quotes on Strings.

        If the flat file contains member formulas, deselect Remove Double Quotes on Strings to prevent quotation marks from being removed.

      3. Optional: To remove spaces in the load file, select Remove White Space.

      4. Optional: If you do not want transaction logs to be created, select Suppress Transaction Logs.

    • If you are entering properties for a Data Relationship Management application:

      1. Select the Data Relationship Management application from which to import dimensions. (All Data Relationship Management applications that are registered in Shared Services are listed.)

      2. Select the Data Relationship Management version from which to import metadata. (All versions you have access to in the Data Relationship Management application are listed.)

      3. Select the Data Relationship Management export profile. (All export profiles for the selected application are listed.)

  2. Optional: If you do not want transaction logs to be created, select Suppress Transaction Logs.

  3. Click Next.

    Now you will map the dimensions, as described in Mapping Dimensions.