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 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.


  1. On the Data Attributes page, specify the attributes for each data item after it is imported and click Next.

    For example, if you import numeric data items, you can change the default summary and number of decimal places.

  2. On the Mapping Options page, specify the relationships between the linked data items and how to process the results in the report output.
  3. Click Finish.