To open GoogleMaps window, select ID or name of component in the Dashboard Components and set GoogleMaps in Type field.

1. Paste an SQL query in the SQL box. It cannot exceed 8000 characters.

   

   Besides other data, the query must include longitude and latitude. Use the data that can be found in the Subjects register..

   Right-click and select Edit in SQL Editor command from the menu.

    

2. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data.

   After selecting this option, click Apply SQL. You have to click it also whenever you change an SQL query.

   

3. Click Apply SQL.
4. Select type In Marker Type box (columns or markers).
5. Set columns for width, legth (coordinates), value and description (e.g. width -> anWidth, length -> anHeight, description -> anDesc, value -> anValue).

   

   Set value can range from 0 to 100 and that is why it has to be entered as percentage of maximum value in query expression. It can be calculated using the following formula:

    

6. To display multiple data series obtained from various SQL query columns, add a new record in Link Data and follow the procedure mentioned in the previous item. Add new records using down arrow key , or .

7. Set filter.

                                                                                       

   Take care to set criteria wisely. Typically, the filter is equivalent to the WHERE statement in SQL query.

   You can set filter only in ME and MF editions.

    

8. Check Use "Total" for dashboard component.
9.             
10. To display markers according to the set zoom level, check Group. When zooming in, markers get displayed gradually (that is, by a rule of proximity - how many markers is already displayed in that area). All markers will be displayed using zoom level 13 or more. Maps can be loaded faster when greater volume of data are involved.

                                                                                                  

11. Enter name of GoogleMaps component (e.g.: Customer Geographical Distribution).
12. Enter any description for component in the Descr. field.
13. Click Add Markers.
14. Click to confirm it.

You must have Internet connection to use GoogleMaps component. If GoogleMaps is not available: check your Internet connection, or delete temporary Internet files. For more information visit: https://maps.google.com/support/bin/answer.py?hl=en&answer=21849

To set longitude or latitude in Subjects visit following links: https://www.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html https://world.maporama.com/

ZEUS topics in the PANTHEON 5.5 Guide:

• Dashboard Components - GoogleMaps
• ZEUS Dashboard

Related topics:

• Create a Component