Oracle Magazine - May/June 2011

Now you can create your map: locate 4. the Views panel at the bottom left of the screen, and select New View -> Map. When the map view is displayed, select OBIEE_SF_MAP1 from the list of maps shown at the top of the view.

The new map view is now ready for 5. editing. A panel on the right-hand side enables you to define map formats. Click the Delete button next to the default OBIEE_CIT Y map layer to remove it from the list of formats, because you will create your own format in the following steps. Then click the Add New Map Formats button to add an image map format, using a custom point layer. This will enable you to place icons on the map, based on latitude and longitude coordinates.

In the Image (Custom Point Layer) dialog 6. box that appears, enter the following settings to place the stores in your sample data set on the map:

X (e.g. Longitude) : Longitude
Y (e.g. Latitude) : Latitude
Tooltips : Longitude,

Latitude, Revenue

: Revenue

: Percentile Binning

: 3

to the Map Formats panel and delete the default map format. Click the Add New Map Formats button, but this time select Pie Graph from the list of formats. Then, when prompted, select OBIEE_STATE from the list of map layers available.

In the Pie Graph dialog box that appears, 5. set the following for the pie charts:

Vary Image By
Bin Type
Tooltips
Bins

In the Select Image dialog box, select the Red, Yellow, and then Green circles (traffic lights) for the 0-33%, 33%-66%, and 66%-100% bins, respectively.

Click 7. OK to finish this map definition. Then use the pan and zoom buttons on the left-hand side of the map to locate downtown San Francisco, as shown in Figure 1.

You have now created your first map view.

Once you have viewed the map, click the Home link at the top of the common header menu to return to the Oracle Business Intelligence Enterprise Edition home page.

next example, you will display a larger-scale map of the continental U.S. and place pie charts over the states in which the company operates, with the charts showing the breakdown of sales across product categories.

To create this map, do the following:
From the 2. Subject Areas panel on the
left-hand side of the screen, choose the
following columns to add them to the
Selected Columns area:
: Country and
State Code;
Revenue

Dim Stores. Country and State Code
Dim Products.Product Category
Fact Sales.Revenue

Click OK to save the settings, and then with the map view displayed, use the pan and zoom buttons to display the U.S. West Coast. Locate Oregon on the map, place your cursor over the pie chart, and then click the legend. Note that the state name and the product categories are all hyperlinks—you can use these to pass filter values to other analyses, as you will see in a moment. For now, though, save this map to the Presentation Server catalog, using the name Country and State Map.

CREATING THEMATIC MAPS
Your first map, OBIEE_SF_MAP1, used x and
y coordinates to plot the location of your
stores in the San Francisco Bay Area. In this
Because you will be mapping stores
located in all of the company’s U.S. territo-
ries, you do not need to apply a filter to the
selection criteria.