Data Warehouse: Financial Reporting & Transaction Inquiry Overview

Data Warehouse Financial Reporting & Transaction Inquiry Overview

Sources:
Office of Budget & Resource Planning
Accounting Services
Chancellor’s Office

California State University, Fresno – Office of Budget & Resource Planning

Finance Data Warehouse Phase 2 Upgrade

  • One of the main features of Finance Data Warehouse Phase 2 upgrade is the consolidation of three “Data Warehouse” dashboards – Manage My Budget, Operations, and Management Reporting – into two streamlined dashboards:
    • Financial Reporting – Manage My Budget, Management Reporting, and Operations report pages have been consolidated/relocated here with enhanced functionality.
    • Transaction Inquiry – all transaction inquiry pages are now located on this dashboard with a wider arrangement of filters and column selectors.
    • NOTE: Data is one day old!

Log in to the Data Warehouse

  • Log into My Fresno State Portal
  • Select CFS Datawarehouse

My Fresno State Portal homepage with the CFS Datawarehouse tile highlighted.

Log in to the Data Warehouse

  • Below is the default screen with Dashboard icons

Data Warehouse home screen showing the available dashboard icons.

Getting Started - Dashboards

Or you can click the Dashboards drop down menu to display a list of available dashboards

Dashboard Choices:

  • Financial Reporting
  • Firms Gaap
  • Sponsored Programs
  • Transactions Inquiry
  • Tree Reporting

Data Warehouse dashboard menu showing the list of dashboard choices.

Your Primary Choices

  • Your primary choices:
    • Financial Reporting
    • Transaction Inquiry

Your Primary Choices:
Financial Reporting
Transaction Inquiry

Dashboard menu highlighting Financial Reporting and Transaction Inquiry as the primary choices.

Getting Started – Establish Default Settings

  • Select Business Unit
  • Select Standard Budget
  • Click Apply

Data Warehouse settings screen showing the Business Unit, budget ledger, scenario, and Apply controls. Business Unit and Standard Budget selections shown in the Data Warehouse settings screen. Data Warehouse settings controls, including the Apply button. Dropdown showing the ORIGINAL budget scenario selection.

Save Current Customization

  1. Click Options Dropdown
  2. Save Current Customization

Financial Reporting dashboard options menu with customization controls.

Make the Customization the Default

  1. Save as “FRSNO”
  2. Click the option “Me”
  3. Check the box “Make this my default for this page”
  4. Click “OK”

Save Current Customization dialog showing the FRSNO name, Me option, default checkbox, and OK button.

Getting Started – Manage My Budget as of Period

  • The Basics: one Dept, one Fund report
  1. Set Filters:
    • Business Unit- FRSNO
    • Fiscal Year – accept default or make your selection
    • Period – accept default or make your selection
    • Account Type – normally defaults to 50 & 60
    • Budget Ledger – normally defaults to Standard Budget
    • Fund
    • Department

Manage My Budget as of Period

  • Set Business Unit, Fiscal Year, Period, Account Type, and Budget Ledger
  • Set Fund and Department
  • NOT filters: Fund, Dept, Prog, Class & Not Acct Cat – use these filters if you do not want certain items included on the report…603811-603819 benefits
  • Click Apply Filters

Manage My Budget filter screen showing standard filters, NOT filters, and the Apply Filters button.

Save the Report Customization

  1. Save your file by clicking the drop-down menu, select “Save Current Customizations”, name your file, and select “Me”
  2. Click “OK”

Save Current Customization dialog over the Manage My Budget page. OK button shown in the Save Current Customization dialog.

Report Results

Manage My Budget report results table with selectable columns and financial amounts.

Enhanced Report Results Features:

  • Reports will default to three visible columns
  • Hide/unhide columns for up to as many as six columns
  • Add/remove subtotals to any and all columns, as needed.
  • Just as in the old version, results can be stored as a Saved Customization.

Manage My Budget results screen showing the first three report columns and additional hidden column options.

New Feature: Hide and Display Columns

  • To Hide – simply click the drop-down menu on that column, click “Hide” and click “OK” for your selections to apply.
  • To Display/add column – simply click the drop-down menu on the column you want to display and make your selections and click “OK” to apply the column values and generate the report.

Column selector dropdown in Manage My Budget showing available fields and the Hide option.

