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
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.
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)....
Did you define "name" for your data in excel file?
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