Topic
  • 6 replies
  • Latest Post - ‏2013-09-19T06:30:50Z by divyanaidu
Pamoda
Pamoda
1 Post

Pinned topic Cognos 10 Location aware Reports

‏2012-02-22T05:19:40Z |
Are there any one who have experience with creating Cognos Location aware reports? :) :)

I have tried this with using the following link.

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ig_mob.10.1.0.doc%2Fig_mob_id1174mob_inst_location_aware_rpts.html

I have Setup the location.xml in the server according to the Steps to define report prompts based on GPS coordinates.

Questions :
1) how can i get the parameters defined in location.xml into the location aware report?
2) are there any special considerations to be done when creating a location aware report?
3) Are there any other configurations to be done for proj4? (which is not mentioned in the above link)

Please help. :( :(

Thanks in advance.
Updated on 2012-12-18T21:31:24Z at 2012-12-18T21:31:24Z by michael_iles
  • michael_iles
    michael_iles
    8 Posts

    Re: Cognos 10 Location aware Reports

    ‏2012-04-27T00:45:25Z  
    Hi Pamoda,

    1) how can i get the parameters defined in location.xml into the location aware report?

    The parameters in location.xml have names, and you use those same names as the name of the prompt field in the location aware report. When the report is run from a BlackBerry, if a prompt name in the report matches one fo the prompt names in location.xml then the system will attempt to automatically fill that prompt (i.e. answer it) using the device's location.

    2) are there any special considerations to be done when creating a location aware report?

    You just have to use the prompt names defined in location.xml.

    3) Are there any other configurations to be done for proj4? (which is not mentioned in the above link)

    No other configuration for proj4.

    Mike.
  • MauriMercol
    MauriMercol
    1 Post

    Re: Cognos 10 Location aware Reports

    ‏2012-05-31T13:07:27Z  
    Hi Pamoda,

    1) how can i get the parameters defined in location.xml into the location aware report?

    The parameters in location.xml have names, and you use those same names as the name of the prompt field in the location aware report. When the report is run from a BlackBerry, if a prompt name in the report matches one fo the prompt names in location.xml then the system will attempt to automatically fill that prompt (i.e. answer it) using the device's location.

    2) are there any special considerations to be done when creating a location aware report?

    You just have to use the prompt names defined in location.xml.

    3) Are there any other configurations to be done for proj4? (which is not mentioned in the above link)

    No other configuration for proj4.

    Mike.
    Hi Mike

    Could you show us your location.xml configuration as an example?

    Thanks in advance.

    Regards

    Mauricio
  • michael_iles
    michael_iles
    8 Posts

    Re: Cognos 10 Location aware Reports

    ‏2012-08-24T00:43:13Z  
    Hi Mike

    Could you show us your location.xml configuration as an example?

    Thanks in advance.

    Regards

    Mauricio
    Hi Mauricio, here's the location.xml included with the product:
    <?xml version="1.0" encoding="UTF-8"?>
    <!--
    Licensed Materials - Property of IBM
    BI and PM: Mobile
    (C) Copyright IBM Corp. 2007, 2012
    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
    -->
    <location>

    <!-- All providers with active='true' will be used, in sequence, to reverse-geocode WGS84 coordinates. -->

    <file active="false" filename="test1.data">
    <regex latitude='1' longitude='2'>
    ^(.*);(.*);(.*)$
    <capture-group index='3' name='name'/>
    </regex>
    </file>

    <!-- CA.zip from geonames.org. -->
    <file active="false" filename="CA_PPL.txt">
    <!--
    1 geonameid : integer id of record in geonames database
    2 name : name of geographical point (utf8) varchar(200)
    3 asciiname : name of geographical point in plain ascii characters, varchar(200)
    4 alternatenames : alternatenames, comma separated varchar(4000)
    5 latitude : latitude in decimal degrees (wgs84)
    6 longitude : longitude in decimal degrees (wgs84)
    7 feature class : see http://www.geonames.org/export/codes.html, char(1)
    8 feature code : see http://www.geonames.org/export/codes.html, varchar(10)
    9 country code : ISO-3166 2-letter country code, 2 characters
    10 cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
    11 admin1 code : fipscode (subject to change to iso code), isocode for the us and ch, see file admin1Codes.txt for display names of this code; varchar(20)
    12 admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
    13 admin3 code : code for third level administrative division, varchar(20)
    14 admin4 code : code for fourth level administrative division, varchar(20)
    15 population : integer
    16 elevation : in meters, integer
    17 gtopo30 : average elevation of 30'x30' (ca 900mx900m) area in meters, integer
    18 timezone : the timezone id (see file timeZone.txt)
    19 modification date : date of last modification in yyyy-MM-dd format
    -->

    <regex latitude='2' longitude='3'>
    ^^\t*\t(^\t*)\t^\t*\t^\t*\t(^\t*)\t(^\t*)\tP\tPPLACG?\t(^\t*)\t
    <capture-group index='1' name="city"/>
    <capture-group index='4' name="country"/>
    </regex>

    </file>

    </location>

    That configuration file contains two <file> elements that describe how to parse a different file containing locations.

    Rather than a <file> element you can also use a <projection> element like this:

    <projection active="true">
    <proj4>
    +init=epsg:2248
    </proj4>
    <columns x="x_coord" y="y_coord"/>
    </projection>

    The contents of the <proj4> element can be any proj4 string (look online for instructions on how to format these and how to find one appropriate for your usage).

    The <columns> element gives the names of the prompt values to use in the Cognos report: a report that has prompt fields called 'x_coord' and 'y_coord' will work with the configuration above.
  • Oscar2800
    Oscar2800
    3 Posts

    Re: Cognos 10 Location aware Reports

    ‏2012-12-14T11:59:59Z  
    Hi Mauricio, here's the location.xml included with the product:
    <?xml version="1.0" encoding="UTF-8"?>
    <!--
    Licensed Materials - Property of IBM
    BI and PM: Mobile
    (C) Copyright IBM Corp. 2007, 2012
    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
    -->
    <location>

    <!-- All providers with active='true' will be used, in sequence, to reverse-geocode WGS84 coordinates. -->

    <file active="false" filename="test1.data">
    <regex latitude='1' longitude='2'>
    ^(.*);(.*);(.*)$
    <capture-group index='3' name='name'/>
    </regex>
    </file>

    <!-- CA.zip from geonames.org. -->
    <file active="false" filename="CA_PPL.txt">
    <!--
    1 geonameid : integer id of record in geonames database
    2 name : name of geographical point (utf8) varchar(200)
    3 asciiname : name of geographical point in plain ascii characters, varchar(200)
    4 alternatenames : alternatenames, comma separated varchar(4000)
    5 latitude : latitude in decimal degrees (wgs84)
    6 longitude : longitude in decimal degrees (wgs84)
    7 feature class : see http://www.geonames.org/export/codes.html, char(1)
    8 feature code : see http://www.geonames.org/export/codes.html, varchar(10)
    9 country code : ISO-3166 2-letter country code, 2 characters
    10 cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
    11 admin1 code : fipscode (subject to change to iso code), isocode for the us and ch, see file admin1Codes.txt for display names of this code; varchar(20)
    12 admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
    13 admin3 code : code for third level administrative division, varchar(20)
    14 admin4 code : code for fourth level administrative division, varchar(20)
    15 population : integer
    16 elevation : in meters, integer
    17 gtopo30 : average elevation of 30'x30' (ca 900mx900m) area in meters, integer
    18 timezone : the timezone id (see file timeZone.txt)
    19 modification date : date of last modification in yyyy-MM-dd format
    -->

    <regex latitude='2' longitude='3'>
    ^^\t*\t(^\t*)\t^\t*\t^\t*\t(^\t*)\t(^\t*)\tP\tPPLACG?\t(^\t*)\t
    <capture-group index='1' name="city"/>
    <capture-group index='4' name="country"/>
    </regex>

    </file>

    </location>

    That configuration file contains two <file> elements that describe how to parse a different file containing locations.

    Rather than a <file> element you can also use a <projection> element like this:

    <projection active="true">
    <proj4>
    +init=epsg:2248
    </proj4>
    <columns x="x_coord" y="y_coord"/>
    </projection>

    The contents of the <proj4> element can be any proj4 string (look online for instructions on how to format these and how to find one appropriate for your usage).

    The <columns> element gives the names of the prompt values to use in the Cognos report: a report that has prompt fields called 'x_coord' and 'y_coord' will work with the configuration above.
    Hi, is it possible to have both configurations in the location.xml file?
    So use a file ("regiondata.txt") in combination with a filter ?Mobile_City?
    and a projection with <Proj4> for ?x_coord? and ?y_coord? ?
    Regards,
    Oscar
  • michael_iles
    michael_iles
    8 Posts

    Re: Cognos 10 Location aware Reports

    ‏2012-12-18T21:31:24Z  
    • Oscar2800
    • ‏2012-12-14T11:59:59Z
    Hi, is it possible to have both configurations in the location.xml file?
    So use a file ("regiondata.txt") in combination with a filter ?Mobile_City?
    and a projection with <Proj4> for ?x_coord? and ?y_coord? ?
    Regards,
    Oscar
    Yes you can have multiple providers active at the same time, using different parameter names as you describe.
  • divyanaidu
    divyanaidu
    2 Posts

    Re: Cognos 10 Location aware Reports

    ‏2013-09-19T06:30:50Z  

    Hi All,

     I have a question. I tried implementing the same. I am getting an error after setting up the location.xml file on server and restarting the services. Unfortunately Mobile Service is not working properly. Do we have to download any proj.4 specification files and place them on server before referring them in the location.xml file? Please help me with the implementation part.

    Thanks in advance.

     

    Updated on 2013-09-19T06:31:24Z at 2013-09-19T06:31:24Z by divyanaidu