IBM Cognos Map Issue

[mpervez]

Hi Community

I need  help to resolve Cognos Map issue.

the following is cognos Map log :


RSV-RND-0094

The map chart data contains references to missing region names.
Map file: 'world.cmf', missing region names: 'Abha, AlKar'ah, AlRonah, AlSodah, Arar, Baha, Buraidah, Dammam, Hail, Jeddah, Jizan, Khamis Mushait, Khobar, Madina, Mekkah, Najran, Qasim, Riyadh, Sakaka, Tabuk, Uhod Rofaidah'.

Review the chart data and the map dictionary.



RSV-SRV-0042 Trace back:RSReportService.cpp
(759): RSException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp
(258): RSException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp
(848): RSException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
(305): RSException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp
(904): RSException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp
(591): RSException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(323): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp
(79): RSException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(417): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp
(178): RSException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp
(314): RSException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(177): RSException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(151): RSException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(417): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSChartAssembly.cpp
(279): RSException: CCL_RETHROW: RSChartAssembly::assembleRom/Charting/RSCGSCustomAxisChart.cpp
(1572): RSException: CCL_THROW: RSCGSCustomAxisChart::validateMapChartData()

[MFGF]

Hi Community

I need  help to resolve Cognos Map issue.

the following is cognos Map log :


RSV-RND-0094

The map chart data contains references to missing region names.
Map file: 'world.cmf', missing region names: 'Abha, AlKar'ah, AlRonah, AlSodah, Arar, Baha, Buraidah, Dammam, Hail, Jeddah, Jizan, Khamis Mushait, Khobar, Madina, Mekkah, Najran, Qasim, Riyadh, Sakaka, Tabuk, Uhod Rofaidah'.

Review the chart data and the map dictionary.



RSV-SRV-0042 Trace back:RSReportService.cpp
(759): RSException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp
(258): RSException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp
(848): RSException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
(305): RSException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp
(904): RSException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp
(591): RSException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(323): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp
(79): RSException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(417): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp
(178): RSException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp
(314): RSException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(177): RSException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(367): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(151): RSException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp
(417): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSChartAssembly.cpp
(279): RSException: CCL_RETHROW: RSChartAssembly::assembleRom/Charting/RSCGSCustomAxisChart.cpp
(1572): RSException: CCL_THROW: RSCGSCustomAxisChart::validateMapChartData()

Hi,

What this appears to be telling you is that you are providing data values to the map that it does not accommodate. The list of values it does not recognize is shown in your error message. Your options are:

a. Either get the map to ignore these values by changing the "Ignore Data with No Features" property to Yes
b. Or filter these values out of your query
c. Or convert these values to values the map does recognize using the Dictionary property
d. Or modify the map alias values within the map file using Map Manager to tie these values to countries it does recognize

The names it is complaining about appear to be city names, not country names? Have you ensured you are using the correct data item to feed into the region layer of the map? The World Map generally expects countries...

MF.

[mpervez]

Hi ,

Yes I agree with you that this values are of cities


I list of Cities in my Data Source

Which map should I select to present

[MFGF]

Hi ,

Yes I agree with you that this values are of cities


I list of Cities in my Data Source

Which map should I select to present

Which country / continent do the cities pertain to? That would be a good place to start.

You can see the layers in a map if you open it in Map Manager - you will see that the World Map contains layers called "Cities", "Capitals" and "Countries + Territories". You can then see whether the values in these layers tie in with the values in your data, and if necessary you can add alias values that match your data values. You can't add new values (eg cities that are not represented already) though. It's quite possible that there are no standard maps shipped with Cognos that contain all the values you need. If so, your options are:

a) Go to the MapInfo website to see if a suitable map already exists - you can then pay the cost and download it, then open it with Map Manager and save it as a Cognos Map file.
b) Purchase the MapInfo authoring software from Pitney Bowes and create the exact map you need. As above, open it with Map Manager and save as a Cognos Map file.
c) Look at an alternative technology such as ESRI maps or Google Maps

Cheers!

MF.

[mpervez]

Dear,


I am working on Saudi Arabia cites

1. How to open Map Manager, is it desktop application or what
2.  please proved me url of MapInfo site
        I try it with www.mapinfo.com it redirect me to
          http://www.pitneybowes.com/us/location-intelligence.html

[mpervez]

Hi MFGF,

      Hope you are doing well, Dear I am trying to reslove  map issue with Google Map API

  The report Specification is as follows

<report xmlns="http://developer.cognos.com/schemas/report/7.0/" useStyleVersion="10" expressionLocale="en-us">
   <modelPath>/content/package[@name='GO Sales and Retailers']/model[@name='model']</modelPath>
   <drillBehavior modelBasedDrillThru="true"/>
   <queries>
      <query name="Query1">
         <source>
            <model/>
         </source>
         <selection><dataItem name="Country" aggregate="none" rollupAggregate="none"><expression>[gosales_goretailers].[Sales branch address].[Country]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="City" aggregate="none" rollupAggregate="none"><expression>[gosales_goretailers].[Sales branch address].[City]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Address line 1" aggregate="none" rollupAggregate="none"><expression>[gosales_goretailers].[Sales branch address].[Address line 1]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
      </query>
   </queries>
   <layouts>
      <layout>
         <reportPages>
            <page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
               <pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
                  <contents>
                     <HTMLItem>
                        <dataSource>
                           <staticValue>&amp;lt;script src=""https://maps.googleapis.com/maps/api/js?key=Your_KEY&amp;callback=initMap"
      type="text/javascript"&amp;gt;&amp;lt;/script&amp;gt;
