Setting up the GL Journal Cube - UGA Endowments

Summary

In this article, you will learn the steps to setup the Gl Journal Cube with UGA Endowment data in Excel.

Body

   Overview   

This tutorial demonstrates how to re-create the UGA Endowments view of the of the General Ledger (GL) Journal Cube. The GL Journal Cube, available in the Data Warehouse, can be used to review posted transactions over a given spending period. It provides actuals information at the summary and detail levels. It downloads as an Excel Cube with Pivot Table functionality. 

To access the General Ledger Journal Cube, you must be signed into the VPN using 02 Restricted access. The OIR homepage can be accessed at https://oir.uga.edu/ and you can reach the report using the Operational Reports link. You can also access the report at reports.uga.edu.

 

In this article, you will learn the steps to setup the Gl Journal Cube with UGA Endowment data in Excel.

1. Step 1

step image

With the Gl Journal Cube open in Excel, click the New Sheet button.

2. Step 2

step image

A new sheet is displayed.

NOTE: Cell A1 should be selected.

Click the Insert  tab.

3. Step 3

step image

The Insert menu ribbon is displayed. 

Click the PivotTable button.

4. Step 4

step image

The Create Pivot Table popup is displayed.

Click the Use an external data source option.

5. Step 5

step image

The Create Pivot Table popup is displayed.

Click the Choose Connection...  button.

6. Step 6

step image

The Existing Connections popup is displayed.

Click the QA_JOURNAL_TRANSACTIONS_CUBE link.

7. Step 7

step image

Click the Open button.

8. Step 8

step image

Click the OK button.

9. Step 9

step image

A blank PivotTable is inserted. To begin setting up the cube, you will need to select the appropriate PivotTable Fields.

Click and drag the Amount option in the PivotTable Fields menu into the Values box.

10. Step 10

step image

The Amount column is displayed.

Click and drag the UGAFUND option in the PivotTable Fields menu into the Filters box.

11. Step 11

step image

The UGAACCTREE column is displayed.

Click and drag the UGAFUND option in the PivotTable Fields menu into the Filters box.

12. Step 12

step image

The UGAFUND column is displayed.

Click and drag the JOURNAL_DATE option in the PivotTable Fields menu into the Columns box.

13. Step 13

step image

Under the Class filter options, click the More Fields option.

14. Step 14

step image

Additional options under the Class filter are displayed.

Click and drag the Class ID Descr option in the PivotTable Fields menu into the Rows box.

15. Step 15

step image

The UGAACCTREE menu is displayed.

Click the UGAACCTREE:  All drop-down menu.

16. Step 16

step image

Click the All tree item.

17. Step 17

step image

Click the 000000 - Accounts tree item.

18. Step 18

step image

Click the 100000 - Assets tree item.

19. Step 19

step image

Click the OK button.

20. Step 20

step image

The UGAFUND menu is displayed.

Click the UGAFUND:  All drop-down menu.

21. Step 21

step image

Click the All tree item.

22. Step 22

step image

Click the UGA_FUND - UGA_FUND tree item.

23. Step 23

step image

Click the ENDOWMENT - Endowment Funds tree item.

24. Step 24

step image

Click the  40000 - Endowment Funds tree item.

25. Step 25

step image

The Endowment Funds information is displayed. The Grand Total column is populated with sums across the row and not useful in the endowment view.

 Right-click the Grand Total cell.

26. Step 26

step image

To hide the column, click the Remove Grand Total menu.

27. Step 27

step image

To filter by Fiscal year, click the Amount: Column Labels drop-down menu.

28. Step 28

step image

To remove current values, click the deselect (Select All) option.

29. Step 29

step image

Click the 2021 tree item.

30. Step 30

step image

Click the Ok button.

31. Step 31

step image

The GL Journal Cube is displayed with FY 2021 UGA Endowment data.

Additional Information:

To access the General Ledger Journal Cube, you must be signed into the VPN using 02 Restricted access. The OIR homepage can be accessed at https://oir.uga.edu/ and you can reach the report using the Operational Reports link. You can also access the report at reports.uga.edu.

 

Details

Details

Article ID: 149533
Created
Sat 9/24/22 11:16 PM
Modified
Tue 11/5/24 11:30 AM