Print Page - using excel as a data soucre in cognos

Title: using excel as a data soucre in cognos
Post by: surinder on 06 Jul 2008 11:29:51 PM

Hi everybody

is there any way of using excel as a data soucre in cognos..if it is please reply me...It will be really appreciated

Tha nks Techhies

Title: Re: using excel as a data soucre in cognos
Post by: Ty Clabbers on 08 Jul 2008 03:21:48 AM

Create an odbc connection to the file and add this connection as a datasource.

Title: Re: using excel as a data soucre in cognos
Post by: vijayab on 28 Aug 2008 04:42:36 AM

Hi

Yes we can use Excel database as datasource in cognos
1)cretate a Xsl Sheet with specified range into it.
range it is nothig but select ur whole data column with data in that EXCEl and go to Insert--->Name--->Define
select the whole data and give name to that range and say Add thats it..
2)Next step is to create ODBC of that Excel sheet .
3)Import that ODBC into FM(Framework Manager) model as data source.

Hope this will help u :)

Regards,
vj

Quote from: surinder on 06 Jul 2008 11:29:51 PM
Hi everybody

is there any way of using excel as a data soucre in cognos..if it is please reply me...It will be really appreciated

Tha nks Techhies

Title: Re: using excel as a data soucre in cognos
Post by: harish.malik on 08 Sep 2008 06:05:50 AM

That's Gr8.

It's working fine and flawlessly.

Thanks a lot. :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: surinder on 06 Jul 2008 11:29:51 PM