Perform this task to synchronize data source
items with the model.
Procedure
- In the Data Sources list, select the query whose columns you want to modify, and from the Tools menu, click Modify Columns.
- For data source items that do not appear as columns in the model, select the items in the Source list and click Add.
- For columns that you want to remove from the model, select the columns in the Model list and click Remove.
- For unmatched columns identified by a plus sign (+) in the Matched to Source column in the Model list, do one of the following:
- To manually match query items to columns, select a data source item in the Source list and a column in the model, and click Match.
- To allow Cognos®
Transformer to automatically match query items to columns, click Auto Match. Review any messages that appear and click OK.
Results
Data source items are now synchronized with the model.