...

Yellowfin has the capability to render GIS data (points and polygons) into an image which can be overlaid with your report data. To enable GIS reporting you must have GIS data available in the database you wish to query for reporting. 

Chart data options

GIS from a Non-GIS Supported Database

Not all databases support GIS natively. However, Yellowfin can convert varchar convert varchar fields into polygons. So if your database does not have a GIS field type, you can still store your GIS polygons in that database as a varchar.

...

1. Edit the view of your dataset, and jump to the Prepare step.
2. Click on the dropdown menu of the varchar field, and select Convert.
   Image Removed
   Image Added
   
   
3. Once the converter popup appears, select WKT Geometry as the converter type.
   
   Image Modified
   
   
4. Your selection will navigate you to the next screen. Set the text format as Longitude/Latitude.
5. Next choose the Cache Field. This should be a unique identifier for the polygon.
   
   Image Modified
   
   
6. Click Save.
7. On the next page, you will see a message stating the conversion.
   
   Image Modified
   
   
8. You can also delete any applied conversions by hovering over them, and clicking on the delete icon.
   
   Image Modified
   
   
9. Click Close to exit the converter.
10. Publish the view to save these updates. Now you can begin creating your GIS report.

...

How to use a GIS Map

This tutorial demonstrates how to use a GIS map with your dataset. 

1. Click on the Create button and select Report to begin building your report.
   
   
   
   
   
2. Select your preferred View containing the GIS data. For the purpose of this example, we will choose Ski Team.
   
   
   
   
   
3. When at the Report Builder page, add your required data, including the GIS and metric data fields to the report. For example, we will use the Athlete Geo Polygon, and Sum Invoiced Amount fields in our report.

4. Click below to see an optional formatting tip to display geopoint or geo polygon data is its original form.
    

   Expand
   title Formatting tip...
   By default, the report builder formats geopoint or geo polygon data to ‘Default Geometry’ (so it’s displayed like in the example below). However you can view geo points or polygons in their original form by changing the formatting.  To do so, click on Format in the geopoint column menu, then select Edit. Image Added Then select ‘Raw Formatter’ from the Format field in the popup. Image Added Close the popup. The geopoint data will be visible in its original form in the report. Image Added Warning: Note that applying raw formatting on a large geopoint or geo polygon data set, may slow your report’s processing time.

   //Additional tip on formatting GIS data - maybe link to it on a separate page

   
   

5. Navigate to the Charts page, and expand the chart selection menu. Choose GIS Maps from this selection.
   
   
   
   
   
6. Next, fill the required fields for your GIS chart, for example drag Athlete Geo Polygon to the Geo Field component. You can refer to the above Chart Data Options section for a description of all the fields.
7. You will be able to see your GIS map chart. The polygons will be colored based on the value of the Color field.
   
   Image Modified
   
   
8. The above example shows the default background image (World image) of the GIS map that provides context to the location.
9. You can hide this image by configuring the map settings. There’s two ways to do so:
   1. Click Chart SettingsSettings, expand Style, and disable the GIS Base Layer toggle.
   2. Go to Administration >  Content Setting >  Maps Settings and disable the GIS Base Layer toggle.
10. You can also use the chart formatting settings to further configure your Google chart. Refer to our chart formatting section for more information.
11. Or you could add a layer to your map chart. Learn more about this here.
12. Once done, save your map.

{ add config here: https://wiki.yellowfinbi.com/display/user80/Chart+Formatting#ChartFormatting-ChartSettings > Style
GIS Base Layer - Display or hide a base layer under your GIS map to provide location context.}

Adding

...

map

...

layers

Once you have created a primary map, you can add additional layers on top. Each layer can contain a different detail, giving you a chance to build upon your map. 

Here’s how to add a layer to your GIS map:

1. Click on the + button on the bottom-right of the screen (for a GIS map, this provides extra options, as opposed to only creating a new chart).
   
   Image Modified
   
   
   
2. When the following popup appears, choose one of the two options to add a layer to your map:
   -
   • New Map Layer - Existing Report Data: Use this option if you new layer will use data already in this report.
   -
   • New Map Layer - Geographic Pack Data: Use this option if you want to use data from a Geographical pack in the new layer. Note that you can get ready-made geographical packs from the Marketplace to add to your Yellowfin instance.
     
   Image Removed
   • 
     Image Added
     
     
   • If you selected the Existing Report Data option, then your selection will create a new layer in the chart builder, with existing field data. Drag these fields to the chart components to create the chart layer, much like you would with any chart.
     
     
   • Alternatively, if you selected a Geographic Pack, then the chart builder will display data from the selected Geopack. You can create your map layer by using this data.
     
     Image Modified
     
     
     
   • Once the map layer is created, you’ll be able to see its icon at the bottom of the chart builder, differentiating it from the main or primary map.
     Image Removed
     
     Note: learn more about the GIS Settings option in the chart formatter here

...

1. .
   
   Image Added