&amp;lt;div id="map" style="width: 700px; height: 400px"&amp;gt;&amp;lt;/div&amp;gt;
&amp;lt;script type="text/javascript"&amp;gt;
var map = new GMap2(document.getElementById("map"));
var geocoder = new GClientGeocoder();

function showAddress(address) {
   if (!geocoder) {
      return;
   }
   geocoder.getLatLng(address, function(point) {
      if (!point) {
         //alert(address + " not found");
         return;
      }
      map.setCenter(point, 1);
      var marker = new GMarker(point);
      map.addOverlay(marker);
      map.openInfoWindowHtml(map.getCenter(), address);
      map.addControl(new GSmallMapControl());
      map.addControl(new GMapTypeControl());
      map.checkResize();

   });
}

var firstTime=1;
function displayMap (address)  {
   showAddress(address);
   if(Number(firstTime) &amp;gt; 0 ) {
      firstTime = 0;
      //showAddress(address);
   }
}

&amp;lt;/script&amp;gt;</staticValue>
                        </dataSource>
                     </HTMLItem><list refQuery="Query1" horizontalPagination="true" name="List1">
                        <style>
                           <defaultStyles>
                              <defaultStyle refStyle="ls"/>
                           </defaultStyles>
                           <CSS value="border-collapse:collapse"/>
                        </style>
                        <listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Country"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Country"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="City"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="City"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Address line 1"/></dataSource></textItem><HTMLItem>
                                       <dataSource>
                                          <staticValue>&lt;script&gt;

AddMarker("' + [Query1].[Address 2] + ','+[Query1].[City] +', '+[Query1].[Country]+ '");

&lt;/script&gt;</staticValue>
                                       </dataSource>
                                    </HTMLItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Address line 1"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list>
                  </contents>
               </pageBody>
               <pageHeader>
                  <contents>
                     <block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
                        <contents>
                           <textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
                              <dataSource>
                                 <staticValue/>
                              </dataSource>
                           </textItem>
                        </contents>
                     </block>
                  </contents>
                  <style>
                     <defaultStyles>
                        <defaultStyle refStyle="ph"/>
                     </defaultStyles>
                     <CSS value="padding-bottom:10px"/>
                  </style>
               </pageHeader>
               <pageFooter>
                  <contents>
                     <table>
                        <tableRows>
                           <tableRow>
                              <tableCells>
                                 <tableCell>
                                    <contents>
                                       <date>
                                          <style>
                                             <dataFormat>
                                                <dateFormat/>
                                             </dataFormat>
                                          </style>
                                       </date>
                                    </contents>
                                    <style>
                                       <CSS value="vertical-align:top;text-align:left;width:25%"/>
                                    </style>
                                 </tableCell>
                                 <tableCell>
                                    <contents>
                                       <pageNumber/>
                                    </contents>
                                    <style>
                                       <CSS value="vertical-align:top;text-align:center;width:50%"/>
                                    </style>
                                 </tableCell>
                                 <tableCell>
                                    <contents>
                                       <time>
                                          <style>
                                             <dataFormat>
                                                <timeFormat/>
                                             </dataFormat>
                                          </style>
                                       </time>
                                    </contents>
                                    <style>
                                       <CSS value="vertical-align:top;text-align:right;width:25%"/>
                                    </style>
                                 </tableCell>
                              </tableCells>
                           </tableRow>
                        </tableRows>
                        <style>
                           <defaultStyles>
                              <defaultStyle refStyle="tb"/>
                           </defaultStyles>
                           <CSS value="border-collapse:collapse;width:100%"/>
                        </style>
                     </table>
                  </contents>
                  <style>
                     <defaultStyles>
                        <defaultStyle refStyle="pf"/>
                     </defaultStyles>
                     <CSS value="padding-top:10px"/>
                  </style>
               </pageFooter>
            </page>
         </reportPages>
      </layout>
   </layouts>
   <XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" ouutput="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><reportName>Test1</reporrtName></report>

Note : I replace key with Your_Key in the following line
             <staticValue>&amp;lt;script src=""https://maps.googleapis.com/maps/api/js?key=Your_KEY&amp;callback=initMap"





But It returns me the script it self and note the map

<script src=""https://maps.googleapis.com/maps/api/js?key=xxxxxxxxxxxxxxxxxxxxxxxxx&callback=initMap" type="text/javascript"></script> <div id="map" style="width: 700px; height: 400px"></div> <script type="text/javascript"> var map = new GMap2(document.getElementById("map")); var geocoder = new GClientGeocoder(); function showAddress(address) { if (!geocoder) { return; } geocoder.getLatLng(address, function(point) { if (!point) { //alert(address + " not found"); return; } map.setCenter(point, 1); var marker = new GMarker(point); map.addOverlay(marker); map.openInfoWindowHtml(map.getCenter(), address); map.addControl(new GSmallMapControl()); map.addControl(new GMapTypeControl()); map.checkResize(); }); } var firstTime=1; function displayMap (address) { showAddress(address); if(Number(firstTime) > 0 ) { firstTime = 0; //showAddress(address); } } </script>


Please help me out

[MFGF]

Dear,


I am working on Saudi Arabia cites

1. How to open Map Manager, is it desktop application or what
2.  please proved me url of MapInfo site
        I try it with www.mapinfo.com it redirect me to
          http://www.pitneybowes.com/us/location-intelligence.html

1. Yes, it's a client tool. It gets installed along with Framework Manager.
2. Pitney Bowes is the owner of MapInfo - rather like IBM is the owner of Cognos. :)

I have never used Google Maps with Cognos, sorry.

MF.