Cognos Report Template - Insert Table

For more information about adding data to a Cognos Report, see the IBM Cognos Online Help here.

To add an ArcSDE data source into Cognos report template, follow these steps:

Step 01> In Cognos Administration, Click the Configuration Tab and Click the New Data Source button.

Step 02> Specify a Name for the data source and Click next.

Step 03> Select the data source Type and Click Next.

Step 04> Enter the connection string details for the data source and Click Finish and then OK.

Now add an XML data source to Dekho’s selection servlet:

Step 05> In Cognos Administration, Click the Configuration Tab.

Step 06> Click the new Data Sources icon.

Step 07> Specify a data source Name and Click Next.

Step 08> Select XML as the data source Type and Click Next.

Step 09> Enter the following URL :

http://localhost:8080/Dekho/CognosSelectionServlet?sessionid=??sessionid??&layers=mymapservice.cadastre

Modify the URL to suit your Dekho configuration.

Now use the new data source in the report.

Step 10> In Cognos Report Studio, select Query Explorer.

Step 11> From the Insertable Objects panel, Drag an SQL object onto the Report panel.

Step 12> Click the SQL object on the report to show the Properties - SQL window.

Step 13> Select ArcSDE in the Data Source field.

Step 14> In the SQL field, Enter the following SQL:

select * from sde.cadastre

Step 15> From the Insertable Objects panel, Drag another SQL object onto the report.

Step 16> Click the SQL object on the report to show the Properties - SQL Window.

Step 17> In the SQL Syntax field, Select Cognos.

Step 18> Select the XML data source to the Dekho selection servlet in the Data Source field.

Step 19> In the SQL field, Enter the following SQL:

select * from dekhoselection

 

 

 

WARNING: The XML  Data sources test function fails.

 

 

 

Step 20> Click the Query2 object on the report to show the Properties - SQL Window.

Step 21> Change the Auto group & summarize option to No. This is only required for XML data sources.

Step 22> From the Insertable Objects panel, Drag a join object onto the report.

Step 23> Drag and Drop the Query1 object into the first space and Query2 into the second space in the join.

Step 24> Double-Click the yellow join icon to open the Join Relationships form.

Step 25> Click the New Link button.

Step 26> Select the objectid field from the list in Query1 and Query2.

Step 27> Change the Cardinality to 1..1 for both Query1 and Query2, then Click OK.

Step 28> Double-Click the Query3 object on the report to specify fields for Query3.

Step 29> From the Insertable Objects panel, Select fields to report on, then Drag and Drop them into the Query Explorer panel.

Step 30> Select Page Explorer, then page 1.

Step 31> Click the Data Items Tab.

Step 32> Scroll down to Query3

Step 33> Select all the fields from Query3, Drag and Drop them onto the report.

Step 34> Save the report.

Test this Cognos Report

Step 01> In the Map Client, Select some map features.

Step 02> Click Generate Report.

Step 03> Select the new report and Click Generate.


Cognos Report Template - Insert FIQ