Use below function
geography::STPointFromText(‘POINT(‘ + CAST(longitude AS VARCHAR(20)) + ‘ ‘ + CAST(latitude AS VARCHAR(20)) + ‘)’, 4326) as geo_location
find better solutions for analytics world
Use below function
geography::STPointFromText(‘POINT(‘ + CAST(longitude AS VARCHAR(20)) + ‘ ‘ + CAST(latitude AS VARCHAR(20)) + ‘)’, 4326) as geo_location
ibm cognos rave visualization
Below links provide good information about rave visualization and customization.
Below articles provide good information about rave
https://www-01.ibm.com/support/docview.wss?uid=swg21973160
cognos analytics heat map display numbers with total
https://www.ibm.com/developerworks/community/forums/html/topic?id=8205c888-235e-4922-b2a2-2b5964b61862&mhq=heatmap%20display%20values&mhsrc=ibmsearch_a
at following url you can find rave visualization customizer / sample visualzations and rave visualization customize –
https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=9685c9a6-3133-4823-85e8-f5f81268267a#fullpageWidgetId=W561990aafebc_4d8b_9af8_7c03c0081265
heatmap display values with totals:
https://www.ibm.com/developerworks/community/forums/html/topic?id=8205c888-235e-4922-b2a2-2b5964b61862&mhq=heatmap%20display%20values&mhsrc=ibmsearch_a
few useful links
https://www.cognoise.com/index.php?topic=22417.0
http://www-01.ibm.com/support/docview.wss?uid=swg21989490