Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Over query limit while integrating google maps

user13358091Dec 2 2010 — edited Dec 2 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details