Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PowerPlay - datasource

Status
Not open for further replies.

spicysudhi

Programmer
Nov 10, 2003
575
FR
hi

below is normal way:
Impromptu administrator -> data source creation -> catalog -> report -> iqd -> Transformer -> cube.

here the transfomer used the datasource name (mentioned in the IQD) created by Impromptu while creating catalog.

now situation i am facing is the server got only tranformer and no impromptu. I created IQD files manually (by storing the SQL query in required format) which contains a datab source name. question is how to add the data source details to cognos.ini file, i mean the syntax for the datasource entry, will it change from database type (like oracle, SQl server etc etc).

regards,
sudhi
 
sudhi,
you should only need to make sure that the System Data Source Name (System DSN tab) in ODBC administrator of Windows matches the DATABASE label at the top of your IQD file.

soi la, soi carre
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top