Product:
Cognos TM1 Architect 10.2.2
Windows 2008 R2 Server
Oracle database
Problem:
When importing data from an ODBC oracle database, the preview in TM1 Architect is blank. You see the columns name, but no data.
You use a query statement like this SELECT * FROM IA_RUNREPORT;
Solution:
One of the columns in oracle database is in the format TIMESTAMP, and that is not considered a number or a string by TM1. You must then in your SQL statement convert that to a STRING.
Use this command:
TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”,

So then your SQL statement inside TM1 TI process Data Source Query should be something like this:
SELECT RUN_ID, ENV_ID, SOLUTION_ID, USER_ID, TIME_ID, CONTENT_ID, USERNAME, NAMESPACE, USERID, CAMID, REPORTPATH, TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”, TARGET_TYPE, STATUS, ERRORDETAILS, RUNTIME, PACKAGE, HOST_IPADDR, PROC_ID, SESSION_ID, REQUEST_ID, TIMEZONE_OFFSET, THREADID FROM IA_RUNREPORT;
Check in your Oracle data source with SQL Developer if there are any column that is not in NUMBER or VARCHAR format, because that you need to take care of in the import SQL statement to TM1.