Page Comparison

Attendance

Attendance & Notes

• Today's attendance-taker: Linda (or substitute)

• See attendance list at bottom of page
  

Announcements and Reminders

Sharon

Announcements:

• About the Reporting SIG meeting schedule

  • Meetings are held on the first 4 Mondays of each month at 11:00 am Eastern U.S. time (see this time in your time zone). The first and third Mondays focus on Reporting Development topics, and the second and fourth Mondays focus on Reporting Business topics. 

  • "business" means topics like presentations on reporting functionality and new features, new reporting applications, surveys and studies on reporting, etc.

  • "development" means working on derived tables and report queries for the folio-analytics GitHub repository

  • "workshopping" queries could be scheduled during any of these meetings, and it would be great to have topics and/or questions in advance so we can prepare to walk through the answers/approaches, such as "how to I fix this inventory query to get rid of the duplicates?" or "what is the best way to calculate totals in this finance query?" 

• December 23 meeting is canceled

• Important Upcoming Changes to LDP software support:

  • end of support is May 2025

  • see Mike Gorrell at Index Data for questions

  • institutions running LDP on a reporting database are encouraged to move to running Metadb software
    

Ongoing Topics:

• Workshopping your queries

  • part of each Reporting SIG business meeting will be devoted to time to work through any query questions you may have

  • please reach out to Christie Thomas if you have a question you would like to "workshop" during an upcoming Reporting SIG meeting

• Impacts of New Fields and Features (Sharon)

  • Are there any new fields or features we should know about from any of the functional areas that may impact reporting?

  • Review and update the Impacts of New Fields and Features on Reporting grid 

• Upcoming Reporting SIG meeting topics (tentative)
  

  • Moving from LDP to Metadb

  • Updates from the Data Array Extraction for Metadb 1.4 Workgroup

• Any new members?

  • Welcome/introductions

• How to find our latest recordings

  • Recording details available on our Reporting SIG Meetings and Notes page and Reporting SIG Subteam Meetings page

SIG Recruitment:

We will need to be recruiting for a variety of roles in the coming months. Please consider whether you would be interested. Please reach out to Scott Perry or Sharon Markus with any questions.

• Representative for the Documentation Working Group 

  • urgently needed

  • work with reporting documentation team to  update Reporting section of FOLIO documentation for each FOLIO software release 

  • see https://docs.folio.org/docs/reporting/

• Query developers

  • ongoing need

  • work on derived tables and report queries for the FOLIO Analytics repository and to support Metadb

  • see https://github.com/folio-org/folio-analytics

User-Defined Functions (UDF) with your Metadb reporting database

Stephan Stefan Dombek

Stefan Dombek will give a presentation on implementing “User-Defined Functions (UDF): An introduction and comparison to derived tables” with your Metadb reporting database.

• UDF (User-Defined Function)

  • Explanation

  • Define your own function

  • Use of UDF in a query

• Comparison to derived tables

  • Performance

  • Derived tables vs. UDF

Slides: https://docs.google.com/presentation/d/1Emn3tERFwaQw-_1DlLYJhuKEA4XONwXFPWiav6n5U3E/edit?usp=sharing