ODS Finance Access Challenge

Ad hoc Banner financial reporting uses the resources of the Banner ODS (Operational Data Store) which serves as a data warehouse. Banner production activity is uploaded on a daily basis to the ODS, so ad hoc reports are based on the previous day balances in production (live) Banner.

Creating reports from the Banner Finance tables loaded in the ODS requires a better than average knowledge of Banner field names, financial hierarchy and some familiarity with Business Intelligence reports or software. In the left navigation pane, under Banner ODS, are some links that may be of interest to those considering ODS reporting.

To ensure that individuals seeking ODS access understand the basic concepts necessary to produce accurate reports we require fiscal personnel to take an ODS Finance Access Challenge. Don't be intimidated by the name. The Challenge is meant to be a learning experience. Here's how it works:

You'll answer 20 questions about Banner Finance and reporting. If your answer is wrong, you'll be alerted and told the correct answer. At the end, if you have answered at least 80% of the questions correctly, you will be prompted to complete a form for access to the ODS and access to SAS Enterprise Guide software. If you answer less than 80% correctly, you will be redirected back to this page. You will have to take the Challenge again, but it is completely anonymous (until you pass) and you'll be armed with a better understanding of Banner and the Banner Finance ODS.

If you're ready for the ODS Finance Challenge click on the link below:

ODS Finance Access Challenge