Identifying Variables

After querying the source data, you must identify the contents of each field in the query results.

Procedure

  1. Click the Variables tab.

    Note that the Variable Name column has been filled with the correct column names from the database.

  2. Change the selections in the Contents column to these selections.

    Variable Name

    Contents

    ACCOUNT_ID

    Ignore

    PARENT_ID

    Ignore

    NAME

    Element

    TYPE

    Consolidation

    SALESREP

    Consolidation

    SALESTEAM

    Consolidation

    You are now ready to map variables.