New Feature: Add/Remove Subtotals

  • The first two columns in every report are formatted to display subtotals.
  • To add subtotals:
    • Place cursor at the top of column where you want to add subtotals to
    • Right click on yellow column heading to access the Columns shortcut menu.
    • Choose “Show Subtotal” and “> after values”
  • To remove subtotals:
    • Place cursor at the top of column where you want to remove subtotals from
    • Right click on yellow column heading to access the Columns shortcut menu.
    • Choose “Show Subtotal” or “None” to remove

Columns shortcut menu showing Show Subtotal options in the report table.

Drilldowns Improvement

  • Drill down columns have been reformatted to have priority columns on the left, so they are easier to view.
  • Additional fields have been added for Actuals and Budget drilldowns.
  • Budget does not include PO or other Actuals specific columns
  • Drilldown columns align on the left to the extent possible.

Actuals Drilldown Columns

Actuals drilldown table showing priority columns positioned on the left.

Budgets Drilldown Columns

Budgets drilldown table showing budget transaction columns positioned on the left.

New Dashboard: Transaction Inquiry

Transaction Inquiry dashboard home page with report categories and report index.

New Dashboard: Transaction Inquiry

  • Open PO Report: Set your filters and apply

Open PO Report filter screen with Apply Filters control.

New Dashboard: Transaction Inquiry

  • Open PO Report: Results
  • Save

Open PO Report results table and dashboard menu with Save Current Customization selected.

New Dashboard: Transaction Inquiry

  • Actuals Transactions
  • Actuals Reporting by Attributes

Actuals Reports index listing Actuals Transactions and Actuals Reporting by Attributes.

New Dashboard: Transaction Inquiry

  • Actuals by Period

Actuals Transactions by Period report with filters and transaction results.

New Dashboard: Transaction Inquiry

  • Actuals Reporting by Attributes

Actuals Reporting by Attributes screen with filters, column selectors, and transaction results.

New Dashboard: Transaction Inquiry

  • Budget Transactions
  • Budget Reporting by Attributes

Budget Reports index listing Budget Transactions and Budget Reporting by Attributes.

New Dashboard: Transaction Inquiry

  • Budget Transactions

Budget Transactions report with filter controls and transaction results.

New Dashboard: Transaction Inquiry

  • Budget Reporting by Attributes

Budget Reporting by Attributes report with filters, column selectors, and budget results.

New Dashboard: Transaction Inquiry

  • Encumbrance Transactions
  • Encumbrance Reporting by Attributes

Encumbrance Reports index listing Encumbrance Transactions and Encumbrance Reporting by Attributes.

New Dashboard: Transaction Inquiry

  • Encumbrance Transactions

Encumbrance Transactions report showing filters and encumbrance transaction results.

New Dashboard: Transaction Inquiry

  • Encumbrance Reporting by Attributes

Encumbrance Reporting by Attributes report with filters, column selectors, and results.

Trial Balance Selections

  • This report is best used for Fund only views
  • Prompt filter has down arrow. It will default to current period and year unless it is a save selection report. (Hint: Save as Period 12)
  • Multiple Funds can be selected for this report. (Departments cannot be filtered in this)
  • Click Apply Filters

Trial Balance filters showing fiscal year, period, fund selection, and Apply Filters.

Report Filters – Fund Selection Criteria

  • Double-click on any value to move it into or out of the Selected box or use the arrow button.
  • Enter first number of Fund to list all with that beginning number.
  • Search is available in drop down box for ‘Starts’, ‘Contains’, ‘Ends’, and ‘Is Like’. Unselect Match Case for more options. It does not identify the description. There is limited criteria in the selection box. If your search contains more . Remember to select ‘Search’.
  • When more than 256 results, hit the “More” button to display the next 256 choices. Otherwise, you may not find your choice. It is easier to use the ‘Search’ than to scroll.
  • Click ‘Ok” to save.

Selection Buttons
Use the buttons below to move items into the Selected Box.

  • De-select all items.
  • De-select highlighted item(s)
  • Select all items listed
  • Select highlighted item(s)

Fund value selection dialog showing search criteria, selected values, selection controls, and the OK button.

De-select all items button. De-select highlighted items button. Select all listed items button. Select highlighted items button.

Trial Balance (6 columns)

  • This report is good to view the available cash balance
  • In the 6 Column Trial Balance, various columns can be added to suit different reporting needs

