Setting Up Columns to Support Member and Measure Properties

To add columns in relational database tables to use the member and measure properties in Integration Services:

  1. Create columns in the relational database source.

  2. Name the columns.

  3. Define member and measure properties for the columns.

    Note:

    For purposes of explaining concepts, this chapter uses the column names of the Integration Services sample application.