Fine-tuning Source Data Detection

The Data Discovery tool will automatically detect data types of the individual columns in the source file. Only columns containing numeric data will be treated as Measures, while all other columns will be treated as dimensions. Furthermore, date columns will be detected and treated specifically as time dimensions.

However, sometimes you will want to fine-tune this detection and also how and if a specific column should be presented in the TARGIT client.

Your options for fine-tuning and displaying data are:

  • Change the column data type, e.g. to read an ID as a dimension instead of as a measure.
  • Change a measure to be shown only as a measure. Change a dimension to be shown only as a dimension. Change a measure to be shown as just a single aggregation type.
  • Hide irrelevant columns from the source data.

To work with these options, you must first start the Data Discovery from the Design ribbon:


Was this article helpful?
0 out of 0 found this helpful


  • Would any body know, why I don't have access to the "Data Discovery button " in my menu?body know why I don't have access to the "Data Discovery buttom " in my menu?

  • Hi Dan,

    It could be one of two things:

    1. First and foremost, the Data Discovery module requires a license add-on to a standard TARGIT license. If you don't have that, you won't see the Data Discovery buttons.
    2. If your TARGIT installation do have the Data Discovery license, it may be a question of Rights. I.e. that the Rights group that you are a member of does not grant you access to Data Discovery.

    BR / Ole


Please sign in to leave a comment.