Hi,
I am trying to add an excel file as a datasource to a FM model. I created the excel driver in control "panel/Administrative tools/Data sources" but when i create and test the ODBC datasource on cognos conection i get "QE-DEF-0285 QE-DEF-0285 The logon failed." error.
Cognos server and excel file are both installed in my local machine, so when i create the excel driver i input the local path of the file "c:\documents and setting\......\file.xls", is that correct? or may i have to set the path in other format?
Another issue is that when i create the datasource on cognos connection, i dont know what to set in "ODBC connect string" property, i only set " ODBC data source" with the DNS.
Should i have to install Composite information server to create excel datasources?
Cognos conection anf FM are installed at the same machine, localhost.
Thanks in advance.
I am trying to add an excel file as a datasource to a FM model. I created the excel driver in control "panel/Administrative tools/Data sources" but when i create and test the ODBC datasource on cognos conection i get "QE-DEF-0285 QE-DEF-0285 The logon failed." error.
Cognos server and excel file are both installed in my local machine, so when i create the excel driver i input the local path of the file "c:\documents and setting\......\file.xls", is that correct? or may i have to set the path in other format?
Another issue is that when i create the datasource on cognos connection, i dont know what to set in "ODBC connect string" property, i only set " ODBC data source" with the DNS.
Should i have to install Composite information server to create excel datasources?
Cognos conection anf FM are installed at the same machine, localhost.
Thanks in advance.