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.
With the Gl Journal Cube open in Excel, click the New Sheet button.
A new sheet is displayed.
NOTE: Cell A1 should be selected.
Click the Insert tab.
The Insert menu ribbon is displayed.
Click the PivotTable button.
The Create Pivot Table popup is displayed.
Click the Use an external data source option.
Click the Choose Connection... button.
The Existing Connections popup is displayed.
Click the QA_JOURNAL_TRANSACTIONS_CUBE link.
Click the Open button.
Click the OK button.
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.
The Amount column is displayed.
Click and drag the UGAFUND option in the PivotTable Fields menu into the Filters box.
The UGAACCTREE column is displayed.
The UGAFUND column is displayed.
Click and drag the JOURNAL_DATE option in the PivotTable Fields menu into the Columns box.
Under the Class filter options, click the More Fields option.
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.
The UGAACCTREE menu is displayed.
Click the UGAACCTREE: All drop-down menu.
Click the All tree item.
Click the 000000 - Accounts tree item.
Click the 100000 - Assets tree item.
The UGAFUND menu is displayed.
Click the UGAFUND: All drop-down menu.
Click the UGA_FUND - UGA_FUND tree item.
Click the ENDOWMENT - Endowment Funds tree item.
Click the 40000 - Endowment Funds tree item.
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.
To hide the column, click the Remove Grand Total menu.
To filter by Fiscal year, click the Amount: Column Labels drop-down menu.
To remove current values, click the deselect (Select All) option.
Click the 2021 tree item.
Click the Ok button.
The GL Journal Cube is displayed with FY 2021 UGA Endowment data.
Additional Information: