Assign a Map Layer to a Data Column

Assign a map layer to a data column to use it consistently in any workbook.

You can assign a map layer to a column that contains text or numeric attributes, for example, columns such as Airport Name, Latitude, and Longitude. When you select a data column with a map layer assignment for a visualization, Oracle Analytics automatically creates a map visualization.

1. On your home page, hover over a workbook, click Actions, and select Open.
2. Click Data.
3. In the Data Diagram, select the dataset that contains the column that you want to prepare and click the dataset's Edit icon.
   If the dataset contains multiple tables, the Dataset editor is displayed and you'll see the Join Diagram with a tab for each table. Select the table that contains the column you want to prepare to open it in the transform editor.
4. In the transform editor, click Options for any numeric or text attribute column, and then click Location Details.
5. In Location Details, review the associated map layer and select a different one if required, then click OK.
   
   
   Description of the illustration maps-location-details-dialog-map-layer.png
   
   
   The property change is listed as a Change Property step in the Preparation Script pane.
6. Depending on your dataset, in the Preparation Script pane click Apply Script, or, on the toolbar, click Save Dataset.
   The updated column displays the location icon indicating that the location preference has been set.
7. In the Properties pane for the updated column, click Location to verify the map layer associated with the column.
   In Visualize, in the Data pane, the column is now identified with the same location icon and is treated as a location rather than a numeric or text attribute.