Over query limit while integrating google maps
Hi
I am getting over query limit error when i want to display more than 11 records while integrating google maps in obiee. I can display upto 11 records in the map.If i increase the row limit its throwing the error.
Error: Geocode was not succesfull for the following reason: Over_query_limit
How to overcome this error,in order to fetch more than 11 records in the map?
I have only two columns in the report
state code || No.Of Customers
In narrative view i have the following code
Replace ?!? with <
Prefix part
?!?script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false">
?!?/script>
?!?script type="text/javascript">
var geocoder;
var map;
function initialize() {
geocoder = new google.maps.Geocoder();
var latlng = new google.maps.LatLng(37.4219720, -122.0841430);
var myOptions = {
zoom: 8,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
GetMapAdress ();
}
function showAddress(address,comment) {
if (geocoder) {
geocoder.geocode( { 'address': address}, function(results, status) {
if (status == google.maps.GeocoderStatus.OK) {
map.setCenter(results[0].geometry.location);
var marker = new google.maps.Marker({
map: map,
position: results[0].geometry.location
});
var infowindow = new google.maps.InfoWindow({
content:comment
});
google.maps.event.addListener(marker, 'click', function() {
infowindow.open(map,marker);
});
} else {
alert("Geocode was not successful for the following reason: " + status);
}
});
}
}
function GetMapAdress (){
Narrative:
showAddress('@1', ' No Of customers are @2');
Postfix part:
}
?!?/script>
?!?script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.js" type="text/javascript">?!?/script>
?!?script type="text/javascript">
$(document).ready( function(){initialize();return false;});
?!?/script>
?!?body onunload="GUnload()">
?!?div id="map_canvas" style="width: 800px; height: 700px" > ?!?/div>
?!?/body>
This gives the count as per the state in the google map, if we click a state it will show us the count, but its holding good only for 11 records in the map
Appreciate your response