The University of Cincinnati used Oracle Business Intelligence Enterprise Edition (OBIEE) and BI Publisher to create the automatic form. A data model was created in OBIEE which was then used in a BI Publisher Report. A report template mock-up of the original form was created in Microsoft Word with the BI Publisher plugin and was then populated with sample data from the data model. The BI Publisher report has repeated grouped section and displays a student’s full name, registered classes for a term, cumulative GPA, among other information. Using an OBIEE dashboard, the report can be run for multiple students at the same time.
Alliance Presentation Summary

When there are several report developers on a data analytics team using Oracle Business Intelligence Enterprise Edition, it can be easy to run into conflicts. For example, someone is testing a new calculated column in the RPD, if they restart the development machine, the other users can no longer build their reports until the development machine is back up. Migrating reports can also be tedious using the archive/unarchive process.

The University of Cincinnati has implemented a multiuser development strategy that uses Github enterprise across individual developer virtual machines with Oracle Business Intelligence Enterprise Edition installed, and a testing environment allowing developers to develop RPD and catalog components independently while allowing end users to test on a system that is only restarted on a release cycle.

The RPD has a built-in multi user development, but it requires checking in and out and using a configuration file. The University of Cincinnati uses Github Desktop and Github Enterprise and the RPD saved as MDS XML. This allows multiple users to make changes to the RPD at the same time as long as different items are being modified. There is no need for checking in and out and no need for a configuration file. The changes are tracked and no special commands are necessary.

In this session, the University of Cincinnati will review the typical development environment, the development environment and the reporting development life cycle at the University of Cincinnati. A demonstration will also be given toward the end of the presentation. The University of Cincinnati will display how Github Desktop and Github Enterprise works with the RPD MDS XML file structure. Github Enterprise history of the changes will be discussed. Git conflict resolution will be shown. RPD security will also be demonstrated.

A data dictionary is a tool that every organization would like to have and is inevitably hard to keep up with. Some organizations use Excel Spreadsheets, web applications with backend databases, or proprietary products. The University of Cincinnati has built a data dictionary using the RPD and Oracle Data Integrator eliminating the use of extra tools.