I have used the Navteq World_Sample data in OBIEE 11g and having some problems.
In the mapviewer console I can see the world map clearly and can zoom in etc.
From the DW I have created a table which is country_name against sale_amount to try and overlay these results on a map.
From the manage maps section in Answers I have configured the "layer" M_COUNTRIES with the country_name from my DW table as the BI key and then in "background maps" I have selected the world map.
However when I create a simple Analysis i.e. country_name against sale_amount and then create new map view then I am seeing the following error:
Oracle Fusion Middleware Mapviewer encountered the following errors
[MVThemeBasedFOIControl.foiLoaded] MAPVIEWER-05523: Cannot process response from MapViewer server. (MAPVIEWER-06009: Error processing an FOI request.
Root cause:FOIServlet:Missing IN or OUT parameter at index:: 1)
I cannot find much information with regards to resolving this error so I can see my data on the map.
Any help would be much appreciated!!!!!!
This question has been solved!
Basically you need to ensure the database schema where the data source (Navteq) has been imported must have the privilege "Create Type"
This comes from the Oracle manual extract as shown below:
18.104.22.168 Creating MapViewer Array Types, if Necessary
For each database schema that it connects to, MapViewer checks for the existence of
the following SQL array types that support array-type binding variables that might
exist in some predefined themes:
If these types do not exist, MapViewer attempts to create them in the database schema
associated with the MapViewer data source. However, if the user associated with that
schema does not have sufficient privileges to create new types, a privileged user must
create the types by connecting to the data source schema and entering the following
CREATE or REPLACE type MV_STRINGLIST as TABLE of VARCHAR2(1000);
CREATE or REPLACE type MV_NUMBERLIST as TABLE of NUMBER;
CREATE or REPLACE type MV_DATELIST as TABLE of DATE;