Prior to populating the geography dimension, you must set up the geography structures. See: Setting Up Geography

Run the HRI Load All Geography Category Structures concurrent program to populate the geography dimension with values. This concurrent program populates the location information stored in the HR_LOCATIONS_ALL table into a separate summary table.

Use the Submit Requests window.

   To populate the geography dimension:

1. Select Single Request in the Submit a New Request window.

2. In the Name field, select HRI Load All Geography Category Structures.

3. At implementation, use the following parameter values:

   Parameter	Value at Implementation
   Collect From Date	The earliest date required for geography information (default is one month previous)
   Collect To Date	The current date (default)
   Full Refresh	Yes (default is No)

4. Submit your request.

What's Next

Run this program when required to collect dates further in the future. For full information on this concurrent program, see: HRI Load All Geography Category Structures