Resolve Invalid Date Errors

In most cases, Cognos® Transformer can determine and apply the correct date format for input from a source column.

An Invalid Dates category is automatically generated when the correct input format cannot be determined or when a problem arises with the source data.

You may have to change the format of the date information in your source file, change the Date input format property on the Time tab of the Column property sheet or, if the data is corrupt, rebuild your source file.

Procedure

  1. In the Data Sources list, open the property sheet for the column on which the time dimension is based.
  2. Click the Time tab.
  3. From the Date input format box, select the appropriate date format and click OK.
  4. In the Data Sources list, select the data source for which you want to regenerate categories, and from the Run menu, click Generate Categories From Selected Data Source.