Accessing the Job Position Monthly Snapshot (People Cube)

   Overview   

The Job Position Monthly Snapshot (also known as the People Cube) can be accessed in the Data Warehouse by UGA employees with either the System Manager or Job Data View roles in OneUSG Connect.

You must be connected to the VPN using 02 Restricted access to view the information.

In this article, you will learn the steps to download and view the Job Position Monthly Snapshot (People Cube) from the Data Warehouse.

Note: Start by connecting to your VPN 02 Restricted. Then, open a browser of your choice.

1. Step 1

UGA browser homepage displayed with the search field highlighted

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

2. Step 2

UGA Office of Institutional Research page displayed with the Operational Reports section highlighted

The UGA Office of Institutional Research page is displayed.

Click the Operational Reports section.

3. Step 3

Central Authentication Service (CAS) page displayed with the LOGIN button highlighted

The Central Authentication Service (CAS) page is displayed.

After entering your credentials, click the LOGIN button.

4. Step 4

Operational Reports page displayed with the HCM/Personnel tab highlighted

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).

5. Step 5

Reports associated with HCM/Personnel page displayed with the Job Position Monthly Snapshot / "People Cube" link highlighted

The reports associated with HCM/Personnel are displayed.

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

6. Step 6

Reports associated with HCM/Personnel page displayed with the Job Position Monthly Snapshot / "People Cube" link highlighted

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

7. Step 7

Popup window displayed with the OK button highlighted

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.

8. Step 8

Job Position Monthly Snapchat Excel file displayed with the Enable Editing button highlighted

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

Click the Enable Editing button to edit the file.

9. Step 9

Security Warning displayed with the Enable Content button highlighted

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

Click the Enable Content button.

10. Step 10

Job Position Monthly Snapchat Excel file displayed with the Notes tab highlighted

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.

11. Step 11

Job Position Monthly Snapchat Excel file displayed with the CONTENTS: instructions cell 2-4 highlighted

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.

12. Step 12

Job Position Monthly Snapchat Excel file displayed with the CONTENTS: instructions cell 6 highlighted

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.  

13. Step 13

Job Position Monthly Snapchat Excel file displayed with the Template tab highlighted

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

14. Step 14

Job Position Monthly Snapchat Excel file displayed with the Position Count and Employee Count sections highlighted

On the Template page, the People Cube is displayed with default filters set to the previous month for the calendar date, H1000351 - EITS-VP Office for the HR Department, and Seated for the Vacant Position Flag.

The displayed columns include Position Count and Employee Count.

Note: The Position Count is not always the same as the Employee Count . The Position Count shows the positions for which funding is available. The Employee Count shows the current seated positions.  

15. Step 15

Job Position Monthly Snapchat Excel file displayed with the 2019 Aug cell highlighted

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

Example shown here: 2019-Aug cell.

16. Step 16

Job Position Monthly Snapchat Excel file displayed with the Pivot Table field highlighted

The PivotTable Fields section appears on the right side of the page.

You can build up your own table by dragging the desired fields into the four quadrants (FILTERS, COLUMNS, ROWS, and VALUES).   
Print Article