Finish importing data
You can change how query items from your external data file appear after they are imported into IBM® Cognos® Analytics. For example, you can change the number of decimal places or the default summary.
If you want to use numeric
data from your external data source as a measure in a crosstab, you
must assign that data item a default summary other than Unsupported.
A specified default summary makes the data item appear as a measure
in the data tree in the Source tab 
. Otherwise, if
you add the data item with an Unsupported default
summary as the measure in a crosstab, no values appear.
| Attribute | Description |
|---|---|
Data type |
Identifies whether data in the file is one of the following types: Integer, which represents numeric values. Decimal, which represents integer values that are scaled by a variable power of 10. Text, which represents values that contain letters and symbols. Date or Date Time, which represent dates and times. |
Default summary |
Identifies Sum, Average, Max, Min, Count or Unsupported as the default type of summary for the data item. Applies only to Integer and Decimal data types. |
Decimal places |
Specifies the number of decimal places for the data item. Applies only to the Decimal data type. |
If you mapped links between data items in your external data and data items in your enterprise data, specify the options that define the relationships between the data items.
For each data item that you import and link, specify whether values are unique or exist more than once in both your external data and in your enterprise data. You can also specify how to handle rows that contain missing values in the report results.