As the modeler, you must ensure that the columns in your model reflect the current state of your data sources. You can quickly resynchronize your model columns after a data update if your model uses a single query based on a text data file or an IQD,
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.