How to Import excel as datasource in Cognos 8 Framework Manager

[ggreddi]

hello guys,
please let me th steps to import excel as datasource into Framwork Manager.
I am using Cognos 8.3 and excel 2007 in windows environment.

Cheers
GG

[chandug8]

Hi ggreddi,

Were you able to resolve the issue, if so could you please explain the approach you followed.

I'm also having the same issue.


Regards,
Chandu

[vij]

HI all,
to import an EXCEL as data source in Framework Manager need to follow the steps as below....

1)create a data range in the excel sheet.
2)e.g. if u have 4 columns and 1000 rows then select the entire rows and columns along with column heading and go to Insert ---->Name--->Define
3)Give specific name as Table1 to that range.
4)now create an ODBC with this Excel.
5)Now in Cognos Connection create a Data source with this created ODBC.
6)import this created data source connection in Framework Manager and you will get Table1 in FM.

hope it will helps you


regards,
vij  :)

[gyangupta]

In addition to Vij comment, if you have FM installed on separate machine and Cognos on separate machine then you have to create same odbc in both machine and  point odbc to excel file in both machine's physical drive location.