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.

OBIEE 11g Mapviewer 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.

<SpatialMaps>
<LayerDataLayout>
<MaxRecords>3500</MaxRecords>
</LayerDataLayout>
</SpatialMaps>

OBIEE 11g Mapviewer - modifying the instanceconf.xml file

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.

 OBIEE 11g Mapviewer - map of U.S. counties without errors

Have more questions? We can help:

 

eCapital Advisors

eCapital Advisors is one of the nation’s largest performance management and business analytics firms. Since 2001, we have been building long-term relationships and exceptional analytics solutions for leading organizations. With hundreds of clients in an array of industries, we have the experience, the solutions and the team to help meet your goals.

Comments are closed.