I have an Excel Workbook which I've managed to bring into Framework Manager via an ODBC connection. It doesn't allow me to model the data coming out of the spread sheet. Is there a certain way the data in spread sheet needs to be formatted in order for this to work properly?
1. Does the workbook contain multiple worksheets?
2. Did you omit headers in the worksheet? (in row 1)
The workbook does contain multiple sheets in it and it does have headers but also has multiple tables on 1 sheet. I guess I need to have only sheet in the work book and a simple layout of the data on that 1 sheet. Is this correct?
AFAIK you need a .csv style format: no headers, no spreadsheet elements. Multiple tables in the sheet? That will never work. Cognos will need one uniform format only (as if it where a database table/view)
It will assign datatype and usage based on the first row it encounters. You can imagine what happens when the columns do not store 1 datatype