Professional > Data management scripting > Publishing data > ReportingServices.ExposeToCognos component > Example IQD file
 
Example IQD file
COGNOS QUERY
STRUCTURE,1,1
DATABASE,household
TITLE,[Region_DIM]
BEGIN SQL
{select * from Region_DIM}
END SQL
COLUMN,0,serial
COLUMN,1,CategoryName
COLUMN,2,Region of main residence
The database (Household in the above example) defined in the IQD file needs to be defined in the Cognos.ini file (as shown below). The file location is different between the Cognos versions (8, 8.4, and 10). For Cognos 10, the file is located at: \c10\CS7Gateways\bin.
household = ^User ID:^?Password:;LOCAL;OL;DBInfo_Type=MS;Provider=SQLNCLI10;User ID=%s;Password=%s;Data Source=localhost;
Provider_String=Initial Catalog=household;@COLSEQ=
See also
ReportingServices.ExposeToCognos component