Print Page - Excel file as data source

Title: Excel file as data source
Post by: charlie on 14 Oct 2010 11:22:16 AM

Hi all,
What should the format of an excel file if i want to make it a data source in cognos. Currently the file i am working with gets me this message after import.

Completed the import process.
No objects were created.

Any suggestions on how FM will recognise items in a excel file?
Thanks

Title: Re: Excel file as data source
Post by: MFGF on 14 Oct 2010 12:55:12 PM

Hi,

You need to define at least one Named Region in your worksheet. Each one you define then appears as a "table" when you point to it from C8.

Regards,

MF.

Title: Re: Excel file as data source
Post by: charlie on 14 Oct 2010 02:46:38 PM

Thanks MF it worked :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: charlie on 14 Oct 2010 11:22:16 AM