Page Comparison

{anchor:top}
{toc:class=contents}
h2. Getting Started
{styleclass: Class=topLink}[top|#top]{styleclass}
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 databases you wish to query for reporting.

h3. GIS from a Non-GIS Supported Database
Not all databases support GIS natively.  However, Yellowfin can convert VARCHAR fields into polygons.  So if your data base does not have a GIS field type you can still store your GIS polygons in that database as a VARCHAR.

This Section shows you how to format a field with a polygon stored as a VARCHAR.
{section}
{column:width=30%}
*1.* Double Click the *Geo Polygon* to format the field and set the geometry.  You will see that it is a CLOB field type.

*2.* Navigate to the *Data Conversion* tab for the Conversion.	
{column}
{column:width=70%}
!41.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*3.* Select the *WKT Geometry Converter* from the list.	
{column}
{column:width=70%}
!42.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*4.* Set the format as *Longitude/Latitude*, the Cache Field to *Country* (this should be a unique identifier for the polygon).

*5.* Click *Add* to add the converter to the field.

!add.png!
{column}
{column:width=70%}
!45.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*6.* You should now see the *WKT Geometry Converter* in the Converters list. 	
{column}
{column:width=70%}
!46.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*7.* If you return to the Definition tab you will see that under the Data Type there is now a Converted Data Type of *GIS Geometry* listed.

*8.* *Save your* field. You can now begin creating your report.	

!save.png!
{column}
{column:width=70%}
!47.png|thumbnail,border=1!
{column}
{section}
 

h3. GIS from a Supported Database
If your data source supports GIS columns such as MySQL, Oracle, PostgreSQL or MS SQL Server 2008 you can connect to these directly for reporting. 
This type of field is not available in the Tutorial database but below is a quick guide to setting the field types at the view.  
{section}
{column:width=30%}
*1.* Once you have attached your fields to the view double click the field to set the GIS Format.

As seen on the right the field is a GIS Multi Polygon.	 
{column}
{column:width=70%}
!4.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*2.* Navigate to the Format tab and set the Format to either *Latitude/Longitude* or *Longitude/Latitude* depending on the order of the points within the data.

*3.* *Save* the field settings and then save your view.  You are now ready to use these fields for reporting.	

!save.png!
{column}
{column:width=70%}
!5.png|thumbnail,border=1!
{column}
{section}

 
h2. Creating a GIS Map
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Click {color:#357CB6}Create{color} to build a new report.

*2.* on the *Create* link and select *Report* to begin building your report.
{column}
{column: width=70%}
!01z.png! 
{column}
{section}

{section}
{column: width=30%}
*2.* You should now be on the Initialise Report page. Select the *Ski Team* source andDrag and Drop Builder* as the build tool.
{column}
{column: width=70%}
!02z.png! 
{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski Team* view.	as the View.

*4.* Now click the !step_right_on.png! button to proceed.
{column}
{column: width=70%}
!22a.png|thumbnail,border=1! 
{column}
{section}

{section}
{column:width=30%}
*35.* Drag in the *Country* and *Geo Polygon* fields.

*46.* Now drag in your metrics, in this example *Invoice Estimate* is used three times, as a *MIN, MAX,* and *AVERAGE*.

*57.* Set the report to display as a *Chart Only*.

*68.* Click the !step_right_on.png! Next image to continue.
{column}
{column:width=70%}
!48.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*79.* On the output page click on the Chart Icon to edit the chart and set up your GIS Chart.
{column}
{column:width=70%}
!12.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*810.* From the Chart Menu select *Map*. Next, select the *GIS Map* type.  Click *Save* to save your selection.

!save.png!
{column}
{column:width=70%}
!49.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*911.* You will now see the Chart Data section updated with fields relevant to GIS Maps.

*1012.* Select:

GIS Field: *Athlete Geo Polygon*
Metric: *Max Invoice Estimate*
Label: *Athlete Country*

*1113.* Click *Refresh* to generate the map.

!refresh.png!
{column}
{column:width=70%}
!50.png!
{column}
{section}

{section}
{column:width=30%}
*1214.* In the Chart Format options, select *Visible Series Selection*.	
{column}
{column:width=70%}
!51.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*1315.* You should now have a map like the one pictured here. Much like the raster map, this one needs resizing so that the legend is closer to the highlighted areas.
{column}
{column:width=70%}
!52.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*1416.* Now add a layer to the map that will fill in all the country polygons that contained no data.

*1517.* Click on the !rpt_add.gif! {color:#357CB6}Add Layer{color} link

*1618.* Select the *GIS World Background* report that comes with Yellowfin.	
{column}
{column:width=70%}
!53.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*1719.* Set the colour of the new layer to a light grey and click *Refresh*.

!refresh.png!

*1820.* You should now have a map that looks like this.

*1921.* Save and Close your map.	
{column}
{column:width=70%}
!54.png|thumbnail,border=1!
{column}
{section}
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}