Geo tab in execution dashboard coming from which table

[VineeshP]

In dashboards, we have an execution dashboard
under that we have different tabs like overview, financials etc..
Out of those tabs, we have Geo tab too
I want to know that Geo tab is coming from which table and how to show the data in the Geo map in execution dashboard.

[fknell]

Hi @VineeshP, 

The Geo tab in the Execution Dashboard (Strategic Planning / Portfolio Planning) is not tied to a single “magic” table; it is a geomap visualization that reads location‑based data from your planning‑item or project tables, using a map source as the data layer.

Where the Geo tab data comes from

- The Execution Dashboard’s Geo tab typically visualizes planned cost, work items, or projects by location, pulling from tables such as:

   - sn_ppm_planning_item (planning items)

   - pm_project (projects)

   - or similar portfolio‑related tables that have location / address fields.

- The actual geomap widget uses a map source record (e.g., sys_map_source) that defines:

   - Which table to query.

   - Which field represents the location (e.g., location , address , or a custom location field).

How to show data in the Geo map

To ensure your data appears in the Geo map:

1. Check the map source

- Go to System Definition > Map Sources and look for the map source used by the Execution Dashboard Geo tab (often something like planned_cost_by_location or similar).

- Verify that:

   - The Table points to your planning‑item or project table.

   - The Location field is mapped to a valid location‑type field (e.g., location  or u_location.

2. Ensure location data exists on records

For planning items or projects to appear on the map, they must have a valid location (e.g., a filled location field or an address that can be geocoded).

Hope this helps... 

[Ankur Bawiskar]

@fknell 

Could you share screenshots supporting your comment?

I couldn't find the Map Sources under System Definition

[Ankur Bawiskar]

@VineeshP 

check in platform analytics dashboard and search that Dashboard

there the Geo tab must be present

Execution Dashboard in Portfolio Planning 

There must be some scheduled job which populates data or your instance should have Data in tables to show it in Dashboard

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