2024-01-22 Reporting SIG Meeting notes

Announcements/Reminders

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 

FOLIO Analytics Update

• Poppy and FOLIO Analytics 1.7 were both released in December.

Metadb Update

• see important bug announcement for Metadb
• https://github.com/metadb-project/metadb/issues/58
• from Nassib: It is recommend that users not rely on transformed tables that are generated from any table containing more than one jsonb column. The most likely fix for this bug in the short term is that such transformed tables will be removed.
• (from Tod) There should be a way to interrogate the Postgresql schemata to find out which tables have more than one JSONB column
  • can use the `information_schema.columns` view
• Only one table known so far re: #58: folio_entities_links.instance_authority_linking_rule

Upcoming meeting topics (tentative)

• Lehigh's use of the Reporting App, Lisa McColl, Feb 1 (Thursday)
• Metadb version 1.2 release overview (February)
• See Stefan about updating dates using the FOLIO calendar as a reporting feature
• See Axel about BibControl, reporting application, aggregates library numbers with UI, interested in using Metadb, would like to import eusage data directly

Any new members?

• Welcome/introductions

• Representative for the Documentation Working Group
• Query developers - possibly from Index Data?
• FOLIO Analytics Review Board 

Meeting time and frequency discussion

Proposed Revised Structure

In the interest of reducing the current number of reporting meetings and some other consolidation efforts, we propose changing the structure for reporting meetings and work as follows:

• ACQ/ERM and RA/UM/MM report development groups merge into Metadb FOLIO User Group. Reporting SIG meetings would have regular time for lab work for workshopping query questions.
• Metadb FOLIO User Group, through Nassib’s continued leadership, will be used to work on folio-analytics development in preparation for each FOLIO (flower) software release, will cover new reporting methods and features, will replace the Query Review Board, etc. This meeting would also have regular time for lab work for workshopping query questions. This meeting could be combined with other projects at some point (e.g., Reshare). 
• Reporting SIG meetings would be consolidated to meeting twice per month at 11am ET on the second and fourth Mondays of the month. Reporting SIG meetings would continue to cover ongoing topics of interest to the reporting community. Reporting SIG meetings would also have regular time for lab work for workshopping general query questions. 
• The D-Reporting development group would continue meeting as a separate report development group. 

-great idea, nice to have everyone in the same room

-would be good to have meeting with Reporting SIG and D Reporting group

-Scott and Sharon will follow up on Slack and an email announcement for any further comments

-consider adding wiki cookbook updates to documentation group

New Metadb Section added to Folio Analytics Wiki

A review of Stefan's newest addition to our documentation on FOLIO Analytics: under the General section, he has added a cookbook on how to query data from Metadb using SQL. 

PC Update