Six-column Trial Balance with report filters, configurable column selectors, and balance results.

Cash Balance Report

  • Choose your Fund Number

Cash Balance Report filter screen with the Fund selection field highlighted.

Cash Report

  • Balance will show in Cash column. Report will only show the Cash balance.

Cash report results with the Cash column displaying the balance.

Financial Summary As of Period

  • You can drill down for detailed information, in any field that shows an underline when you scroll over it

Financial Summary As of Period filters and results table with linked, drill-down fields.

Financial Summary Between Periods

  • Report is similar to Financial Summary As of Period, but it allows the user to choose periods to view

Financial Summary Between Periods report with period range filters and results.

Financial Summary by Year

  • Compares fields year by year. Periods and Department field can also be filtered.
  • Select years and periods to compare
  • Select Column order for the report
  • Shows amounts posted from year to year and it allows the user to drill down

Financial Summary by Year report showing year selections, column order, and year-by-year amounts.

Export and Print

  • Example is from Financial Summary As of Period
  • Refresh, Print, and Export options are at the bottom of the page

Financial Summary As of Period results with Refresh, Print, and Export links beneath the report.

Print to PDF

  • The Print hyperlink located beneath the report will print the individual report in either PDF or HTML formats. Both are similar

Print menu showing Printable PDF and Printable HTML options beneath the report.

Print to HTML Results

  • Printing to HTML provides a printout screen similar to a screenshot. The result is a smaller output which can fit to one page

HTML printout of a financial summary report displayed as a compact table.

Exporting Data

  • Exports all data on the screen to a variety of file formats including PDF, Excel, & CSV.
  • Exporting to PDF results in a file similar to the print to PDF, but it can be saved as a file.
  • Exporting to Excel presents the data in Excel along with report formats. Formulas are not transferred to Excel. It is only hardcoded numbers.
  • Tab Delimited and CSV files will open in Excel without any formatting and can then be saved as an Excel file. Be sure to save as an Excel file. This export may include more data than shown on the screen.

Export menu showing PDF, Excel, PowerPoint, Web Archive, and Data format choices.

Example of Export to PDF

  • This is a good tool to send the report to a manager
  • Select PDF as Export file type
  • After selecting the PDF file, a box will pop up asking to either open or save the file. Either option will work.
  • Click OK

Export menu with the PDF file type selected. File prompt showing options to open or save the exported PDF and an OK button.

Example of Export to Excel

  • Select Export to Excel. Then select the Excel 2007+ format.
  • After selecting the Excel file as output, a box will either open or save to file. Either option will work.
  • Click OK

Export menu with Excel and Excel 2007+ format selected. File prompt for the exported Excel workbook, showing open or save options and an OK button.

Example of Export to Excel Data Output

  • The data is downloaded into Excel. The formatting can be manipulated from this point and can be saved as an Excel file.
  • Formulas do not carry forward. Numbers are hardcoded.

Exported financial report data displayed in Excel, including hardcoded numbers and report formatting.

Example of Export to Data – CSV Format

  • Select Export to Data – CSV Format
  • Prompt will open the CSV file with Excel. There is also an option to save the file. Opening in Excel is recommended.

Export menu with Data and CSV Format selected. File prompt for the CSV export, showing the option to open it with Excel.

Example of Export to Data – CSV Format Output

  • The CSV file opens to Excel as unformatted data. It can be manipulated from this point. Data includes information such as additional fields which may not be seen on the original output screen.
  • Remember to save the file as an Excel file when finished formatting

CSV data opened in Excel as an unformatted spreadsheet with financial transaction fields.

Questions?

Contact Information

Office of Budget & Resource Planning

Jean Aguayo   jaguayo@csufresno.edu   559-278-7224
Lisa Chavez   lisachavez@csufresno.edu   559-278-5293
Jeffrey Blanks   jeffblanks@csufresno.edu   559-278-6123

Accounting Services

P.J. Soligian   pjsoligian@csufresno.edu   559-278-8133
Cherie Weber   cweber@csufresno.edu   559-278-4144

Download the PDF

This HTML version was generated with AI assistance and may contain errors or omissions. The original approved PDF remains the official document of record. An alternative accessible format is available upon request from the document creator in accordance with Title II of the ADA.