Cognos Framework manager and excel data
Hi,
I have to exract data from an excel file in Cognos Framework manager.
In my excel sheet I have a column which format is text. When extracting the data only the cellss containing letter + numeric are displayed and all the cells with only numeric values are not displayed framework manager just shows blank value.
Any idea?
One answer
Hello Fabien,
it sounds related to this issue:
Alpha Numeric values do not display correctly: Excel ODBC
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bexcel+%2bdatasource&uid=swg21352663&loc=en_US&cs=utf-8&cc=us&lang=all
"Though the column in Excel is defined as Text, Excel does not actually see datatypes as relational databases do. Because of this, the ODBC driver for Excel scans the first N rows (the default is 8 and the maximum is 16) to find out what types of values are in the cells."
You might try changing the order of your columns and see if it makes any difference.
Best Regards,
Francesco Chiossi
it sounds related to this issue:
Alpha Numeric values do not display correctly: Excel ODBC
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bexcel+%2bdatasource&uid=swg21352663&loc=en_US&cs=utf-8&cc=us&lang=all
"Though the column in Excel is defined as Text, Excel does not actually see datatypes as relational databases do. Because of this, the ODBC driver for Excel scans the first N rows (the default is 8 and the maximum is 16) to find out what types of values are in the cells."
You might try changing the order of your columns and see if it makes any difference.
Best Regards,
Francesco Chiossi