Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Edit Layer dialog

Use this dialog to edit a layer from the Layers tab of the "Administration: Manage Map Data page." One important task is to associate the layer of spatial data with data for Oracle BI EE.

Spatial data is managed in MapViewer and stored in an Oracle Database. To display data for Oracle BI EE on a map, you must associate a spatial layer with the appropriate columns of data from the Oracle BI Server. The combinations of BI data columns are referred to as "BI Keys." When you associate the layer of spatial data with data for Oracle BI EE, that layer becomes available for use with the specified columns in the specified subject areas.

For more information, see "Administering Maps" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.



Use this field to enter the name of the layer.


Displays the location of the layer in the data source from MapViewer. Click the Location button to display the "Import Layers dialog" for importing a different layer.


Use this field to enter the description of the layer, which is displayed in the following locations:

Layer Key

Use this box to select the column of spatial data from MapViewer to associate with data for Oracle BI EE. Each column value corresponds to a shape that is stored in the Oracle database. For example, a MY_CITIES layer might have a layer key called CITY. By default, the selected value is a "best guess" at the appropriate column. Use the list to select the appropriate column.

Click the Sample Data link to display an actual value for that column that you can use as an example.

If the box is empty, then the administrator must define the key column for the shapes in the spatial table for that layer in MapViewer. The map is drawn only where common values exist between the spatial data column and the associated column of Oracle BI EE data. Otherwise, the map might show a white area to indicate a missing value. To verify that common values exist for the two columns, display the column of Oracle BI EE data in the Oracle BI Administration Tool and review its values. In MapViewer, verify that the associated layer contains all the appropriate geometry definitions for the values in the corresponding column of Oracle BI EE data.

The following list provides the reasons why a white area might be drawn, using the country of Mexico as an example:

BI Key Delimiter

Available only when multiple columns are specified for one key. Use this field to enter a single ASCII character (such as a comma or underscore) to function as a delimiter for combining the BI data columns that form a key.

Geometry Type

Use this box to specify whether the layer is a polygon, point, or line geometry layer. The specification for a layer affects the formatting that can be applied to that layer.

BI Key Columns Area

Use this area to select the columns of data from the Oracle BI Server 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 as the delimiter for use in creating the BI Key to associate with the layer.

Click the following options:

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

Use this box to specify whether to display the fully qualified name of the column in the BI Key Columns Area or simply the column name.