OBIEE 11g Map Drill Down — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g Map Drill Down

Question
1
Views
0
Comments
BenS
BenS Rank 3 - Community Apprentice

I'm trying to create a drill down in OBIEE to drill from country to city on a map.  The dimension is already setup and the drill down functionality works in the table view:  Country w/ Count drill down to City w/ Counts for a country when I select on it.

Here is what I done so far:

  1. I create 2 layers in the Administration Manage Map Data
    1. Countries with the BI Key Column Country (as described above) from the appropriate subject area
    2. Cities with the BI Key Column Country (as above) and City (as described above) from the appropriate (same) subject area (countries drills down to cities in the dimension).  I use both the country and the city so that I get only cities associated with that country (in case cities w/ same name span multiple countries)
  2. I created a map (MapAndCountryMap) with 2 layers
    1. Country (defined by country name)
    2. City (defined by country and city name)
  3. Create a query with only the country column and totalCnt columns selected
    1. Run the query and in the table I can click on the country and it will drill down to the cities making up the country and associated counts
  4. I add a map to my analysis (described above where I have a country by country)
    1. I select MapAndCountryMap from the drop down list
      1. The map displays both countries and cities (which make up the 2 layers added to the map)
    2. I select "New Map Format" color fill for the Countries layer (which create 4 shaded quartiles for the map countries)
    3. I select Add New Map Format and Bulbble and associated with the Cities layer (I get a message that columns will be added which corresponds to the City I defined in the layer for this subject area)
    4. The map is rendered with the shaded countries by quartiles and the bubbles for the cities (it also displays cities that I don't have a match for not just the ones that I have matching)
    5. I select China and the popup for China is displayed and I click on the link for China which causes the map to drill down to China (graying out China).  The cities are still present but appear to be a layer below the country.  I can see the bubbles but when I hover over them I do not get any information related to the city (I still only get information related to China).
    6. I select Done and add the Map to my analysis
  5. When I select the map and select China it is grayed just like in the map report builder but again I cannot get to the cities which seem to lie beneath the country.

The drill down appears to stop at the Country and does not go to the city or at least it does not make the city available for analysis.  Can you please advise on how to make the cities come up when drilling down into the countries?

Please advise...