Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Item

Who

Notes

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)

  • 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

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 

User Defined Functions (UDF) with your Metadb reporting database

Stephan 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

...