What is happening?

  • Access to the legacy tool BI Query (Student Data Warehouse) will be turned off on March 31

  • Approved users will continue to have access to the Student Data Warehouse through Jaspersoft

  • All users who would like to retain or gain access to Jaspersoft will need to apply and be approved by the appropriate data steward

Frequently Asked Questions

Yes! Winter term will be our time of transition. Starting in the new year, Jaspersoft will be available in CORE for approved users and BI Query will also remain on. During this time of transition, please make sure you have migrated all your reoccurring reports to either CORE or Jaspersoft. The BI Query tool will be disconnected from the SIS data on March 31st.

Both are ad hoc query tools that you can create standard reports with. Both are fed by the OSU Data Warehouse and contain the same data structures and the same names for the various objects. You can filter on any field.

Jaspersoft includes a drop down menu/list of values for the field selected. This makes searching and selecting values much easier (no more needing to remember specific codes!). One limitation of Jaspersoft is that it cannot query based on a list of IDs. For that functionality, users will need to use Ad Hoc CORE reports. The ability to cut and paste values into Jaspersoft is on the vendor roadmap, but not currently available.

In Jaspersoft you can build crosstabs, charts, and tabular reports all within the environment. You can also build your own dashboards.. In Jaspersoft you can do "report scheduling" to schedule when reports are run and delivered to users.

It is already built, it will be up to the data stewards as to who gets access.

It doesn't quite work like that. CORE is an environment with security levels designed to provide access to predefined reports. Jaspersoft is a querying tool that allows users to build reports and queries. Users will access Jaspersoft through CORE. Both the reports in CORE and the ones created in Jaspersoft are based on the same data source.

Tableau is another data tool. We will be connecting the same data warehouse models from Jaspersoft to Tableau in the future.

Yes. Jaspersoft will include access to recruitment data.

Access to Jaspersoft will be determined by the data steward for student data, which is the Office of the Registrar. All users who are interested in retaining or gaining access to the data warehouse through Jaspersoft will need to follow a request process that is currently being defined. This website will provide additional information as it is available.

November — December: Transition prep

  • IAR gathers queries that need to be migrated to CORE
  • Consultations with BI Query users
  • Users submit Jaspersoft access request forms

November 21, 2018

  • PREPARING FOR DATA WAREHOUSE TRANSITION
  • 10:30am - 11:15am - WebEx
  • OSU is transitioning to a new data warehouse tool, Jaspersoft, for student data. At this webinar, participants will have the opportunity to learn about the DW transition process, timeline and submit questions to be answered at the Data Warehouse Transition Public Forum on December 4, 2018.

December 4, 2018

  • DATA WAREHOUSE TRANSITION OPEN FORUM
  • 11:00AM - Noon - Memorial Union 109
  • OSU is transitioning to a new data warehouse tool and will be turning the Student BI Query Data Warehouse tool off on March 31st. At this open forum, Michael Hansen, IAR Executive Director and CDO, will share information about the process and answer any related questions.

December 31, 2018

  • Approved Jaspersoft users and early adopters have access to the data models in Jaspersoft
  • Jaspersoft training and testing with approved users begins
  • IAR begins development of new and modified CORE reports to meet user needs for units that will not have access to Jaspersoft

December 31, 2018 - March 31, 2019

  • Training and testing of new models in Jaspersoft
  • New Reports developed in CORE
  • Additional training, drop in hours, and user support

 March 31, 2019

  • BI Query tool is formally retired and disconnected from OSU data.
  • Jaspersoft is the new BI Query tool for student data at OSU