I ran across this error working in OBIEE 11g Mapviewer (“Some map formatting cannot be displayed”) while building a report that displayed dollars per county for the entire United States. After executing this report, not all the data for the counties would return. I received the following error.
As you can see, there are certain counties within states that are missing, and even some states not displaying any counties at all. It turns out that mapviewer has a default limitation of how many values that can be returned in a map. The default is less than 1000 but there are over 3000 counties in the United States.
To fix this, I added the following tag in the instanceconf.xml file.
3500
I saved the updated instanceconfig.xml file and restarted the BI Services. After the restart I reran my map of the United States. As seen in the screenshot below, all the expected counties are now returning in the map.
Have more questions? We can help:
- Contact us using the form here, or call us at 952.947.9300.
- Drowning in data but parched for predictive insights? Arrange a free half-day analytics health check.
- Talk to our experts face to face at one of our upcoming industry events.
