TR0806 Date is invalid

Technote (troubleshooting)


Problem(Abstract)

O/S: Windows 2000
Application: PowerPlay Transformer 7
Excel: Office 2000

Description:

Unable to update an existing cube after the .CSV file that was used for the datasource was modified in Excel.

Error Message -

TR0806 Date is invalid


Solution:

The date format that was entered in the Excel spreadsheet did not match the format defined in Transformer.

Steps -

1. Open the Excel spreadsheet.

2. Make the necessary changes to the date format.

3. Open the model in Transformer.

4. In the Data Sources window, select the data source that generates the error.

5. Right click the data source and then click data Source Viewer

6. Select the date column.

7. Right click the date column and then click Properties.

8. Click the Time tab and modify the Date Input Format to match the date column.

Build the cube.

Resolving the problem

The date format that was entered in the Excel spreadsheet did not match the format defined in Transformer.

Steps -

1. Open the Excel spreadsheet.

2. Make the necessary changes to the date format.

3. Open the model in Transformer.

4. In the Data Sources window, select the data source that generates the error.

5. Right click the data source and then click data Source Viewer

6. Select the date column.

7. Right click the date column and then click Properties.

8. Click the Time tab and modify the Date Input Format to match the date column.

Build the cube.

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Transformer
Business Analytics Cognos Series 7 Transformer

Historical Number

120346

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Series 7
Transformer

Software version:

Cognos 8 BI Transformer 7.3, PowerPlay Transformer 6.6, PowerPlay Transformer 7.0

Operating system(s):

Win2000, WinNT, Windows

Reference #:

1337731

Modified date:

2006-11-27

Translate my page

Machine Translation

Content navigation