If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel Data in Framework Manager (Cognos 8.4)

Started by civicman4, 20 Oct 2009 11:07:46 AM

Previous topic - Next topic

civicman4

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?

blom0344

1. Does the workbook contain multiple worksheets?
2. Did you omit headers in the worksheet? (in row 1)

civicman4

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?

blom0344

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