Administrators set up map information so users can visualize and interact with data through maps.
Setting Up Maps for Dashboards and Analyses
As the administrator, you define how data columns modeled in Oracle BI Cloud Service display on maps. Once you have configured the map data, users can visualize data in analyses through map views.
Map views allow users to display data on maps in different formats and to interact with data. Oracle BI Cloud Service is configured with Oracle MapViewer, spatial boundary data, hosted maps, Oracle Database, and optionally Oracle Spatial. As an administrator, you must configure the metadata that defines the mapping between Oracle BI data and spatial data.
- On the Home page, click Console.
- Click OBI Classic Maps.
- On the Layers tab, click Import Layers from the toolbar.
- In the Import Layers dialog, select the connection in the Look in field and the layers that are needed for zooming and drilling. Click OK.
- Back on the Layers tab, select a layer and click the Edit Layer button. In the Edit Layer dialog, associate layers with columns so that users can display data in the map view.
Specifies the name of the layer that is displayed to users who work with map views.
Specifies which background map the layer originates from. Click Location to select a different layer.
Specifies the description of the map layer. This description is displayed when users are editing map views and they hover over the layer name in the Map Formats area.
Specifies the column of spatial data that you can associate with data for Oracle BI Cloud Service. Each column value corresponds to a "shape" that originates from the background map. For example, a MY_CITIES layer might have a layer key called CITY. The default value is a "best guess". Select the appropriate column from the list.
There are various reasons why a country such as Mexico might be drawn as a white area on a map:
The column has a null value for the country of Mexico, but a shape exists for Mexico in the spatial column.
The column has a value for the country of Mexico, but no shape exists for Mexico in the spatial column.
The column has a value for the country of Mexico and the shape exists for Mexico in the spatial column, but the names are mismatched. The data columns in Oracle BI Cloud Service might have the value MEX and the spatial column might have MXC.
BI Key Delimiter
Available only when multiple columns are specified for one key. Specifies a single ASCII character (such as a comma or underscore) to function as a delimiter for combining the data columns in Oracle BI Cloud Service that form a key.
Specifies whether the layer is a polygon, point, or line geometry layer. The type that you select affects the formatting that users can apply to the layer.
BI Key Columns Area
Specifies the columns of data in Oracle BI Cloud Service that you want to associate with the layer. You can have multiple columns associated with a single layer. You can select multiple columns from one subject area or from multiple subject areas. The columns and delimiter that you select must exactly match the name of the Layer Key value. Suppose the Layer Key value is STATE_CITY. You must select the STATE and CITY BI data columns and specify the underscore character in the BI Key Delimiter field.
Use the various options in this area:
Add — Displays the list of available subject areas. Select a subject area and select all the data columns that you want to associate with the layer.
Delete — Deletes the selected key column.
Edit — Lets you edit the data columns associated with a layer.
When a content designer creates a map view, a default main map is selected as the basis for that map view. If at least one data column from the analysis is associated with a layer that is associated with a main map, then that main map is selected by default.
Show Qualified Names
Specifies whether to display the fully qualified name of the column in the BI Key Columns Area or simply the column name.
You use this dialog to associate layers with BI data. If you use a specific column in multiple subject areas, then you must associate it with a layer for each subject area.
Note:Spatial features such as shape definitions are managed by database administrators for your service. If a shape geometry definition does not exist for a particular column value, then the shape cannot be shown on the map and might inhibit user interactions on the map.
- Click OK to close the dialog.
- Click the Background Maps tab, then click the Import Background Maps button.
- In the Import Background Maps dialog, select the connection in the Look in field and the main maps to use, then click OK.
The connection that you select for the main map can be different from the connection for the layers or images.
Description of the illustration map_layers2.gif
- See Editing Background Maps for the steps required to prepare the background maps.
See Editing Map Views in Using Oracle Business Intelligence Cloud Service.
Editing Background Maps
You edit background maps to ensure that users have a seamless experience with map views.
A background map is a non-interactive map that serves as a base for the map view. It might display a satellite image or a map with roads. The background map specifies the order of layers on the map view.
The ordering of map layers is very important. You must pay close attention to ensure that users have a seamless experience while navigating on the map (that is, drilling and zooming). In the Edit Background Map dialog, you assign each layer a minimum and maximum zoom range. Given that the map zoom slider can slide only from bottom to top vertically, the layers with lower minimum zoom levels are placed at the bottom of the slider. Ensure that the layer grid on the Interactive BI Layers section of the dialog follows a similar pattern, so that you place layers with lower minimum zoom levels at the bottom of the list.
Layer ordering becomes irrelevant when the zoom ranges of layers don’t intersect on the scale. Ordering becomes very important when layers have a common minimum and maximum zoom range. Use care to ensure that detailed layers aren’t hidden by the aggregated layers during drilling or zooming operations.
- Click Console.
- Click Map Data.
- On the Background Maps tab, select a map, then click the Edit Background Map button to display the Edit Background Map dialog.
- Specify the name and description of the map, which is displayed as a tooltip for the map when selecting a map from the list, when editing the map view.
- The Location field displays the location of the background map in the data source. Click Location button to change to a different map. If you select a background map that includes a different number of zoom levels, then the zoom levels are automatically adjusted for the layers that are associated with the map by scaling their ranges.
- Click the Add Layers button to display a list of the layers that have been imported on the Layers tab, then select the layers to add to the map. This button is unavailable when all layers from the Layers tab have been added to the background map.
When you add a layer that’s part of the map definition, the layer displays at its default zoom levels. If the layer is not part of the map definition, then specify the zoom levels yourself.
The layers are listed from bottom to top, in terms of how they’re applied to the map. A sample order is Countries, States, Cities. The lower level layers generally have the lower zoom levels. For example, if you have a States layer and a Cities layer, then include lower zoom levels for State than City.
Description of the illustration map_layers3.gif
- Click the Sort Layers By Zoom Level button to list the layers in ascending or descending order based on visibility on the map. This button is unavailable when layers are listed in the proper order.The sort order that’s specified here does not affect the order in which layers are applied on the map. Instead, the sorting order affects the zoom levels. For example, the States layer might have zoom levels 1 through 3 and the Cities layer has zoom levels 4 through 9. The lower layers have the lower zoom level numbers. The zoom levels that you specify correspond to the tick marks on the zoom slider on the map.You can include both layers that have been associated with a BI column by using the Edit Layer dialog and layers that have not been associated. Ensure that BI layers are ordered higher than non-BI layers. If a non-BI layer is ordered higher than any BI layers, then the non-BI layer is displayed on top of the lower BI layers on the map, which prevents the BI layers from being interactive.
- Click the Turn On Layer Visibility or Turn Off Layer Visibility button to control the visibility of layers on the map. Use the buttons to indicate whether the layer is visible in the Preview map in this dialog only. The layer is still visible on a map view. You can modify the zoom levels for a layer with a visibility turned off.
- Click a cell under a zoom level for a layer to affect the zoom level:
If you don’t set any zoom levels for a layer, then that layer does not display on the map.
If you click a blue cell that’s between other blue cells, then you see a popup menu with Clear Before and Clear After buttons, which allow you to change the zoom level in either direction. For example, if you click the cell for zoom level 4 and click the eraser on the right, then all cells to the right are cleared for that zoom level.
If you click a blue cell that at the end of a line of blue cells, then the cell turns white to indicate that it is no longer part of that zoom level.
If you click a white cell, then you increase the zoom level on either side of the existing blue cells. For example, suppose cells 4 through 6 are colored blue to reflect the zoom level. If you click in cell 2, then the zoom level becomes 2 through 6.
- Click the action icon beside the layer name to display a menu from which you can make various selections:
Delete — Removes the layer from this background map. The layer continues to be available on the Layers tab and can be added to this area again.
Move Up or Move Down — Moves the layer up or down so you can specify the order in which layers are applied to the map.
Reset to Default Visibility — Resets the current visibility range for this layer as defined in the underlying map definition. If this layer is not natively associated with the map, then this option is disabled for that layer.
- Use the yellow border that surrounds the column of boxes for a zoom level to determine which zoom level is currently displayed in the map area.
- Use the panning and zooming controls to specify how the map is displayed to users. If you hover over the zoom slider, then you see tooltips that specify the names of the layers that are currently associated with that zoom level.
- Click OK.