Accessing the Job Position Monthly Snapshot (People Cube)

Enter " oir.uga.edu " into your browser's search bar to navigate to UGA's available institutional reports page.

The UGA Office of Institutional Research page is displayed.

Click the Operational Reports section.

The Central Authentication Service (CAS) page is displayed.

After entering your credentials, click the LOGIN button.

The Operational Reports page is displayed. The reports associated with the Financials tab are shown as the default.

Click the HCM/Personnel tab to access the Job Position Monthly Snapshot (People Cube).

The reports associated with HCM/Personnel are displayed.

Click to open the Job Position Monthly Snapshot / "People Cube" section.

Click the Job Position Monthly Snapshot ("People Cube") link.

A popup window displays allowing you to open the Job Position Monthly Snapchat file with Excel or save it to your computer.

To open the file with Excel, click the OK button.

The Job Position Monthly Snapchat Excel file opens in a protected view.

Click the Enable Editing button to edit the file.

A Security Warning displays informing you that external data connections have been disabled.

Click the Enable Content button.

You can see two tabs at the bottom of the page:

1. Notes : On the Notes tab, you can view information that helps you understand the data in the People Cube, including its functionalities and limitations. The Notes page contains important information that should be reviewed before continuing.

2. Template : The Template view defaults to the People Cube. You can set up your table to view data for your department or unit.

Click the Notes tab.

The People Cube shows static data as of the last day of the month for previous months. Only those who have an active HR status on the last day of the month show up in the People Cube.

Note: If a person started and quit in the middle of the same month, the person will never show up in the data. For example, if a person started on August 5th and left on August 20th, this person will not show up in the People Cube.

For the current month, the snapshot changes every day to include updated data and the data is up-to-date through two days prior. For example, if you select September 20, 2019, the data will be up-to-date through September 18, 2019.

The Position Count parameter is the only measure that is not a calculated member. Position Count must be included in the Pivot Table to use the Drillthrough functionality.  

Finish reviewing the information, then click the Template tab at the bottom of the page to work with the data.

On the Template page, click any light blue cell to activate the PivotTable Fields.

Example shown here:  2019-Aug cell.