Cognos 8 - Report Studio - IMPORT FROM EXCEL FILE

[giovanni.lucarelli]

Hi to everybody!

I have this problem:
I am working with report studio and I need to import data in my report from excel file; I did the ODBC connection for this file and it's working ...but report studio asks me a sql or mdx to retrieve that data from Excel and I am not able how to do this  :-[

Can u help me?

thanks very much

[Suraj]

Not sure what's wrong but here are the steps for your reference:

1. Create a system DSN in the Windows ODBC Administrator. Note: The excel file must be local to the Cognos server.

2. Create a new data source in Cognos Connection, select ODBC (Windows only) option.

3. Enter the system DSN name you created in Step 1 under ODBC data source property.

[giovanni.lucarelli]

I did this and everything is ok with the ODBC connection; I tested it in Cognos and it's ok... just I am not able to retrieve data in this excel in my report (in Report Studio)....

[rks]

Did you define "name" for your data in excel file?

[giovanni.lucarelli]

I did: the sql query to retrieve your data from excel file is this:
select * from [sheet_name$]
naturally you have to create ODBC connection for it and create query in FM.

ciao